Warning: substr() expects parameter 1 to be string, array given in /home/byty/public_html/wp-content/plugins/wordbooker/wordbooker.php on line 1520

SQL Query to list products from SCCM Database

To list products that are installed on a Server using SQL Query to SSCM database you can use the Table v_GS_SoftwareProduct. This table contains “Lists the products found on each Configuration Manager client.”

select *
FROM v_r_system as vrs
join v_GS_INSTALLED_SOFTWARE as VIS on VIS.resourceid = vrs.resourceid
where
Name0 LIKE ‘%Server Name%’

A full list of the Tables is : https://technet.microsoft.com/en-us/library/dd334659.aspx

 

VN:F [1.9.20_1166]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.20_1166]
Rating: 0 (from 0 votes)

Leave a Reply