Making IT Happen
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 …
ConfigMgr SQL Query – ConfigMgr clients installed per AD Site Read MoreIt seems that we have been out of the loop a little on some new technology that came onto the VoIP market last year and it is something that we have been looking forward to for a while. Shoretel is a great VoIP system but on of the draw backs had always been the lack of a good wireless handset. …
Shoretel IP930D DECT Wireless Handset Read MoreAs 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 traffic brings – Comment Spam! We have been receiving an absolute huge amount of spam comments lately across more than 200 of our posts and it is becoming simply too much to moderate, so we …
Comments and Joining TechyGeeksHome as a Member Read MoreThis 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 …
SQL Query for SCCM – Hierarchy information Read MoreWe are pleased to announce the release of IE9 Compatibility Mode Enabler. This program has been designed for our own purposes but has proven such a help to us that we thought we would release it as freeware. What does it do? This program adds a registry entry onto your machine that tells Internet Explorer to always open in Internet …
IE9 Compatibility Mode Enabler Released Read MoreIf 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 …
SQL query for retrieving Site Roles from ConfigMgr Database Read MoreWe are pleased to announce the release of Advanced BootInforma for Windows 7 and 8 machines. This is a Windows Operating System tweak that turns on the logging information when your machine is booting up, logging in and shutting down. What this actually shows you is the processes that are being carried out by your machine instead of the Windows …
Advanced BootInforma Released Read MoreIf you wish to run a SQL query against your SCCM database to find all machines with SQL installed, then you can use this SQL query below: More SQL 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 …
Query for all machines with SQL installed using Installed Software Read MoreIf you need to identify machines that have the Configuration Manager client installed but do not have the System Center Endpoint Protection client installed, then you can use the following WQL query. 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 …
SCCM – WQL Query for machines without Endpoint Protection installed Read MoreIf you have a requirement to identify machines with 4GB RAM or more, then you can use the following WQL query to do this. select distinct SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName from SMS_R_System inner join SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId where SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory >= 4096000 order by SMS_R_System.Name, SMS_R_System.ADSiteName, SMS_R_System.IPAddresses, SMS_R_System.LastLogonUserName, SMS_R_System.DistinguishedName You can change the where value of 4096000 …
SCCM – WQL Query for machines with 4GB RAM or more Read MoreIf 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 (MSO) and try to enter your domain or cloud credentials, the username has SMTP set and cannot be changed and the password part is greyed out. You will then receive the usual error message at …
Mimecast MSO Fix – SMTP in the Credentials Error Read MoreAlthough most people will be using full versions of Windows Server 2012 products by now, some may still use the evaluation VHDs from Microsoft. We have just downloaded all 11GB of VHD files from Microsoft for doing some testing and got to the point where we need to enter the Contoso Administrator password. After trying all the passwords we could …
Microsoft Evaluation VHD’s – Windows Server 2012 Contoso Administrator Password Read More
