ConfigMgr Collection Creator | Makecoll.exe | SMS/SCCM Collection Creation Script

I created a tool that can be used to easily and quickly create a static collection. ConfigMgr Collection Crerator 1.0 (Makecoll.exe) can be used to create a new collection from a list of NeBIOS computer names.



ConfigMgr Collection Crerator 1.0 can be downloaded from http://smstools.codeplex.com

MSI: Setup failed due to unexpected circumstances The error code is 80041002

Problem:

 
When trying to install the new SCCM client 4.0.6487.2000  everything seems to start and go fine.....   but at the end of it you get the last two lines and it just stops.

 ----------------Start CCMSETUP.LOG----------------
Version: 4.0.6487.2000
Command line parameters for ccmsetup have been specified. No registry lookup for command line parameters is required.
"Command line: ""C:\WINDOWS\system32\ccmsetup\ccmsetup.exe"" /runservice /config:MobileClient.tcf"
CCMHTTPPORT: 80
CCMHTTPSPORT: 443
CCMHTTPSSTATE: 0
CCMHTTPSCERTNAME:
FSP:
CCMFIRSTCERT: 0
Config file: C:\WINDOWS\system32\ccmsetup\MobileClient.tcf
Retry time: 10 minute(s)
MSI log file:
"MSI properties: INSTALL=""ALL"" SMSSITECODE=""HS1"" SMSCACHESIZE=""2048"" CCMHTTPPORT=""80"" CCMHTTPSPORT=""443"" CCMHTTPSSTATE=""0"" CCMFIRSTCERT=""0"""
Source List
file://sccmserver.somedomain.biz/SMSClient
file://sccmserver/SMSClient
MPs:
SCCMSERVER.SOMEDOMAIN.BIZ
Updated security on object C:\WINDOWS\system32\ccmsetup\.
A Fallback Status Point has not been specified. Message with STATEID='100' will not be sent.
"Running as user ""SYSTEM"""
Detected 36580 MB free disk space on system drive.
DetectWindowsEmbeddedFBWF() Detecting OS Version
"Client OS Version is 5.1, Service Pack Version 2"
Client OS is not a supported Windows Embedded Platform
Ccmsetup is being restarted due to an administrative action. Installation files will be reset and downloaded again.
Deleted file C:\WINDOWS\system32\ccmsetup\client.msi
Successfully ran BITS check.
IsFileMicrosoftTrusted Verified file 'C:\WINDOWS\system32\ccmsetup\ccmsetup.cab' is MS signed.
Successfully extracted manifest file C:\WINDOWS\system32\ccmsetup\ccmsetup.xml from file C:\WINDOWS\system32\ccmsetup\ccmsetup.cab.
Loading manifest file: C:\WINDOWS\system32\ccmsetup\ccmsetup.xml
Successfully loaded ccmsetup manifest file.
"Adding file 'http://SCCMSERVER.SOMEDOMAIN.BIZ:80/CCM_Client/i386/client.msi' to BITS job, saving as 'C:\WINDOWS\system32\ccmsetup\client.msi'."
Starting BITS download for client deployment files.
Download Update: 76883 out of 17847296 bytes transferred.
Successfully completed BITS download for client deployment files.
Successfully downloaded client files via BITS.
Updated security on object C:\WINDOWS\system32\ccmsetup\.
An MP does not exist on this machine.
No client is currently installed.
Installing version 4.00.6487.2000 of the client with product code {2609EDF1-34C4-4B03-B634-55F3B3BC4931}
"MSI PROPERTIES are INSTALL=""ALL"" SMSSITECODE=""HS1"" SMSCACHESIZE=""2048"" CCMHTTPPORT=""80"" CCMHTTPSPORT=""443"" CCMHTTPSSTATE=""0"" CCMFIRSTCERT=""0"" SMSPUBLICROOTKEY=0602000000A40000525341310004000001000100E3FE16910549BC7E5EE664FED18FA09085E3BA678C50BB2018D0E525A1295C2FFE7611C7B23EF1A0974744C9785CAC840CA5C1C12FD14B9D37BF62BD70A109F1537B8F1D66D979996FE9007EC8F6DD2E121182C55FC7B9E2E49DBFE3F56E6CFAEF3FF0C1EE6837D95A04ED8A45AD5B198687C372B43AA3D83316A655AB0EF4B8 INSTALL=ALL"
IsFileMicrosoftTrusted Verified file 'C:\WINDOWS\system32\ccmsetup\{4CD82FBB-0AFC-4864-A089-15364DF5F14B}\client.msi' is MS signed.
Running installation package
Package: C:\WINDOWS\system32\ccmsetup\{4CD82FBB-0AFC-4864-A089-15364DF5F14B}\client.msi
Log: C:\WINDOWS\system32\ccmsetup\client.msi.log
" Properties: INSTALL=""ALL"" SMSSITECODE=""HS1"" SMSCACHESIZE=""2048"" CCMHTTPPORT=""80"" CCMHTTPSPORT=""443"" CCMHTTPSSTATE=""0"" CCMFIRSTCERT=""0"" SMSPUBLICROOTKEY=0602000000A40000525341310004000001000100E3FE16910549BC7E5EE664FED18FA09085E3BA678C50BB2018D0E525A1295C2FFE7611C7B23EF1A0974744C9785CAC840CA5C1C12FD14B9D37BF62BD70A109F1537B8F1D66D979996FE9007EC8F6DD2E121182C55FC7B9E2E49DBFE3F56E6CFAEF3FF0C1EE6837D95A04ED8A45AD5B198687C372B43AA3D83316A655AB0EF4B8 INSTALL=ALL"
MSI: Action 15:21:14: INSTALL.
MSI: Setup failed due to unexpected circumstances The error code is 80041002
MSI: Action 14:54:01: Rollback. Rolling back action:


Installation failed with error code 1603
-------------------END LOG ----------------


Resolution:


Rebuild the WMI Repository by following the steps outlined in the following post
http://www.madanmohan.com/2010/10/rebuilding-wmi-repository.html

How to make sure SMS/SCCM site infromation publishing in Active Directory Services

SMS/Sccm does not publish objects correctly in Active Directory if the Active Directory schema has not been extended for SMS/SCCM, or if SMS/SCCM does not have sufficient permissions. Make sure your sites's computer account or the SMS sesrvice account have full control to the System Management container.


•Manually create the System Management container in the Active Directory System container by using the ADSIEdit.msc tool. ADSIEdit is included in the Windows Support Tools folder on the Windows product CD. Grant the appropriate account full control permissions to the System Management container and All Child objects for all SMS sites in the domain.


•Use Active Directory Users and Computers to grant the appropriate account full control permissions to the System Management container and All Child objects for all SMS sites in the domain.

After the appropriate account has full control, it will grant permissions to the management points so the management points can publish their own information to Active Directory. You do not need to manually grant management points permissions to publish to Active Directory.
 To verify whether your site is publishing information in Active Directory, verify hman.log and sitecomp.log


If you site is publishing information properly, then they should look similar as below:
hman.log:
Active Directory DS Root:DC=sccmtraining,DC=com
Searching for the System Management Container.
System Management container exists.
Site objects existing in AD: cn=SMS-Site-SC5.
Searching for SMS-Site-SC5 Site Object.
SMS-Site-SC5 exists, updating.
SMS-Site-SC5 successfully updated.
sitecomp.log:
Publish Servers in Active Directory.
DS Root:DC=SCCMTRAINING,DC=ABC,DC=com
Searching for the System Management Container.
LDAP://CN=System Management,CN=System,DC=SCCMTRAINING,DC=ABC,DC=com container exists.
Site System is the Default Management Point.
No Fallback Status Point installed on the Site
Size of Signing Certificate: 0
Signing Certificate:
Checking configuration information for server: SECONDARY.
SECONDARY is the Default MP.
Updated MP Configuration for SECONDARY.
Installing Security settings on site system ...
Security settings are up to date for SECONDARY.
Installing DNS publishing settings on site system ...
DNS publishing settings are up to date for SECONDARY.
Publishing SECONDARY(SECONDARY.SCCMTRAINING.ABC.com) as a Management Point into Active Directory.
SMS-MP-SE2-SECONDARY successfully updated.

SCCM Console won't start with script errors

Line: 8
Char: 1
Error: '_blank' is undefined
Code: 0
URL: http//technet.microsoft.com/en-us/systemcenter/cm/default.aspx

The MMC ask if you want to continue with the scripts Yes or No is the two options. Both options result in a hung mmc.exe and nothing displays.

Solution: Clear the Temp files and restart the SCCM Console.

System Center Configuration Manager 2007 Toolkit V2

The Configuration Manager 2007 Toolkit V2 contains 11 downloadable tools to help you manage and troubleshoot Configuration Manager 2007.

More info and download link: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5A47B972-95D2-46B1-AB14-5D0CBCE54EB8

SCCM 2007 Database Views Schema

The “Creating Custom Reports by Using Configuration Manager 2007 SQL Views” documentation package is now available for download!!

Creating custom reports in Configuration Manager can be a challenge, not only to create the SQL statement for the report, but to figure out what SQL view contains the information you need and how the SQL views can be joined together. The Windows Installer CreatingCustomReportsByUsingSQLViews.msi package provides information that will help you to create custom reports, determine which Configuration Manager SQL views contain the information you need for your reports, and identify a path between the necessary SQL views and determine what columns can be used to join them. The download package includes the following files:

  • Before You Use – Readme document (BeforeYouUse_Readme.doc):Provides information about how to use the other documents in the Windows Installer download package.
  • Using Configuration Manager 2007 SQL Views to Create Custom Reports help file (CM2007CustomReports.chm): Provides an overview of the Configuration Manager 2007 SQL view schema and SQL views, an overview of the existing reports and associated reporting procedures, sample SQL statements for each Configuration Manager SQL view category, scenarios for creating custom reports, exercises for creating custom reports, an overview for writing report SQL statements, and an overview of the Configuration Manager Provider WMI schema. This documentation will be your main resource throughout the process of creating your custom report.
  • Configuration Manager 2007 SQL View Schema Microsoft Visio document (CM2007SQLViewsSchema.vsd):Provides the Configuration Manager 2007 SQL views schema, organized by category.
  • Configuration Manager 2007 SQL Views Excel spreadsheet (CM2007SQLViews.xls):Provides a list of the Configuration Manager 2007 SQL views with descriptions, a list of the SQL views and columns ordered by SQL view name, and a list of the SQL views and columns ordered by column name.
CreatingCustomReportsByUsingSQLViews.msi Download link: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=87BBE64E-5439-4FC8-BECC-DEB372A40F4A&displaylang=en

System Center Configuration Manager 2007 backups fail with Win32 Error = 145

Microsoft System Center Configuration Manager 2007 backups may fail if other VSS-aware backup software is scheduled to run concurrently. In this scenario, the Smsbkup.log will show entries similar to the following:
Deleting E:\SMSbackup\SiteServer\SMSServer\inboxes\auth\statesys.box\incoming, FAILED, Win32 Error = 145
Deleting E:\SMSBackup\SiteServer\SMSServer\inboxes\auth\ddm.box, FAILED, Win32 Error = 145
Deleting E:\SCCMBackup\Backup, FAILED, Win32 Error = 145
Failed to delete the contents of the backup folder. Error Code = 0x0 SMS_SITE_BACKUP
Error: Deleting the existing files in the backup location failed... SMS_SITE_BACKUP
SMS site backup failed. Please see previous errors. SMS_SITE_BACKUP
SMS site backup service is stopping. SMS_SITE_BACKUP
These errors can occur if the Volume Shadow Copy Service (VSS) provider is in use by another process. Configuration Manager Backup expects to have exclusive access to these resources when performing a backup.

To prevent these errors, configure Configuration Manager Backup to start at a time outside the window for other backup jobs on the server. The schedule for this can be found in the Configuration Manager Console under Site Management -> Site Code -> Site Settings -> Site Maintenance -> Tasks -> Backup ConfigMgr Site Server.

For all the details and the latest version of this document please see the following new Knowledge Base article:

KB2387913 - System Center Configuration Manager 2007 backups fail with Win32 Error = 145

How to verify Management Point is working fine in SCCM 2007

Verify Management Point Installation Logs

1. Verify MPsetup.log. Make sure MP is install successfully, if not resolve the problem. If you find any problem in MPSetup.log, then verify MPMSI.log for more information on the issue.

MPSetup.log:
<12-16-2008 17:12:09> Installing the SMSMP
<12-16-2008 17:12:09> Passed OS version check.
<12-16-2008 17:12:09> IIS Service is installed.
<12-16-2008 17:12:09> SMSMP already installed (Product Code: {3945C886-9779-4280-B537-AB8E62A0878E}). Upgrading/Reinstalling SMSMP
<12-16-2008 17:12:09> New SMSMP is a new product code {{7AF53388-F428-4A8B-8F20-DBB4851E3424}}. This is a major upgrade.
<12-16-2008 17:12:09> Enabling MSI logging. mp.msi will log to D:\SMS\logs\mpMSI.log
<12-16-2008 17:12:09> Installing D:\SMS\bin\i386\mp.msi REINSTALLMODE=vmaus CCMINSTALLDIR=”D:\SMS_CCM” CCMSERVERDATAROOT=”D:\SMS” USESMSPORTS=TRUE SMSPORTS=80 USESMSSSLPORTS=TRUE SMSSSLPORTS=443 USESMSSSL=TRUE SMSSSLSTATE=0 CCMENABLELOGGING=TRUE CCMLOGLEVEL=1 CCMLOGMAXSIZE=1000000 CCMLOGMAXHISTORY=1
<12-16-2008 17:15:59> mp.msi exited with return code: 0
<12-16-2008 17:15:59> Verifying CCM_CLIENT virtual directory.
<12-16-2008 17:15:59> Website path is IIS://LocalHost/W3SVC/1.
<12-16-2008 17:15:59> Connecting to IIS.
<12-16-2008 17:15:59> CCM_CLIENT is currently D:\SMS\Client
<12-16-2008 17:15:59> Installation was successful.
2. Check IIS and make sure that you have virtual directory named SMS_MP under default website.
3.Check mpcontrol.log and find if you have below sucesses status message (Status Code 200). ( I use tracert32 to read log files)
Call to httpsendrequestsync succeeded for port 80 with status code 200,text ok
http test request succeeded

successfully performed Management Point avaialbility check against local computer

4. Fianlly for testing run this on IE from any client and from the server itself and you sould get the results mentioned.

  a) Run http://<MP Name>/sms_mp/.sms_aut?mplist

   This returns a list of MP's installed on this site including the secondary site MP's.

  b) Run http://<MP Name>/sms_mp/.sms_aut?mpcert

   This returns a long list of numbers and letters.

Output of Step a
- <MPList>
- <MP Name="smsserver1" FQDN="smsserver1.example.abc.com">
<Version>6487</Version>
<Capabilities SchemaVersion="1.0" />
</MP>
- <MP Name="smsserver18" FQDN="smsserver18.example.abc.com">
<Version>6487</Version>
<Capabilities SchemaVersion="1.0" />
</MP>
- <MP Name="smsserver2" FQDN="smsserver2.example.abc.com">
<Version>6487</Version>
<Capabilities SchemaVersion="1.0" />
</MP>
- <MP Name="secondary1" FQDN="secondary1.example.abc.com">
<Version>6487</Version>
<Capabilities SchemaVersion="1.0" />
</MP>
</MPList>
More Info on MP and resolving issues:

http://technet.microsoft.com/en-us/library/cc180197.aspx
http://technet.microsoft.com/en-us/library/cc180195.aspx 
 
 

Determine which NTFS drive should have distribution point

First time when you distribute the package to distribution point then SMS/SCCM chooses the NTFS drive which has maximum free space.If you have 2 to 3 NTFS drives and you want to chosse one of them. There is no provision given at SMS/SCCM server side to prevent SMS/SCCM from using a NTFS dirve with maximum free space. Also, if any drive that is currently being used for distribution point is full, then SMS/SCCM starts using the next available drive with maximum.

Method 1:

Create the blank text file on the other drives with the name NO_SMS_ON_DRIVE.SMS which will prevent respective NTFS drive from creating SMSPKGC$ (Here C represents the drive) folder.This file named NO_SMS_ON_DRIVE.SMS needs to be placed at the root of the drive you want excluded.Drive which dont has NO_SMS_ON_DRIVE.SMS file,will have SMSPKGC$ folder.
 
Method 2:

Insted of installing a standard distribution point,install a distribution point on a server share.

1) Create a folder called smspkgx$ on the partition you want it and share that folder. (x is the drive letter of your choice).

2) Create the distribution point on a share basis in the sms admin console instead of on a server name. (Share has to exist). Just right-click site systems inside the sms admin console, select new, server share, ...)


Microsoft Article: http://support.microsoft.com/kb/871234

Rebuilding and reinstalling the WMI Repository

If you experience behavior when using WMI, such as application errors or scripts that used to work are no longer working, you may have a corrupted WMI repository. To fix a corrupted WMI repository, use these steps:

Windows XP and Windows Vista

Click Start -> Run and type CMD.EXE
Note: In Windows Vista, you need to open an elevated Command Prompt window. To do so, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.

Type this command and press Enter:

net stop winmgmt

Using Windows Explorer, rename the folder %windir%\System32\Wbem\Repository. (For example, %windir%\System32\Wbem\Repository_bad). %windir% represents the path to the Windows directory, which is typically C:\Windows.

Switch to Command Prompt window, and type the following and press ENTER after each line:
net start winmgmt
EXIT

For Windows XP Service Pack 2 and Service Pack 3

Click Start, Run and type the following command:
rundll32 wbemupgd, UpgradeRepository

This command is used to detect and repair a corrupted WMI Repository. The results are stored in the setup.log (%windir%\system32\wbem\logs\setup.log) file.

For Windows Vista

Open an elevated Command Prompt window. To do so, click Start, click All Programs, click Accessories, right-click Command Prompt, and then click Run as administrator.
Type the following command:

winmgmt /salvagerepository

The above command Performs a consistency check on the WMI repository, and if an inconsistency is detected, rebuilds the repository. The content of the inconsistent repository is merged into the rebuilt repository, if it can be read.

For Windows Server 2003

Use the following command to detect and repair a corrupted WMI Repository:

rundll32 wbemupgd, RepairWMISetup

Re-registering the WMI components

The .DLL and .EXE files used by WMI are located in %windir%\system32\wbem. You might need to re-register all the .DLL and .EXE files in this directory. If you are running a 64-bit system you might also need to check for .DLLs and .EXE files in %windir%\sysWOW64\wbem.

To re-register the WMI components, run the following commands at the command prompt:
  • CD %windir%\system32\wbem
  • for /f %s in ('dir /b /s *.dll') do regsvr32 /s %s
  • for /f %s in ('dir /b *.mof') do mofcomp %s 
Registering WMI Service itself

Open the command console, type "net stop winmgmt". When you get the warning that other services need to be stopped type 'Y' and continue.

Open 'My Computer' and then go to the folder '%SystemRoot%\System32\WBEM\Repository' and delete that folder.

Reboot your system.

After you login, open the command console, and type the following commands in order: 

winmgmt /clearadap
winmgmt /kill
winmgmt /unregserver
winmgmt /regserver
winmgmt /resyncperf
Note: If this doesn't fix the problem, you need to try reinstalling Comprehensive rebuild method.

Comprehensive rebuild method

Important note: If you've installed a Service Pack, you need to insert your Windows XP CD with Service Pack integration (called as the Slipstreamed Windows XP CD). If you don't have one, you may point to the %Windir%\ServicePackFiles\i386 folder for a recent version of the system files required during WMI repair. Or you may create a slipstreamed Windows XP CD and insert it when prompted.


Click Start, Run and type the following command, and press ENTER:

rundll32.exe setupapi,InstallHinfSection WBEM 132 %windir%\inf\wbemoc.inf

Insert your Windows XP CD into the drive when prompted. Repair process should take few minutes to complete. Then restart Windows for the changes to take effect.

Note that none of the above two methods restore the missing files related to Windows Management Instrumentation (WMI). So, below is a comprehensive repair procedure that restores all the missing WMI modules. In case of missing WMI modules, you may use the following method.

Repair WMI using BAT File:

Most of the WMI problems can be solved by rebuilding the WMI Repository, re-registering the WMI components. To automate this, you could create a BAT file. Copy the following lines to a text file and save it with .BAT extension and run it to fix common WMI issues.
net stop winmgmt /y
%SYSTEMDRIVE%
CD %windir%\system32\wbem
rd /S /Q repository
net start winmgmt
for /f %%s in ('dir /b /s *.dll') do regsvr32 /s %%s
for /f %%s in ('dir /b *.mof') do mofcomp %%s

SCCM WSUS Synchronization failed!

Error in wsyncmgr.log:
Sync failed: LocalDBOtherError: SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.~~at Microsoft.UpdateServices.DatabaseAccess.DBConnection.DrainObsoleteConnections(SqlException e). Source: Microsoft.SystemsManagementServer.SoftwareUpdatesManagement.WSyncAction.WSyncAction.SyncWSUS
 
Resolution:
Clean the WSUS and maintain WSUS.
 
Here are two methods that should be used to maintain a WSUS hierarchy:
Re-index the WSUS 3.0 Database

http://gallery.technet.microsoft.com/ScriptCenter/en-us/6f8cde49-5c52-4abd-9820-f1d270ddea61

Run the Re-Index monthly. This can be run in any order within the hierarchy since it simply improves performance of WSUS database.
 NOTE: In addition to the steps covered in the link above, the following changes may be required:
  • If you are hosting the WSUS database (SUSDB) on a full SQL server instead of using Windows Internal Database (WIDS), you can simply run the re-index as a SQL query using SQL Management Studio
  • On a Windows Server 2008 R2 server, you have to update the recommended command line to the following to get the script to work with WIDS:
sqlcmd -i WSUSDB.sql -S \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query -E -I

You also have to install the SQL Native Client and the SQLCMD utility from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Run the WSUS Server Clean-Up Wizard
  • You MUST run the WSUS Server Clean-up Wizard from the bottom of the WSUS hierarchy to the top and NEVER from the top down.
  • You should run the WSUS Server Clean-Up Wizard throughout the hierarchy on a monthly basis. To help with this effort, you may want to automate the wizard using any of the following:
  • PowerShell script sample for accessing the WSUS API for the cleanup functions: http://gallery.technet.microsoft.com/ScriptCenter/en-us/fd39c7d4-05bb-4c2d-8a99-f92ca8d08218
  • Sample tool that handles the WSUS Cleanup wizard functions and offers a method to call the WSUSDBMaintenance script which can be useful if you run it as a scheduled task from the bottom of the hierarchy to the top on a monthly basis: http://wsus.codeplex.com/releases/view/17612
How to Run WSUS Cleanup Wizard:
 To run the Server Cleanup Wizard

In the WSUS administration console, select Options, and then Server Cleanup Wizard.
  1. By default this wizard will remove unneeded content and computers that have not contacted the server for 30 days or more. Select all possible options, and then click Next.
  2. The wizard will begin the cleanup process, and will present a summary of its work when it is finished. Click Finish to complete the process.



How to use Preload Package Tool for Configuration Manager 2007 to load package on SCCM Site

The Preload Package Tool (PreloadPkgOnSite.exe) is used to manually install compressed copies of software distribution package source files on Configuration Manager 2007 sites. After package source files are installed, a status message is sent up the site hierarchy indicating the presence of the new package source files. This avoids sites higher in the hierarchy from copying package source files over the network when distribution points at child site are selected to host software distribution package content that has already been preloaded on them.

  • Copy .PCK files from a backup location to the distribution point share (Ex c:\smspkg) on the site manually. After manually copying the files, ensure that the read-only NTFS file attribute for the .PCK file is set.
  • Copy PreloadPkgOnSite.exe file to the distribution point share directory (c:\smspkg) on the child site that you wish to preload compressed software distribution package source (.PCK) files.
  • From a command prompt, run the tool using the following syntax:
    PreloadPkgOnSite.exe [PkgID]
    This command need to be run for each PCK files that need to be loaded on the secondary site.
Running this command will update necessary software distribution package source location information for the site and forward this information up the hierarchy.
  • Open the System Center Configuration Manager
  • Drill down and choose the central site from where the packages need to be distributed
  • Choose:
         Systems Center Configuration Manager
                 ->Site Database (site code - site name)
                           ->Computer Management
                                     -> Software Distribution
                                             -> Packages
  • Select the package that needs to be distributed to the site.

         Right click on the package.

         Select Manage Distribution Points
  • In the Welcome screen

           Click Next


  • In the Select Destination Distribution Point
Select Copy the package to new distribution points
  • Click Next
  • In the Package page
         Select the SCCM Site where you need to distribute the package.
         Click Next
         In the Completion Page
         Click Next
  • In the Confirmation Page
            Click Close
  • Repeat these Step for each package that need to be distributed to the SCCM Site.
  • Review the distmgr.log on SCCM sites to ensure that all the package are successfully distributed to the SCCM site.

Creating dynamic collection by selecting objects not in a collection

If you are interested in a way of retrieving objects into a collection that don't exist in another collection, it's actually not very difficult. For example, you have a collection of clients with antivirus. Now you want to create a collection of clients that do not have antivirus. Instead of creating a new one, you run subselect to bring back all the clients that are not in the original antivirus collection.

The only thing you have to know is the collection id of the collection that you want to check. For the samples below, note that [collid] is a generic tag for your collection ids. If you examine the root\sms\site_ of your sms server, you'll see a list of sms collections labeled with:

 sms_cm_res_coll_[collid]

This is what you need to build your subselect query. If you query this in wbemtest, with something like select * from sms_cm_res_coll_[collid] you should get back a list of resource ids which look something like this
 ...
sms_cm_res_coll_[collid].resourceid=1
sms_cm_res_coll_[collid].resourceid=2
sms_cm_res_coll_[collid].resourceid=3
sms_cm_res_coll_[collid].resourceid=4
sms_cm_res_coll_[collid].resourceid=5
...

or something similar... I was showing that part just to demonstrate that querying the collection id from wmi in this manner, does indeed produce the members of the collection. now to put it all together, this is how you'd build your subselect query

select sms_r_system.resourceid, sms_r_system.name
from sms_r_system
where resourceid not in
(
select sys.resourceid
from sms_cm_res_coll_[collid] AS coll, sms_r_system as sys
where sys.resourceid = coll.resourceid
)

In effect, this would be the same as building a collection that's limited to another collection. the only difference is that when you're using limiting collections, you can't specify to retrieve where a machine doesn't exist in a certain collection.