I had a requirement to count the different versions of Windows Server but only on physical hardware. This SCCM report does this by excluding VMWare and Hyper-V machines: SELECT OPSYS.Caption0 as C054, COUNT(*) AS ‘Count’ FROM v_GS_OPERATING_SYSTEM OPSYS full Join v_GS_COMPUTER_SYSTEM On v_GS_COMPUTER_SYSTEM.ResourceID = OPSYS.ResourceID inner join v_R_System sys on OPSYS.ResourceID=sys.ResourceID where OPSYS.Caption0 LIKE ‘%server%’ [...]

Continue reading...

I had a requirement to report on SQL Server installations in our environment as part of our Microsoft EA true-up process. This included SQL 2000, 2005 & 2008 installations. The difficulty was that you can’t run a simple Add / Remove Programs report because it will report all of the SQL client tools installations as [...]

Continue reading...

Our KMS server had been running without issue for months until recently when I tried to activate another Windows Server 2008 R2 client (already 30+ in the environment) and it just wouldn’t activate, giving the error “”Error: 0xC004F074 The Software Licensing Service reported that the computer could not be activated. The Key Management Service (KMS) [...]

Continue reading...

This article here – http://technet.microsoft.com/en-us/library/cc431377.aspx – outlines how to configure IIS WebDAV for SCCM site systems. This is very fiddly manual process so I’ve created a small batch file to automate this. This is for Windows Server 2008 R2 with the correct IIS components already installed: REM http://technet.microsoft.com/en-us/library/cc431377.aspx REM Enable WebDav %WinDir%\System32\InetSrv\AppCmd.exe set config “Default [...]

Continue reading...

Here’s a neat trick to created an unattended USB boot disk for deploying SCCM OSD task sequences. The machine that you are going to use for this process needs to have the SCCM console loaded on it. The machine also needs to be a Windows Vista, Windows 7 or Windows Server 2008 or higher Operating [...]

Continue reading...