SQL Query for SCCM

Question

hI,

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

solved 1
haris 2021-04-12T12:04:58+05:30 1 Answer 244 views Beginner 0

Answer ( 1 )

  2. Anoop C Nair
    0
    2021-04-12T16:56:39+05:30
    Reply

    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 a permission to answer to this question .