Tag: SCCM Reports

Report: Advertisement status for a specific adv. and collection.

Another report ;-)! There are many scenarios where I found that it would have been great to be able to track advertisement status for a specific advertisement per collection. For instance, if a manager places a service request that 40 computers at that department should have Office 2010 installed, it would be great to have a report showing the result per collection.     

Adding Serial Number to the “Computer information for a specific computer” report

I got this request from a customer and thought I could share it. Below query describes how to modify the query for the built-in report “Computer information for a specific computer” to include serial number.  The added sql commands are marked in red color if you want to change it yourself instead of copying the SQL