Links and notes from Mastering Configuration Manager 2007 R3 training (updated February, 17 2010)

 Websites: 
http://www.microsoft.com/smserver/default.mspx – SMS 2003 homepage
http://www.microsoft.com/systemcenter/en/us/default.aspx – System Center homepage
http://social.technet.microsoft.com/Forums/en-US/category/configurationmanager/ – Configuration Manager News groups
http://www.microsoft.com/events/series/technetmms.aspx?tab=webcasts&id=42364 – Configuration Manager webcasts
http://www.microsoft.com/systemcenter/configurationmanager/en/us/default.aspx – Config Mgr. homepage
http://www.myitforum.com/ – Great community
http://www.smsexpert.com/ – Information about MOF editing
http://www.1e.com/ – Config Mgr. addons
http://blogs.technet.com/configmgrteam/default.aspx – System Center Config Mgr. team blog
http://v-irtualization.com/tag/app-v/ – How to virtualize 3D games using the App V. sequencer
http://technet.microsoft.com/en-us/library/bb892800.aspx – List of Configuration Manager log files
http://blogs.technet.com/b/configurationmgr/archive/2010/11/30/configmgr-2007-antivirus-scan-and-exclusion-recommendations.aspx – ConfigMgr 2007 Antivirus Scan and Exclusion Recommendations
http://blogs.technet.com/b/yasc/archive/2010/09/18/asset-intelligence-license-wizard-v1-4.aspx – Asset Intelligence License Wizard

Tools:
http://www.microsoft.com/technet/scriptcenter/tools/scripto2.mspx – Scriptomatic
http://sourceforge.net/projects/smsclictr – Config Mgr Client Center
http://www.myitforum.com/myITWiki/SCCMTools.ashx – SCCM Right click tools and more
http://www.myitforum.com/inc/upload/12336RegKeyToMOF.zip – Tool from Mark Cochrane to assist you in creating the correct entries in Configuration.MOF and SMS_def.mof
http://www.quest.com/quest-management-xtensions-configuration-manager/ – Extend Config Mgr. 2007 support for other operating systems such a AIX, MAC OS etc.
http://www.1e.com/Downloads/FreeTools/Index.aspx – 1E free tools (package migration tool, WMI tool, Service Window tool and more)
http://myitforum.com/cs2/blogs/cstauffer/archive/2009/03/06/sccm-migration-change-site-code-exe-style.aspx – Script and program to assign new site code
http://www.adobe.com/support/downloads/detail.jsp?ftpID=3993 – Adobe Customization Wizard
http://3d2f.com/tags/magic/packet/wol/ – Apps for testing Wake On LAN

Config Manager 2007 R2 VHD:
http://www.microsoft.com/downloads/details.aspx?FamilyID=e0fadab7-0620-481d-a8b6-070001727c56&displaylang=en

Troubleshooting Management Point:
http://siteservername/SMS_MP/.sms_aut?MPCERT
http://siteservername/SMS_MP/.sms_aut?MPList

Other sites:
http://msdn.microsoft.com/en-us/library/ms675090(VS.85).aspx – List of Active Directory attributes names to be used in system and user discovery
http://blogs.technet.com/b/systemcenter/archive/2010/09/20/mvp-guest-blog-how-to-save-money-with-configmgr-2007-r3-and-feel-good-about-it.aspx – How to save money with ConfigMgr 2007 R3 and feel good about it
http://www.truesec.com/news – Sign up for the TrueSec newsletter

Blogs:
http://blogs.technet.com/configurationmgr/default.aspx – The ConfigMgr. support team
http://blogs.technet.com/wemd_ua_-_sms_writing_team/ – The ConfigMgr. writers team

script to change the site assignment

Dim oSMSClient
Dim oUIResManager
Dim oUIResource

set oSMSClient = CreateObject ("Microsoft.SMS.Client")
set oUIResManager = createobject("UIResource.UIResourceMgr")
Set oUIResource = CreateObject("UIResource.UIResourceMgr")
Set objCacheInfo = oUIResource.GetCacheInfo
Set oCache=oUIResManager.GetCacheInfo()

if Err.Number <>0 then
wscript.echo "Could not create SMS Client Object – quitting"
end if

‘Assign client to Servername
oSMSClient.SetAssignedSite "CT1",0

set oSMSClient=nothing

Configuration.Mof

In order to enable CALtracking modify the configuration.mof file. Change the Calcollectiontype from 0 to 3

/ CAL tracking server side configurations and policy
[Singleton]
class CCM_CALTrackConfig
{
    uint32   CALCollectionType;
    uint32   CALCollectionFrequencyDays;
    uint32   CALCollectionFrequencyMinutes;
    uint32   CALCollectionTimeWindow;
    string   CALCollectionSupportedWindowsVersions;

};

instance of CCM_CALTrackConfig
{
    CALCollectionType = 3; //0-Disabled, 1-User CAL, 2-Device CAL, 3-All
    CALCollectionFrequencyDays = 7;
    CALCollectionFrequencyMinutes = 60;
    CALCollectionTimeWindow = 90;
    CALCollectionSupportedWindowsVersions = "5.0,5.2,6.0";

};

Collection design for Software Update Management

Inventory files

To prevent software inventory in a certain folder/drive create a hidden file called skpwi.dat and place the file in the root of the folder/drive.

To prevent the Inventory agent from deleting inventory xml files from the client; create a file called archive_reports.sms and place it in the hardware inventory temp folder %systemroot%\system32\ccm\inventory\temp\. This can be very useful when you want to track the size of each inventory file.

Troubleshooting client deployment

Site server log file:

• CCM.log – check for errors related to copying the ccmsetup.exe file to the client

Client log files:

• The installation process
  • ccmseup.log
  • client.msi.log
• The site assignment process
  • clientidmanager.log
  • clientlocation.log
• The policy process
  • policyagent.log
  • policyevaluator.log

Errors you might run into

Clientidmanager.log has this entry Error initializing client registration (0x80040222).

To fix the error delete the SMS client certificates.

1. Open a MMC
2. Add the computer Certificates snap-in for the local computer
3. Navigate to the SMS certificate store and delete all the certificates
   
4. Restart the computer and monitor the clientidmanager.log file

WMI related errors

Before you start deleting and rebuilding the WMI repository check this in the listed order. If one step works the repository works

• Perform some basic WMI testing – http://blogs.technet.com/b/askperf/archive/2007/06/22/basic-wmi-testing.aspx
• Check DCOM, WMI permissions and GPO settings
• Open a command prompt with admin rights and type wmic computersystem get model
• Open a command prompt with admin rights and type winmgmt /verifyrepository
• Open a command prompt with admin rights and type winmgmt /Resetrepository

Rebuild the WMI repository

1. Log on to the client computer
2. Stop the WMI service
3. Navigate to .\System32\WBEM\
4. Rename to the folder Repository to Repository.old
5. Start the WMI service and restart the client installation process.

Reassign clients to another site

‘replace with your Site Code
sSiteCode = "TypeYourSiteCodeHere"
sMachine = "."
set oCCMNamespace = GetObject("winmgmts://" & sMachine & "/root/ccm")
Set oInstance = oCCMNamespace.Get("SMS_Client")
set oParams = oInstance.Methods_("SetAssignedSite").inParameters.SpawnInstance_()
oParams.sSiteCode = sSiteCode
oCCMNamespace.ExecMethod "SMS_Client", "SetAssignedSite", oParams

Administrator Console

Start the admin console in debug mode:
adminconsole.msc /SMS:debugview (the admin console is found in C:\Program Files\Microsoft Configuration Manager\AdminUI\bin folder)

For more information check – http://technet.microsoft.com/en-us/library/bb693533.aspx

Collections:

Computer that failed to run an advertisement:
select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID  WHERE AdvertisementID = ‘A0120005’ and LastStateName = ‘Failed’

Computer that ran an advertisement successfully:
select sys.ResourceID,sys.ResourceType,sys.Name,sys.SMSUniqueIdentifier,sys.ResourceDomainORWorkgroup,sys.Client from sms_r_system as sys inner join SMS_ClientAdvertisementStatus as offer on sys.ResourceID=offer.ResourceID  WHERE AdvertisementID = ‘A0120005’ and LastStateName = ‘Succeeded’

Notice for both collections you need to find the unique advertisement ID

Workstation computers that have not restarted the last 7 days:
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_OPERATING_SYSTEM ON SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId  WHERE (SMS_G_System_OPERATING_SYSTEM.Caption like "%xp%" or SMS_G_System_OPERATING_SYSTEM.Caption like "%vista%" or SMS_G_System_OPERATING_SYSTEM.Caption like "%windows 7%") and (DateDiff(day, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, GetDate()) >7)

All Obsolete Clients:

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 where SMS_R_System.Obsolete = 1

All Inactive Clients:

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 where SMS_R_System.Active = 0

All Clients without a Config Mgr. Agent installed:

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 where SMS_R_System.Client is null

All Unapproved clients

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_CM_RES_COLL_SMS00001 on SMS_CM_RES_COLL_SMS00001.ResourceId = SMS_R_System.ResourceId where SMS_CM_RES_COLL_SMS00001.IsApproved<>1