We help IT Professionals succeed at work.

SSRS sccm: show all software of ALL pcs


I d like to have a daily or weekly sql ssrs report of ALL software users have on their pc (add/remove programs?) by querying our sccm 2012 server (latest version) plus number of installs per item/preferably also clickable that it shows the list of pcs per software.
Nice would also be to map it to sccm.itself: do.we have it in sccm (or was it installed nu user manually).

I d like to be able to exctact the data in Powershell so I can work with it. F.e. $alllsoft | get top 10 foreach ...

Watch Question

Database Analyst
You should be able to create your own reports as described here:
And for instance the query below

SELECT MIN(PRD.ProductID) AS ProductID, PRD.ProductName, PRD.ProductVersion, COUNT(DISTINCT PRD.ResourceID) AS 'Count'
FROM v_GS_SoftwareProduct PRD INNER JOIN v_FullCollectionMembership FCM ON PRD.ResourceID = FCM.ResourceID
WHERE FCM.CollectionID = 'SMS00001'
GROUP BY PRD.ProductName, PRD.ProductVersion
ORDER BY PRD.ProductName

Open in new window

from here: https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/dn581987%28v%3dtechnet.10%29
will give you the software inventory view schema by product name for the All Systems collection.

More details can be found at: https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/dn581933%28v%3dtechnet.10%29
and you should be able to easily pull available data into a datasource query or SQL stored Procedure to feed your SSRS reports.