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 […]
Month: January 2014
Shoretel IP930D DECT Wireless Handset
It seems that we have been out of the loop a little on some new technology that came onto the VoIP market last year and […]
Comments and Joining TechyGeeksHome as a Member
As our website has continued to grow (now reaching 800,000 hits since we started in 2011), we have been seeing the downside of what increased […]
SQL Query for SCCM – Hierarchy information
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 […]
IE9 Compatibility Mode Enabler Released
We are pleased to announce the release of IE9 Compatibility Mode Enabler. This program has been designed for our own purposes but has proven such […]
SQL query for retrieving Site Roles from ConfigMgr Database
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 […]
Advanced BootInforma Released
We are pleased to announce the release of Advanced BootInforma for Windows 7 and 8 machines. This is a Windows Operating System tweak that turns […]
Query for all machines with SQL installed using Installed Software
If you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL […]
SCCM – WQL Query for machines without Endpoint Protection installed
If you need to identify machines that have the Configuration Manager client installed but do not have the System Center Endpoint Protection client installed, then […]
SCCM – WQL Query for machines with 4GB RAM or more
If you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select […]
Mimecast MSO Fix – SMTP in the Credentials Error
If you are a Mimecast user and are also using Windows 8.1, you may find that when you have installed the Mimecast client for Outlook […]
Microsoft Evaluation VHD’s – Windows Server 2012 Contoso Administrator Password
Although most people will be using full versions of Windows Server 2012 products by now, some may still use the evaluation VHDs from Microsoft. We […]