![]() ![]() SELECT DISTINCT CS.Name0 AS ‘Computer Name’, CS.Manufacturer0 AS ‘Manufacturer’, CS.Model0 AS ‘Model’, BIOS.SerialNumber0 AS ‘Bios serial’, OS.Caption0 AS ‘OS Version’, The following SCCM report will provide Computer Name, Manufacturer, Model, Serial number, OS Version, Service Pack, Last logged on User, OS deployed date, Architecture, IP Address, Last Boot Time and Last H/W Scan for a nominated collection. SCCM Report for custom hardware inventory: Please note When you are copying a SQL query from a web browser you need to make sure that the browser is not adding any extra characters. If you see any errors in a report please post a comment so I can fix them. This post provides various SQL queries to generate custom SCCM reports (07/12) for reporting purposes.Īll of the queries from this post has tested in my lab.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |