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

solved 0
Krish 2020-06-29T16:15:49+05:30 1 Answer 187 views Beginner
0

Answer ( 1 )

  2. Anoop C Nair
    0
    2020-07-02T23:05:33+05:30
    Reply
    This answer was edited.

    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

    Best answer

Leave an answer

Sorry, you do not have permission to answer to this question .