SCCM 2007

Create a collection with systems without Adobe Reader 9

by

select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_R_System.OperatingSystemNameandVersion not like “%Server%” and SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId 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 like “%Adobe Reader 9%”)

Windows Installer : MSIEXEC Silent Install End to END

by

The Windows Installer technology uses Msiexec.exe for installing MSI and MSP packages. This tool gives you full control over the installation process, allowing you to set: install options (install, uninstall, administrative install, advertise a product) display options (full, basic or no UI during the installation) restart options (if the machine will be restarted after the … Read more

Online resources for SCCM training

by

Online hosted virtual machines :  https://www.microsoft.com/systemcenter/configurationmanager/en/us/virtual-labs.aspx Downloadable VHD of with sccm 2007 R2 installed. https://www.microsoft.com/downloads/details.aspx?familyid=E0FADAB7-0620-481D-A8B6-070001727C56&displaylang=en

The Microsoft Assessment and Planning (MAP) Toolkit : MAP

by

The Microsoft Assessment and Planning (MAP) Toolkit is an agentless toolkit that finds computers on a network and performs a detailed inventory of the computers using Windows Management Instrumentation (WMI) and the Remote Registry Service. The data and analysis provided by this toolkit can significantly simplify the planning process for migrating to Windows® 7, Windows … Read more

Miscellaneous notes for “Dummy”s

by

Never select a PXE Distribution Point when deploying packages. This may stop that PXE point from functioning. Use the list of DP Groups or select the specific DPs required. When setting up Advertisements to execute at specific times use:- UTC if you want the installation to start at the same time the world over regardless … Read more

WMI Repair Command:- For Windows 2008 and Windows Vista/7

by

For For Windows 2008 and Windows Vista/7 winmgmt  /salvagerepository   For Windows Server 2003 rundll32 wbemupgd, RepairWMISetup cd /d %windir%system32wbem for %i in (*.dll) do RegSvr32 -s %i for %i in (*.exe) do %i /RegServer Note that none of the above two methods restore the missing files related to Windows Management Instrumentation (WMI). So, below … Read more