SQL Query for SCCM
Question
hI,
I need SQL query in sccm to get report of zoom client installed on client machines.
solved 1
Configuration Manager 1 year 2021-04-12T12:04:58+05:30 2021-04-12T12:04:58+05:30 1 Answer 244 views Beginner 0Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
hI,
I need SQL query in sccm to get report of zoom client installed on client machines.
Answer ( 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’