question

Zeeshansidd-0614 avatar image
0 Votes"
Zeeshansidd-0614 asked Zeeshansidd-0614 commented

zoom REPORT

Hi,

I need SQL query to generate report in SCCM and having information for 'zoom client software' installed on desktop machines.

please.provide query for this.

Regards,

sql-server-generalmem-cm-generalsql-server-reporting-servicesmem-analytics-reporting
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

GarthJones-MVP avatar image
1 Vote"
GarthJones-MVP answered

Zoom is user installed software and cm does not inventory that. See this blog for more details. https://www.enhansoft.com/user-installed-software-and-why-you-should-care/

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SimonRenMSFT-3639 avatar image
0 Votes"
SimonRenMSFT-3639 answered Zeeshansidd-0614 commented

Hi,

Thanks for posting in Microsoft MECM Q&A forum.

Please refer to: Hardware Inventory report does not include zoom.exe information

Thanks for your time.
 
Best regards,
Simon

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 15
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Zeeshansidd-0614 avatar image Zeeshansidd-0614 ·

Hi Simon,

Thanks. I have already enable it from hardware (Set Classes).

After that i need SQL query having information to generate report having zoom client software information on clients.

Thanks.

0 Votes 0 ·
SimonRenMSFT-3639 avatar image SimonRenMSFT-3639 Zeeshansidd-0614 ·

Hi,

Thanks for your reply.

Please below query:

select distinct SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_G_System_INSTALLED_SOFTWARE.ProductVersion from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Zoom%" order by SMS_R_System.Name

Best regards,
Simon

0 Votes 0 ·
Zeeshansidd-0614 avatar image Zeeshansidd-0614 SimonRenMSFT-3639 ·

Thanks.
Its WMI Query?

0 Votes 0 ·
Show more comments
Zeeshansidd-0614 avatar image Zeeshansidd-0614 SimonRenMSFT-3639 ·

IAfter execute t shows 'invalid object name SMS_R_System.

Thanks.

0 Votes 0 ·
SimonRenMSFT-3639 avatar image SimonRenMSFT-3639 SimonRenMSFT-3639 ·

Hi,

Sorry for my delayed reply. The query is a WMI query and we can run it from SCCM console as below:
select distinct SMS_R_System.Name, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_G_System_INSTALLED_SOFTWARE.ProductVersion from SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "Zoom%" order by SMS_R_System.Name

95689-wimquery.png
95744-wim2.png

I will do more research about the SQL query, if there is any update, I will let you know. Thanks for your understanding.

Best regards,
Simon


0 Votes 0 ·
win32.png (53.4 KiB)
wimquery.png (97.1 KiB)
wim2.png (54.0 KiB)
Show more comments