Blogging

Google Blogger Sitemap Generator Online

Following on from our previous utility Google Blogger SiteMap Generator, we are pleased to launch the online version of that program. Instructions Enter your Google Blogger URL into the first text box and then select the number of posts you want to include in your sitemap. Once you are happy with your inputs, click the […]

System Center

SCCM – WQL Query for machines with a valid Hardware Scan in the last x days

If you would like to identify the machines that have had a valid hardware inventory scan within the last x amount of days, you can use this WQL query as per below. select SMS_R_System.Name, SMS_G_System_WORKSTATION_STATUS.LastHardwareScan from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceId = SMS_R_System.ResourceId where DateDiff(dd,SMS_G_System_WORKSTATION_STATUS.LastHardwareScan,GetDate() ) <= 15 This query is defaulted to 15 […]

System Center

SCCM – WQL Query for MAC Address Prompt

If you would like to search for a machine based upon its MAC address, you can use a WQL query to do this. The WQL query that you should use for this is below: select distinct SMS_R_System.Name, SMS_R_System.MACAddresses from SMS_R_System where SMS_R_System.MACAddresses = ##PRM:SMS_R_System.MACAddresses## order by SMS_R_System.MACAddresses More Queries Our full range of SQL and […]

System Center

SCCM – Query for devices in a specific Active Directory Organisational Unit (OU)

If you are looking for a SCCM query query that will return all machines that are in a specified organisational unit (OU), then you can use this one below. All you need to do is change the demo OU below to your own required OU. Organisational Unit TECHYGEEKSHOME/LAB/COMPUTERS/WINDOWS 10 Query Script SELECT distinct * FROM SMS_R_System […]

Guide, MSI, Program

Remove IE MSI

We are pleased to announce the release of our RemoveIE software in an MSI format. This will allow you to distribute the application to a large number of computers using tools such as Group Policy or SCCM. The MSI program is a free download and this does allow you to distribute the software within your […]

Blogging

Google Blogger SiteMap Generator MSI

We are pleased to announce the release of our Google Blogger SiteMap Generator software in a MSI format. This will allow you to distribute the application to a large amount of computers using tools such as Group Policy or SCCM. The MSI program is a purchasable item and will cost you £19.99 however this does […]

System Center

ConfigMgr 2012 R2 – Prerequisites installation tool

We have recently come across an excellent Powershell tool which identifies and installs all prerequisites for Configuration Manager 2012 R2 installations. Take a look at the website below for further information: ConfigMgr 2012 R2 – Prerequisites installation tool Free Subscription If you want to be notified when we post more quality guides like this one, […]

System Center

Server Information SQL Query for SCCM

The below SQL query can be used against your SCCM database to return information about your servers. You can edit this query to bring back different information and also use it to create a report using SSRS. This query by default brings back the following information: Server Name Server Make Server Model Server Operating System […]

System Center

SCCM – WQL Query for devices with Google Earth installed

If you want to identify machines with Google Earth 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 = “Google Earth” order by SMS_R_System.Name This WQL query can then be used […]