i want to export complete list of software’s installed in a device collection , how can i get that …please help me with your suggestions

Question

Hi ,

 

I want to see /export complete list of softwares installed in a device collection .

 

Please help me with your suggestions.

This is to ensure the devices don’t have any unauthorized application installed.

 

Regards,

Selva

solved 0
Raa selva 2020-09-17T06:54:54+05:30 5 Answers 788 views Beginner
0

Answers ( 5 )

  2. Akash Thapa
    1
    2020-09-17T15:02:13+05:30
    Reply

    Try the below SQL query, If the machines are too many in the collection than It may cause delay or you need to stop query. Just add the collection ID

    Declare @Collection varchar(8)
    Set @Collection = ‘COLLECTION ID’ — specify scope collection ID
    Select
    Distinct VRS.Name0 as ‘MachineName’,
    Os.Caption0 as ‘OperatingSystem’,
    St.SystemType00 as ‘OSType’,
    VRS.AD_Site_Name0 as ‘ADSite’,
    VRS.Full_Domain_Name0 as ‘Domain’,
    VRS.User_Name0 as ‘UserName’,
    v_R_User.Mail0 as ‘EMailID’,
    App.ARPDisplayName0 as ‘DisplayName’,
    App.InstallDate0 as ‘InstalledDate’,
    App.ProductVersion0 as ‘Version’
    from V_R_System VRS
    LEFT JOIN v_GS_INSTALLED_SOFTWARE App ON VRS.ResourceID = App.ResourceID
    LEFT JOIN Computer_System_DATA St on VRS.ResourceID = st.MachineID
    LEFT JOIN v_GS_OPERATING_SYSTEM Os on VRS.ResourceID = Os.ResourceID
    LEFT JOIN v_GS_WORKSTATION_STATUS HWSCAN on VRS.ResourceID = HWSCAN.ResourceID
    LEFT Join v_FullCollectionMembership as Col on VRS.ResourceID = Col.ResourceID
    LEFT JOIN v_R_User on VRS.User_Name0 = v_R_User.User_Name0
    Where Col.CollectionID = @Collection
    and VRS.Client0 = 1 and VRS.Obsolete0 = 0
    order by VRS.Name0, App.ProductVersion0

  4. Anoop C Nair
    0
    2020-09-17T13:42:58+05:30
    Reply

    Try removing the where condition from the SQL query ..but be very careful that might impact the performance of your SQL server.. I don’t recommend to use this in production environment

  6. Raa selva
    0
    2020-09-17T11:53:46+05:30
    Reply

    Hi Anoop,

    Thanks for the suggestion. But i want to get the cumulative list of applications installed in a particular device collection which will help us to know , if any of our users installed unauthorized application in their system.

  8. Anoop C Nair
    0
    2020-09-17T07:13:55+05:30
    Reply

    You can this report using the query mentioned in the below blog post

    ConfigMgr Custom Report for Chrome Browser | SCCM | SQL Query

    https://www.anoopcnair.com/configmgr-custom-report-for-chrome-browser-sccm-sql-query/

    Yes it’s for chrome but try to modify that query to find list of devices installed with any particular application..

    Does that make sense

    Best answer
    • Raa selva
      0
      2020-09-17T11:54:06+05:30
      Reply

      Thanks for the suggestion. But i want to get the cumulative list of applications installed in a particular device collection which will help us to know , if any of our users installed unauthorized application in their system.

Leave an answer

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