Miscellany

public text v1 · immutable

#2073244

·published 2011-06-01 14:48 UTC


$Recordset.open("call _RA2011_All_PCINFO ('" & $DomainPc & "',@deviceout);", $Connection)

-- Mysql Routine:

DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `_ra2011_all_pcinfo`(IN DEVICE varchar(25), out deviceout varchar(25))
BEGIN
SELECT DEVICE, DOMAIN, IP, MAC, SerialNumber, Description, Tombstoned
FROM PCData WHERE DEVICE = (@DEVICE);
END