When working with the reports in SCCM you may want a report to get all the serial numbers for all computers. Below is a very simple report which includes: Name, Manufacturer, Serial number, Model.
It will look like this:
SQL Satement:
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.ResourceID
Thanks for the tip. I added the SQL statement in reports and works great for our purposes !
Awesome thanks for sharing this!
Thanks. works good.
Worked great. Thanks. For some reason did not pick up serial numbers of our Lenovo s10-3’s???
Excelente aporte.
can we get some help how to run this
Works great, many thanks !!
This is awesome, worked really well. There isn’t by chance a way to get the serial numbers for the monitors too is there?
Thanks.
Muchas gracias por los tips… Thank You.
This works really well. Is there any way we can add the last logged on user for each system name listed, to this report?
can we report the serial number of softwares ?
If you want to collect the serial numbers for software, I’ve started to write some stuff about that, so far got Adobe products working and AutoCAD products…see here:
http://itguru82-sccm.blogspot.co.uk/2012/07/step-by-step-guide-to-creating-custom.html
Great tip. How can I also add the primary user to each row/device reported on?
Great tip. How can I also add the primary user (and IP address) for each row/device reported on?
Still useful. Thanks!
There is any way to get the serial number of the monitor attached to a CPU with SCCM?
Hi,
Yes there is, this works pretty well, http://exar.ch/collecting-monitor-serial-numbers-with-sccm/
/Jörgen