
If you are looking for other articles on ConfigMgr I have a useful guide here, that will help you uninstall Visio 2013 using ConfigMgr.


The above query will find any clients that have laptop as the first part of their name. You can modify the ConfigMgr query to pull back the information from specific clients by using: Azure Data Studio is based on Visual Studio Code and is oriented towards SQL developers, since the main purpose of Azure Data Studio is to write, edit and execute SQL queries, in other words, it is an SQL code editor. I've put together a wee guide on how I implemented the query below:ġ - First of all I opened up my ConfigMgr console and navigated to the Monitoring tab and expanded "Overview".Ģ - Next I right clicked on Queries and selected "Create Query"ģ - Selecting "Edit Query Statement" nextĤ - Then I clicked on "Show Query Language"ĥ - Within the dialogue box that appeared I typedĦ - I then clicked OK and named my Query, then completed the wizardħ - My query appeared within the Query list and I was able to Run it. Azure Data Studio is a free, cross-platform, open source tool for working with Microsoft SQL Server databases. I recently had to find the MAC Addresses of a bunch of servers that were managed by Configuration Manager (ConfigMgr) so I pulled together a simple query that would pull the information out of the database for me. These queries were last tested with Configuration Manager version 2006
