microsoft.public.sms.inventory

SELECT
CS.Name0,
PB.SerialNumber0,
SE.SerialNumber0
FROM
v_GS_COMPUTER_SYSTEM CS LEFT OUTER JOIN v_GS_PC_BIOS PB ON CS.ResourceID =
PB.ResourceID
LEFT OUTER JOIN v_GS_SYSTEM_ENCLOSURE SE ON CS.ResourceID = SE.ResourceID
WHERE
CS.Name0 = @compname

Leave a Reply

Your email address will not be published. Required fields are marked *