SOLVED SQL query to find the application installed

[Harshit Pandey]

Hi, I am looking for a sql query that lists the application installed (with version) from list of all computers in my organization. I am configuration manager and I know how to run the query from management studio. I just need the query. please help.

 

[Prajwal Desai]

You could try the below query.

Select Distinct
sys.Netbios_Name0,
sys.User_Domain0,
sys.User_Name0,
sys.AD_Site_Name0

FROM
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
WHERE
sys.ResourceID in (select sys.ResourceID
from
v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
where
DisplayName0 like '%AppName%'
and Version0 like 'version')
and sys.Operating_System_Name_and0 like '%workstation%'

 

[Harshit Pandey]

Thanks Prajwal. That worked like a charm.