SCCM WQL Query – All Inactive Clients
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.
TechyGeeksHome has been helping IT professionals and sysadmins since 2010. Find 1,500+ real-world guides covering Windows 10 & 11, Windows Server, SCCM/ConfigMgr, PowerShell scripting, Active Directory, networking, and virtualisation — all written from hands-on production experience by a UK IT pro with 26 years in the field.
If you want to create a Configuration Manager Collection with all inactive devices in it, you can use the following WQL query. You can also change the last “0” to “1” to create a collection of active devices.
If you are using WordPress for your blog and trying to set W3 Total Cache, you may find that on your Administration page, you are getting this error: “W3 Total Cache Error: Page Cache Rewriting is URL Not Working. Please verify that the server configuration allows .htaccess” There can be a few reasons for this … Read more
If you are using System Center Service Manager (SCSM) you may want to delete all your incidents. This may sound strange but if you are setting up and testing and then want to remove all those test incidents – this can sometimes be the case. So, all you need to do is to start up … Read more
If you want to add a VK.com Jetpack sharing buttons then there is a very simple way of doing this. Just login to your WordPress administrator site and navigate to Settings > Sharing: You should then scroll down to the Sharing Buttons section and click on the “Add a new service” link: You should then … Read more
We recently came across a great guide on how to setup a DCM item to detect if any users machines had the Windows Firewall turned off and how to report on it. So, we thought we would share this guide with our visitors, so head on over to MyITForum to check out how to carry … Read more
We have recently started to have problems with running a CScript command in one of our SCCM task sequences where we send the local computer description to Active Directory to automatically set the Active Directory computer name description. It has always worked fine but seemed to have stopped working after the latest hotfix. So, after … Read more
We have recently been installing WSUS on a rebuilt Microsoft Server 2012 and found that although the role would install without any issue, when we tried to run the configuration wizard we were getting an error and in the log file it stated: “Config file did not contain a value “ContentDirectory”” So, first of all, … Read more
We were recently setting up a new WSUS server in our lab and also setting up System Center Updates Publisher (SCUP) and kept getting an error when trying to connect SCUP to WSUS which were installed on the same server. The error we were getting was: “Failed to connect to the update server. Check your … Read more
We have been carrying out some work on various HTA’s for SCCM OSD processes lately and that has included automatically setting time zones. We struggled to find a comprehensive list of the time zone settings so thought that we would share that information here. If you find anything that we may have missed, please let … Read more
If you are an Exchange administrator and are having trouble in accessing other mailboxes although you have full access, then you may find that you need to remove the “Deny” permission on the mailbox you are trying to access. Sometimes this can be your own account or maybe a group like “Domain Admins”. To check … Read more
If you have a Shoretel telephony system in your corporate environment and you want to know which extensions have which licenses, then you can do this by running a simple query across your Shoretel MySQL database. Login to your HQ server and open MySQL and login to your main Shoretel database. Then run these following … Read more
If you need to export your Exchange mailbox address details to CSV then you can run the following EMS PowerShell command to export the name, primary SMTP email address and the mailbox database where the mailbox is allocated. Get-Recipient -Resultsize unlimited | select name, primarysmtpaddress, Database | export-csv C:tempaddresses.csv You can change the file location … Read more