Hide cscript.exe window for MDT general purpose wizard hook

As you could notice at this post by Michael Niehaus, on a back there is a big “dos” window with a script being running. This happens because OSD always runs windows scripts in pre-exec hook with CSCRIPT.EXE, even if you specify WSCRIPT.EXE in the command line. In order to hide it, simply copy files to your C:\Program Files\Microsoft Deployment Toolkit\SCCM\ folder with files…

1

Count anything with unique Serial Number

Here is how I do it for OS and Service Packs select Caption0, CSDVersion0, COUNT(1) from  ( select distinct SerialNumber0, (select top 1 Caption0 from dbo.v_GS_OPERATING_SYSTEM where v_GS_OPERATING_SYSTEM.ResourceID = v_GS_PC_BIOS.ResourceID order by ResourceID desc) as Caption0, (select top 1 CSDVersion0 from dbo.v_GS_OPERATING_SYSTEM where v_GS_OPERATING_SYSTEM.ResourceID = v_GS_PC_BIOS.ResourceID order by ResourceID desc) as CSDVersion0 from v_GS_PC_BIOS )…

0