I did new hardware scan and everything they have is showing up except Zoom, though Zoom is actually instaled on their machine. Dynamic programming: optimal order to answer questions to score the maximum expected marks. Alternatively,Unique_User_Name0 will return DOMAIN\\USER. Learn how your comment data is processed. Any thoughts? This helps to confirm whether the hardware inventory is working or not. Sometimes you want to create a query based on if a computer has a specific Application and version number. We will download the latest version of the Zoom MSI installer, create a Zoom application in SCCM, and then deploy the application to our endpoints. 0 for x86 1 for x64 Find 'Scripts' in the CCM logs in the last hour. solved 1 Configuration Manager haris 2 years 1 Answer Beginner 0 high About haris Beginner Related questions Answer ( 1 Anoop C Nair You can use the same SQL query just change the app name to Zoom If you are installing Zoom client for meetings on your Windows 10/11 computer, downloading the executable is a recommended option. 2. Is it possible to get license information too. Select the Distribution Pointoption. Home SCCM How to Deploy Zoom Client Using SCCM | ConfigMgr. In other words: what you're seeing is essentially by design. Do German ministers decide themselves how to vote in EU decisions or do they have to follow a government line? It would be best if you tried to use the implicit uninstall feature introduced with the SCCM 2107 rather than using collection based on the installed application. We now have a list of computers with Zoom installed, along with their assigned Primary User. Next, he clicks Save. To deploy the Zoom client application in the SCCM console, go toSoftware Library>Application Management>Application. (CS.DisplayName0 = 'Zoom') Step 4: Return the User Name for Each User ID Show the machines with Zoom installed, along with the username of the primary user assigned to it New View to Add: v_R_User Fairly straightforward addition to the query, but will require yet another view to be JOINed in. When a user logs in to Windows, Zoom is installed with the MSI and a shortcut to start Zoom is added to the users desktop. I set the relationship so that ResourceID on v_GS_ADD_REMOVE_PROGRAMS is related to MachineID on v_UsersPrimaryMachines. What does a search warrant actually look like? Select theUser COLLECTIONyou want to deploy the Zoom application. This view also has a DisplayName0 column that lists the associated software title, which we want. And the other for Microsoft Teams? The hardware inventory schedule might delay getting the latest information available on Windows PCs. Quick Question. I managed to locate the zoon.exe installation information, which was actually written into: Unfortunately this class is not included in hardware inventory by default. When it has opened it. Staff member. Select the "All Windows Apps" report and click Run in the upper left corner. Software Centershows Zoom application as available. The user would then end up with two copies of zoom installed (zoom - msi and Zoom - exe). The following are some of the tips where you can start troubleshooting. Unfortunately, we were unable to utilize Software Inventory, since the program doesn't always install locally on a system. The Where field in the Criterion Properties window is filled with the value with Installed Software Product Version as explained in the above list. Then there's a way to detect when the user has installed it. Launch the Configuration Manager console. For remediation I ran the uninstaller so I can push out the new msi version with Software Center. This post is just for education purposes and testing in the lab environment. It would take them to the exe installer (which is a per-user installation). In addition, the Zoom extensions for modern browsers are also available. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Design a site like this with WordPress.com, How to retain the xml file during Hardware or SoftwareInventory, https://docs.microsoft.com/en-us/mem/configmgr/core/clients/deploy/about-client-settings, https://docs.microsoft.com/en-us/mem/configmgr/develop/core/understand/sqlviews/how-to-create-configuration-manager-reports#to-create-a-new-sql-based-report, https://www.systemcenterdudes.com/sccm-report-creation-report-builder/, Open Configuraton Manager console and navigate to, After the client setting is pushed, you can see zoom.exe appears on the next hardware inventory cycle. Check out the Run Time (ms) taken to complete the Full evaluation of the Google Chrome collection, and the Run Time is 1218. Right click and select Create Configuration Item The following Wizard will appear 3. For instance, the example will show define a query for all computers running Firefox 24.2.0 or lower version and creating a dynamic group from that query. Zoom client for meetings provides simplified video conferencing and messaging across any device. NOTE! Click Browse, select the Zoom Client for Meetings icon, and click OK. We will now deploy Zoom client application using ConfigMgr to a device collection. Lets specify the basic details of the device collection. Why would you need to make a collection if PMP can detect it. This what I used to find users that have installed zoominstaller.exe. You should be able to create the Zoom application in ConfigMgr by following the steps listed below. Dont care if this an old thread now you've saved me a lot of work! Let me know in the comments below if you need a specific query and I will add it to this list. On theQuery Rule Propertieswindows, specify the following information, such as the querys name, resource class, etc. Ive posted a video on YouTube that walks through the ConfigMgr deployment process for the Zoom application. This quickly shows you what columns are in the view and what info you can get from it. It does not "register" on the computer at all. CleanZoom.exe. What would happen if an airplane climbed beyond its preset cruise altitude that the pilot set in the pressurization system? (You have to check the resource explorer as discussed above to get the version details of Chrome). Create an account to follow your favorite communities and start taking part in conversations. You shouldn't be allowing users to run random executables in your environment, that's a huge security hole. Click Nextto continue. On the General tab of the Create Query Wizard, specify a unique name and, optionally, a comment for the query. These collections demonstrate different queries you can use to create all the collection you need. For some reason, I am unable to get a query to work for an exe located at a specific file path. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. All things System Center Configuration Manager Press J to jump to the feed. Zoom places zoom.exe in this locationc:\users\**someuser**\AppData\Roaming\Zoom\bin\zoom.exe. SQL Server Views in Configuration Manager (Microsoft Docs). SCCM dynamic device collections based on the installed application can sometimes be tricky because of the dependency on hardware inventory. Lets say you have users in SCCM with multiple primary devices and you want to know which users do NOT have Zoom installed on ANY of their devices. For this, well need to pull in another view one that can use the ResourceID from v_GS_ADD_REMOVE_PROGRAMS and give us back the name for the computer its tied to. You can set the Zoom clients icon in SCCM by going to the application properties page and doing so under the software center tab. If the uninstall button is greyed out then check the uninstall command under application properties. Then create a group based upon a query where "Software Files - File Name" is like Zoom.exe. One which checks for App1 only and other which checks for App2 only. I see query results preview gives the Product name, version, etc., details of Google Chrome. Some of these methods are listed below. Then when you remove the resource from the collection, the application uninstalls. Hello Praj, What if under Installation Program I enter this swtich: Thanks! Click onNEXTto continue. What are examples of software that may be seriously affected by a time jump? On the Home tab, in the Create group, select Create Query. Theres a column in this view,TopConsoleUser0, which appears to return the userwith the most time on the machine. Click on the RUN button from the Query Results Preview window to get the results of the WQL query. Download https://zoom.us/client/latest/ZoomInstallerFull.msi, The following are the command-line options for deploying the Zoom client. It will prevent users downloading the Zoom installer since it transparently redirects all meeting links to the web-based client. Select thePurposeasREQUIRED. Sharing best practices for building any app with .NET. So far we've tried various ways of doing this without any success. So far I have this below, but not quiet working. Lets check the installed application from SCCM resource explorer. The mass deployment of the Zoom Desktop Client can be performed for Windows 10 devices in three different ways. I need SQL query in sccm to get report of zoom client installed on client machines. The output table will show the Computer ID numbers of machines that have Zoom installed: I could have left that part out of the SELECT statement and just returned the ComputerID. ClickNext. Expect to do a fair bit of googling and fiddling with the parameters before you get it right. I would make a CI to check for the files in the appdata folder under the users folders on the machine, if found then return non compliant. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. SCCM Device Collection Query: Find all clients in intranet. It's showing up in tenable for us so our security team wants this patched and updated. Show the Computer Names of computers with Zoom installed, along with the user assigned. I am trying to put together an query that will give me the user of a device that has two applications installed. I am looking to find out what PCs I have left to get upgraded to O365. Does anyone have any suggestions? Since v_R_System_Valid is joined as OS, the SELECT statement needs to specify OS.Netbios_Name0. Can patents be featured/explained in a youtube video i.e. We are dealing with our users connecting to sessions via a 3rd party that uses zoom. To get machines without Zoom, we write the WHERE clause to say: We want usernames that do NOT appear in (this list of usernames that have Zoom installed on their machine). To know the location of this file and other files, refer to theSCCM Log files. Sort by date Sort by votes Prajwal Desai Forum Owner. The exe install as mentioned earlier is a per user install so there aren't any MSI product codes associated with it. Deploy the update to all computers and be done with it. Since that method doesn't place zoom app in apps/features, we dont get the usual "Kace uninstall string". I imagine theres a simpler way to do this: Return the Computers whichdo not have Zoom installed, with the username of the devices primary user. Select the Resource Class as System Resource for device collection. I know that this is not really an SCCM topic, but to everyone who wants to get Zoom uninstalled from the computers in the org and not knowing how to do it, please note that Zoom "installs" in the user's %appData% folder. I enabled the enablesilentautoupdate flag, but versions still report 5.2, I have question about: Save the Zoom Installer into the sources folder on your ConfigMgr Server. Endpoint Manager. Matched exit code 0 to a Success entry in the exit codes tableconfirms that the Zoom application has been installed successfully. You can use these commands while you deploy this MSI using Configuration Manager | SCCM. Note that each view listed in FROM are joined as separate variables one as CS, one as OS. I didnt use the SCCM console because I wanted to teach myself SQL queries. We can use the not in operator as shown in the below query: We now have a list of computers without Zoom installed, with their primary user. How can I recognize one? MSI can be deployed as an all user installation and our image has and MSI install already on it. Well pull in v_UsersPrimaryDevices via a second JOIN. I want to break down Office 32 bit and . Thanks! It just means we have to be careful how we relate v_UsersPrimaryMachines to another view. However, I have seen many organizations use Zoom meetings to interact with external clients. The dynamic device collection created based on Google Chrome installed Windows PC helps to target Google Chrome upgrade scenarios; however, I dont recommend using this method for upgrading the Chrome version. Click on the Next button to continue. Choose the device collection against which you want to run the CMPivot. Some administrators prefer to deploy the Zoom client using GPO because they either dont use SCCM in their organization or they think the GPO method is simple. Make a query with Software Installed zoom; then create a collection with that group and patch, I can't even find Zoom when I check a machine's installed programs via SCCM by using "Resource Explorer". It runs locally under the user, . it's on their site but just one row of text among all the installation instructions. By default, Configuration Manager only collects, as defined by Default Client Settings in Client Settings, programs registered in: Root\cimv2\Win32Reg_AddRemoveProgramsRoot\cimv2\Win32Reg_AddRemovePrograms64. This helps to confirm whether the WQL query (Dynamic query) based on the Installed application is working fine or not. Check the results and if its ok, click on the, Select the Membership rules called HTMD Query-based Installed Software and click on the, Select Google Chrome version (98.0.4758.102) from the Values window. I create a collection based on the Google Chrome application installation status. Intune and Configuration Manager. On theDeployment Settingswindow, specify the settings to control the deployment of Zoom client application. In this section of the post, lets check how to create WQL Query to create a collection based on installed app or software details for Windows devices. Setting up applocker to block anything by default unless whitelisted is a great way to block these applications. The assigned individual users need to be listed in the SCCM Consoles Users area. On the Summary window, verify the settings for the Zoom Client application, and then click Next. And security concerns with Zoom meeting clients. The Zoom client and plugins are available for almost all the modern devices and clients. :) But if you are on a hunt & destroy mission do consider browser-based Zoom client. The modified result will show computer names instead of computer ID numbers, of machines with Zoom installed:(instead of leaving my test installations PC names in there, I copied modified output to Excel to show what you canexpect it to look like). Select the Operating Systems you want to target and click Next It not alone either, so far Office 365, Visio 2016 . There are several ways to deploy the Zoom client. CMPivot uses a subset of the Kusto Query . In this example, the Collection ID = MEM0002D. Prajwal Desai Forum Owner. Again, Im sure theres a much easier way to do this, but getting the assigned primary user for a machine took a few extra steps. I wanted to show how to query machines with Zoom installed first because we need to use that. Show the machines with Zoom installed, along with the username of the primary user assigned to it. Prajwal Desai is a Microsoft MVP in Enterprise Mobility. He is Blogger, Speaker, and Local User Group HTMD Community leader. It runs locally under the user, so a typical { SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Zoom%" } doesn't work. It may not display this or other websites correctly. Try this: Add it to the Software Inventory in Administration --> Client Settings --> Software Inventory. I tried with the installer.exe in the uninstall folder but I'd didn't work on all clients. I have not included the results with the version filter. ConfigMgr can populate the install and uninstall commands including the detection method for Zoom client. Select theActionasInstallandPurposeasAvailable. You can use this script to check for any file in the users directory. It's a user context app, so this method won't work anyway. The SELECT statement was changed to only spit out the Computer name, and the numeric User ID that its associated with. You can download Zoom Full Installer MSI from Zoom(around ~46 MB) and deploy it. Asking for help, clarification, or responding to other answers. 1. ShellCommandTextReturn(CMD /q /c for /d %u in (\Users\*) do (if exist %u\AppData\Roaming\Zoom\bin\zoom.exe echo %u)). It's free to sign up and bid on jobs. SCCM Query to find two different applications installed Add your rating: -------------------- Hi all, I am trying to put together an query that will give me the user of a device that has two applications installed. You can also check whether the desktop shortcut is created for the Zoom application or not. That makes sense. Hi, I am looking for a sql query that lists the application installed (with version) from list of all computers in my organization. Try to make two collections. Find centralized, trusted content and collaborate around the technologies you use most. Also, for organizations where you are rolling Zoom out.don't use the zoom exe installer. Lets complete the process of creating the SCCM Dynamic Device Collection based on the Installed Application in this section of the post. Note: The Zoom client for meetings is available for download as executable and MSI version. If you dont see the software or application in the list of installed Software means that the hardware inventory details of that application are not received from the Windows device. NOTE! Required fields are marked *. How to Deploy Zoom Client Using SCCM | ConfigMgr. The other features include unlimited voice and video conferencing, virtual backgrounds, screen sharing etc. sccm wql query to get machine without particular application - Software Deployment & Patching Home Software Imaging, Deployment, & Patching sccm wql query to get machine without particular application Posted by tkr99 on Sep 28th, 2018 at 8:42 AM Needs answer Imaging, Deployment, & Patching Hello all, This was able to remove the software using the above command line commands (im assuming). From the Criterion Properties window, click on the select button to select the Attribute for the WQL query. If you find this video useful, do like the video and subscribe to the channel. Specify the location of the Zoom MSI installer file. Then make a collection for those non compliant workstations and deploy full zoom install to those pc's then SCCM will detect them. Seems pointless to delete Zoom EXE, Zoom MSI, Zoom Outlook plugin when the above command can uninstall just the EXE. It will take some testing and tweaking to get the concept understood properly and then set up to your satisfaction. With MSI installers, the Zoom application deployment with SCCM because much easier. In the example code I am using Adobe Acrobat version 9. 1 Found it, it's under Attribute Class: Desktop Monitor Attribute: Description I had to create a Join on the System Resources/Desktop Monitor ResourceID to get the System Resources Name attribute to tell which computers the monitors are connected to Share Improve this answer Follow answered Oct 9, 2014 at 6:37 blsub6 1,101 6 25 44 Add a comment 2. How to add Active Setup into existing MSI? The limiting collection establishes the resources you can add to this collection using membership rules. Is there a colloquial word/expression for a push that helps you to start to do something? stay informed, earn points and establish a reputation for yourself! The Zoom MSI installer will remove the user-installed versions and add a version that shows up in the software list. View Best Answer in replies below How to add Active Setup into existing MSI? Open Configuraton Manager console and navigate to \Administration\Overview\Client Settings Click on Default Client Settings and select Hardware Inventory Click on Set Classes Click on Add, then Connect Put root\cimv2 into WMI namespace field Select Installed Win32Program (win32_installed32program) from Inventory class and click on Ok Unfortunately, the MSI is used when Zoom is supported in your environment. Select the installationACTIONasINSTALL. Simply copy and paste these into the sccm query statement of the query rule. The usual methods of app management, detection, monitoring will all fail as a result. 2023 Quest Software Inc. All rights reserved. If you use the MSI installer it installs for the whole system under "C:\Program Files (x86)\Zoom\bin"For detection, I simply check for the MSI product code. But thats not exactly what we want, is it?