How to pull the reports to Application installed client systems
Question
Hi,
How will I found out application it was installed 500 systems 3 months over.
Example; Adobe application
Q1.Now my client business requirement chek and pull the report called how many system installed particularĀ Adobe.
Q2.And how many applications Deployed to collection every month
Q3.Andme how many system used in this application
Please give me What I’m runĀ SQL query. This requirement please….
Thank you
Answer ( 1 )
DO NOT USE THIS in production it can kill your SCCM environment ..instead, try using where filters as like this https://www.anoopcnair.com/configmgr-configmgr-microsoft-edge-chromium-sql-query/
SELECT distinct
A.ApplicationName0,
A.Version0,
O.Caption0 as ‘Operating System Name’,
RS.Name0 as ‘machine’,
RS.User_Name0 as ‘username’,
RS.AD_Site_Name0 as ‘Location’,
RS.Resource_Domain_OR_Workgr0 as ‘Domain’
FROM v_GS_WINDOWS8_APPLICATION A
JOIN v_GS_WINDOWS8_APPLICATION_USER_INFO AU ON A.FullName0 = AU.FullName0
JOIN v_R_System RS ON A.ResourceID = RS.ResourceID
JOIN v_GS_OPERATING_SYSTEM O ON RS.ResourceID = O.ResourceID