System Center

We are asked a lot both in a professional context and through this website about how first line techs can use the remote control functionality that Configuration Manager gives us without giving out access to the full Configuration Manager Console. Well, the answer is fairly simple, if your client machines have the Configuration Manager client installed on them then you …

This query will give you the amount of ConfigMgr clients that are installed on machines per AD site. This can be run on your Configuration Manager SQL database or you can use it to build a custom report using SSRS. More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or …

This is a very simple SQL query but still very useful and will give you a lot of information about your Configuration Manager hierarchy. select * from sites Run this on your Configuration Manager database server or you can use it to create a custom report using SSRS. More Queries Our full range of SQL and WQL Collection queries are …

If you want to retrieve the site roles from your ConfigMgr environment, you can use the following SQL query: select SiteCode, RoleName, ServerName from SysResList More Queries Our full range of SQL and WQL Collection queries are available here. Feedback If you have any questions or feedback about this post, or if you would like us to create any queries for …