TechyGeeksHome

Remote UAC Access Denied Errors – Local Account Token Filter Policy – Remote UAC Fix

Introduction If you are trying to use any remote tools like sysinternals against Windows Vista, 7 or 8.1 machines then you need to have remote UAC elevation privileges to enable you to carry out changes on the machine you are trying to amend. However, you may find that you are still having problems with connecting to remote machines so if …

Guide / Microsoft

Windows 8 Start Menu Button – Just like Windows 7!

by Andrew Armstrong - Leave a Comment

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 …

Guide / System Center

SCCM – Low Disk Space SQL Query

by Andrew Armstrong - Leave a Comment

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 System Total Size Free Space …

System Center

ConfigMgr SQL Query – ConfigMgr clients installed per AD Site

by Andrew Armstrong - Leave a Comment

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 …

Communication / Review

Shoretel IP930D DECT Wireless Handset

by Andrew Armstrong - Leave a Comment

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 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. …

Blogging

Comments and Joining TechyGeeksHome as a Member

by Andrew Armstrong - Leave a Comment

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 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 …

System Center

SQL Query for SCCM – Hierarchy information

by Andrew Armstrong - Leave a Comment

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 and WQL Collection queries are …

Guide / Microsoft

IE9 Compatibility Mode Enabler Released

by Andrew Armstrong - Leave a Comment

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 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 …

System Center

SQL query for retrieving Site Roles from ConfigMgr Database

by Andrew Armstrong - Leave a Comment

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 to create any queries for …

Microsoft / TechyGeeksHome

Advanced BootInforma Released

by Andrew Armstrong - Leave a Comment

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 machine instead of the Windows …

System Center

Query for all machines with SQL installed using Installed Software

by Andrew Armstrong - Leave a Comment

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 would like us to create …

System Center / Guide

SCCM – WQL Query for machines without Endpoint Protection installed

by Andrew Armstrong - 9 Comments.

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 post, or if you would …