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.
We hear a lot of people complaining about Windows 8 since Microsoft launched their new flagship operating system. Stupid touchpad operation, stupid charms, stupid start screen and stupid apps are all common complaints of Windows 8. The problem is, if you buy a new computer, the chances are that the OEM operating system on it … Read more
This is a SQL query for your SCCM database or you can use it to create a report using SSRS. For this work, you must ensure that you have the Logical Disk class enabled in the hardware inventory settings. This will give you the following information: Computer Name Disk Description Drive Letter Volume Name File … Read more
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 … Read more
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 … Read more
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 … Read more
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 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 … Read more
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 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 … Read more
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 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 … Read 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 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 … Read more
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 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 … Read more
We have been using SCORCH for a while now and have acquired a number of Integration Packs. So, we thought we would zip them all up and add them to our site for you to download and use. Sorry but we cannot remember where most of them have come from as they have been gathered … Read more
If you wish to play God with your Windows operating system and have the ability to change virtually every setting on your machine in one easy to access window – then this little tool is for you. Simply download the installer, install on your Windows machine and you will gain full access to all the … Read more