zoom REPORT

Zeeshan sidd 1

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,

Zeeshan sidd 1 Reputation point

2021-06-03T08:39:51.193+00:00

any update?

2 answers

Garth Jones 2,071 Reputation points

2021-04-12T07:59:47.063+00:00

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/
Please sign in to rate this answer.

1 person found this answer helpful.

0 comments No comments
Sign in to comment
Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor

2021-04-12T08:10:57.987+00:00

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.
Please sign in to rate this answer.
Zeeshan sidd 1 Reputation point

2021-04-13T06:14:51.617+00:00

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.

Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor

2021-04-14T06:52:19.73+00:00

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

Zeeshan sidd 1 Reputation point

2021-04-14T09:48:07.367+00:00

Thanks.
Its WMI Query?

Garth Jones 2,071 Reputation points

2021-04-14T10:34:44.853+00:00

That is a cm console query.

Zeeshan sidd 1 Reputation point

2021-04-14T11:08:06.097+00:00

IAfter execute t shows 'invalid object name SMS_R_System.

Thanks.

Zeeshan sidd 1 Reputation point

2021-04-14T11:09:27.4+00:00

we need SQL query to generate report and get information about zoom software.

Garth Jones 2,071 Reputation points

2021-04-14T12:56:43.153+00:00

Have you looked at the builtin reports for this?

Zeeshan sidd 1 Reputation point

2021-04-18T10:29:48.137+00:00

Builtin report?

Where its?

Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor

2021-04-19T09:21:09.463+00:00

Hi,

Thanks for your reply. Please try the built-in report Computers with a specific product under the Software - Companies and Products category. And select the product name as "Zoom", like below:

Best regards,
Simon

Zeeshan sidd 1 Reputation point

2021-04-19T09:51:25.853+00:00

Thanks.
I checked in the builtin report, the product "ZOOM" is not listed or available in the list.

Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor

2021-04-22T02:56:49.533+00:00

Hi,

Thanks for your reply. Can we see the product "Zoom" via Resource Explorer in the SCCM console after we add the Installed Win32Program class in the Hardware Inventory client settings?

Best regards,
Simon

Zeeshan sidd 1 Reputation point

2021-04-26T08:28:36.437+00:00

Hi,

We have already added it.

Thanks.

Zeeshan sidd 1 Reputation point

2021-04-26T08:29:40.447+00:00

But not show "Zoom".

Thanks.

Simon Ren-MSFT 30,496 Reputation points Microsoft Vendor

2021-05-04T08:46:32.23+00:00

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

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

Zeeshan sidd 1 Reputation point

2021-05-19T07:49:50.137+00:00

Hi Simon,

Thanks to provide information

Any update regarding SQL query for the same?

Thanks
Sign in to comment