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
Related questions
Hi Team, is there any script that can remove all versions of Ms Project from workstations
I have found one script for fetching office365 addin but for exporting the data to CSV is not working
Backup is not happening sccm database, getting error .ldf file is not readable , in short ldf and xml files are missing from backup while mdf file is there
What is the best way to restrict MECM clients to a specific server for all MECM needs?
SCCM: Recover Secondary Site to a different Hardware
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