I was wondering if there is a way to do a search on SMS but by the Serial Number from the PC. I know you can do by IP address and/or hostname, but I need to know if I can do a search by serial number.
This will list all of the serial numbers in your db:
SELECT SYS.Netbios_Name0, SYS.User_Name0, SYS.Resource_Domain_OR_Workgr0, CSYS.Model0, BIOS.SerialNumber0, BIOS.SMBIOSBIOSVersion0 as 'SMBIOS' FROM v_R_System SYS LEFT JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM.ResourceID LEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceID LEFT JOIN v_GS_PROCESSOR Processor on Processor.ResourceID = SYS.ResourceID LEFT JOIN v_GS_PC_BIOS BIOS on BIOS.ResourceID=SYS.ResourceID LEFT join v_FullCollectionMembership fcm on fcm.ResourceID=SYS.ResourceID ORDER BY SYS.Netbios_Name0, SYS.Resource_Domain_OR_Workgr0
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.