Report to view all the serial number of the computers?
Hi,Anyone knows a report or a query statemente to view all the s/n of the computers?... I can't find anyone.Thanks.
March 18th, 2010 10:28am

Hi,One good report is found in Assett Intelligence category, Hardware 01A - Summary of computers in a specific collection. It will list the serial numbers.Kent Agerlund | http://scug.dk/members/Agerlund/default.aspx | The Danish community for System Center products
Free Windows Admin Tool Kit Click here and download it now
March 18th, 2010 11:53am

If you have Lenovo computers the Serial Number in the "Hardware 01A - Summary of computers in a specific collection" will show up blank. Changing the report to use v_GS_PC_BIOS.SerialNumber0 instead will solve that problem. Or you can try the following report, it will provide you computername, manufacturer, serialnumber, model number. SQL Query:select v_R_System.Name0, v_GS_PC_BIOS.Manufacturer0, v_GS_PC_BIOS.SerialNumber0,v_GS_COMPUTER_SYSTEM.Model0 FROM v_R_System JOIN v_GS_PC_BIOS on v_R_System.ResourceID = v_GS_PC_BIOS.ResourceID JOIN v_GS_COMPUTER_SYSTEM on v_R_System.ResourceID = v_GS_COMPUTER_SYSTEM.ResourceIDRegards,Jörgen
March 18th, 2010 3:13pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics