looking for SQL / WQL query to get all client inventory
Question
Hello Everyone , I am looking for SQL query to find particular application installation status on all clients and client details , any other WQL will also work for me
Himanshu Pawar 
Leave an answer
Sorry, you do not have permission to answer to this question .
Answers ( 6 )
I think Ankit shared the SQL query in the following blog post
Does that help?
https://www.anoopcnair.com/sccm-application-deployment-custom-report-sql-query-configmgr/
Hi Sir , Thanks for your reply that is not fulfilling my requirement I want to get list of computers with Mimecast Security Agent installed and what their host name like information.
Try using the add remove program entry using the following query
https://www.anoopcnair.com/sql-query-to-findout-the-machines-with-ibm-or-oracle-related-applications-installed-along-with-location-and-country-details/
Thanks Anup sir
Hello,
You can use below SQL Query.Change the application name.
select v_R_System.Name0,v_Add_Remove_Programs.DisplayName0,v_Add_Remove_Programs.Version0
from v_R_System
inner join v_Add_Remove_Programs
on v_R_System.ResourceID=v_Add_Remove_Programs.ResourceID
where v_Add_Remove_Programs.DisplayName0 like ‘%Cisco%VPN%’
Thankyou for your response Ankit