SCCM – SQL Query for newly discovered devices in last 24 hours

SCCM - SQL Query for newly discovered devices in last 24 hours

This query for SCCM will tell you the devices that have been discovered by Configuration Manager in the last 24 hours. This query can be amended to change the amount of days you wish to look back at for newly discovered devices by changing the last digit in the code. SQL Query More Queries Our … Read more

Renew a Self Signed Certificate on an Exchange Server 2007

Exchange 2013 1

If you are using an Exchange system and have self signed certificates, every year you will have to renew the certificate. An expired certificate may cause problems such as connectivity to web services, SMTP transport and Outlook prompting certificate security warnings which is extremely annoying for users and also can cause problems with Out of Office settings. To do this is very … Read more

Windows XP Sysprep ready for SCCM OSD Capture Guide

The Windows XP End of Life logo with four colored quadrants (blue, red, green, and yellow) on a black background, with the text "microsoft windows xp" below it.

This guide will show you what you need to do to capture a Windows XP Service Pack 3 image, which you can then capture and deploy using Configuration Manager.First of all, you need to create a full  image that is ready to be captured. This is usually best to install on a virtual machine using … Read more

Restore Active Desktop Problems

Microsoft Blue Logo

A recurring issue that I have is the old Active Desktop in Windows XP. No matter how many times you click the Restore button, you still get the script error. To fix this, you can do the following: Click Start then click Run, type “regedit” and press enter Browse to “HCUSoftwareMicrosoftInternet ExplorerDesktopSafeModeComponents” Double click the value DeskHtmlVersion … Read more