SQL Query for SCCM

Question

hI,

I need SQL query in sccm to get report of zoom client installed on client machines.

Answer ( 1 )

  1. You can use the same SQL query just change the app name to Zoom

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

    Select Distinct
    v_R_System.Name0 as ‘machine’,
    v_R_System.User_Name0 as ‘username’,
    v_R_System.AD_Site_Name0 as ‘Location’,
    v_R_System.Resource_Domain_OR_Workgr0 as ‘Domain’,
    v_Add_Remove_Programs.DisplayName0 as ‘displayname’,
    v_Add_Remove_Programs.Version0 as ‘Version’
    From v_R_System
    Join v_Add_Remove_Programs on v_R_System.ResourceID = v_Add_Remove_Programs.ResourceID
    Where v_Add_Remove_Programs.DisplayName0 Like ‘%Zoom%’
    and v_Add_Remove_Programs.DisplayName0 not Like ‘%update%’
    and v_R_System.Active0 = ‘1’

    Best answer

Leave an answer

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