Making IT Happen
Our full range of technical guide articles is available here.
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 is going to be Windows …
Windows 8 Start Menu Button – Just like Windows 7! Read MoreThis 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 System Total Size Free Space …
SCCM – Low Disk Space SQL Query 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 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 MoreIf 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 administration tools that Windows has …
God Mode for Windows Read MoreIf you want to identify machines with a specific piece of software installed, you can utilise the Add/Remove Programs software inventory to do this by using this query. select distinct SMS_R_System.Name, SMS_R_System.OperatingSystemNameandVersion, SMS_R_System.ClientVersion from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = “Microsoft Office Professional Plus 2010” order by SMS_R_System.Name In this example, we are using “Microsoft …
SCCM – WQL Query for devices with specific software installed Read MoreDell have an excellent tool freely available called Dell Client Integration Pack. Included in this tool is something called Warranty Status. What this part of the tool does is looks at your SCCM SQL database for Dell machines and their asset tags, then checks against its own warranty database for the warranty information. It then inserts all the warranty information into …
Report on Dell Warranty Statuses for all machines using SCCM & Dell Client Integration Pack Read MoreIf you are having trouble in getting the Dot.Net 3 feature to enable on your Windows 8 machine, there is a way that you can do this offline by using DISM and the original Windows 8 media. Instructions Firstly, you sure ensure that you have your original Windows 8 media in your optical drive (or on a USB stick). Then …
Windows 8.1 Dot.Net 3 Feature Enable using Operating System media offline Read MoreWe have recently been asked about how to add a static page to Google Blogger, but not have it added to the menu tabs – whilst keeping other tabs in place. So in essence – how to create a hidden custom page. We use these to give general information on pages without them being added to our menu bar and …
How to add a custom static page to your blog and not adding it to your menu tabs – Google Blogger Read More
