Sudheesh Blog on System Center.......

SEDO (Serialized Editing of Distributed Objects) ConfigMgr 2012

2012-10-28T07:19:00Z

SEDO(Serialized Editing of Distributed Objects)

As global data is replicated everywhere, a user on a primary site could change an object at the same time as a user on the CAS or other primary servers. This is an unavoidable consequence of replicated data. SEDO provides a way to enforce that only a single user can edit an object at any point in time. SEDO does it by using a lock request and release mechanism.

The process goes like the below in a nutshell…..

SEDO Lock Acquisition \release Process

1. Administrator attempts to edit object in Admin Console
2. Admin Console attempts to open object from Provider for editing
3. Local site sends SEDO lock request to CAS using SQL Service Broker (SSB) SEDO queue
4. CAS forwards the SEDO lock request on to the owning site if it does not know who had the lock before. If it knows already, then it will forward SEDO to that site which had the previous lock request.
5. Owning site\Site which had the previous lock request assigned will issue a SEDO Lock and records it in the SEDO_LockableObjects table.
6. DRS replicates the change to the SEDO_LockableObjects
7. Provider reads the obtained lock and allows administrator to edit the object.
8. Now when finished editing, the site which has the lock releases the lock.

You can get the information of the objects in lockstate from this view vSEDO_LockState. If you are concerned about a particular object this is how you can get the information
For instance, we take a Task Sequence (TS) with ID as ‘PR100001’.

select Lockstate,Assignedsite,Assigneduser from dbo.vSEDO_LockState where lockid in (
select lockid From dbo.SEDO_LockableObjects where objectid in(
select objectid from dbo.SEDO_LockableObjectCOmponents where componentid
in( select SEDOcomponentID from SMSpackages where PKGID = 'PR100001')))

Or say if it is a CI item like an application with Ci_uniqueid 'ScopeId_C83F5B89-111D-4EA7-A4E4-70539294E4D7/Application_7d2683d2-5c0b-4989-b834-d88e581fb9f6/2'

select Lockstate from dbo.vSEDO_LockState where lockid in (
select lockid From dbo.SEDO_LockableObjects where objectid in(
select objectid from dbo.SEDO_LockableObjectCOmponents where componentid
in( select SEDOcomponentID from CI_configurationitems where CI_uniqueid ='ScopeId_C83F5B89-111D-4EA7-A4E4-70539294E4D7/Application_7d2683d2-5c0b-4989-b834-d88e581fb9f6/2')))

Now let us go into details of how we can track the SEDO flow when the object ‘PR100001’ whose owner site is PR1 on the hierarchy (shown below) is opened for editing :-

We can use this query to track the flow from the Vlogs table. Some information will be also available in the SMSProv.log.

select * from vlogs where procedurename <> 'spDRSSendChangesForGroup' and logtime >= getdate()-1 order by logtime desc

Scenario 1:
Opened object PR100001 from PR1 server.You could see that PR1 server forwarding the request to Parent Site CAS, carried by SSB to CAS and CAS assigns the lock and information received back again using SSB.

Once we close the object in PR1, it will release the lock promptly as shown below.

Scenario 2:
Object opened in PR2 whereas the owner was PR1.

PR2 request CAS on lock request, goes to the CAS as SSB message, CAS receives and forwards the same to PR1 as it is not the owner of the object, again through SSB message. PR1 receives the request lock the object and send the information to CAS and CAS to the PR1 again through SSB messaging.

Scenario 3:

PR1 owned object opened by CAS with no lock obtained so far by any site.

In this flow if the last assigned site was PR2 and when CAS is trying to open, then SEDO request goes to PR2 and not PR1.

Scenario 4:

PR1 owned object opened by CAS which was already opened for editing in PR2

Since this was already opened for editing By PR2 you will find the following information in CAS

select Lockstate,Assignedsite,Assigneduser from dbo.vSEDO_LockState where lockid in (

select lockid From dbo.SEDO_LockableObjects where objectid in(

select objectid from dbo.SEDO_LockableObjectCOmponents where componentid

in( select SEDOcomponentID from SMSpackages where PKGID = 'PR100001')))

Now as CAS knows it was last assigned to PR2, it sends a request to PR2 to see if lock was released and then the PR2 will revert back telling the lock is not released and deny the request which make the CAS to open the object in read only mode.

Hope this helps in troubleshooting SEDO issues.

Sudheesh Narayanaswamy
Support Escalation Engineer
Microsoft System Center Support

DRS Initialization In Configuration Manager 2012

2012-10-21T04:45:00Z

DRS Initialization In Configuration Manager 2012

When a site is first installed it establishes an initial synchronization with the sending site so that subsequent data changes are applied to an identical data set as that at the sending site.

By default the first replication group processed is the Replication Configuration group - this group effectively 'bootstraps' the receiving site with the remaining configuration for other replication groups.

The site initializes by sending an 'init' request to the sending site for the desired replication group.

When the sending site receives the 'init' request it uses the bcp application to extract all of the data from the tables that make up the replication group being initialized. At the same time a rowcount of the number of exported rows is also taken and stored in a .rowcount file. This allows the receiving site to ensure it has imported the same number of rows as the sending site exported for import.

The sending site sets the receiving site as a subscriber to the replication group and RCM begins sending any changes to tables in the replication group to the receiving site. The bcp files are replicated to the receiving site via the standard content sender.

Once the bcp files have arrived at the receiving site, RCM on the receiving site is notified of the files in its inbox and begins a cycle of actions for each table in the replication group:

Any existing data in the destination table that overlaps with the received data from the sending site is deleted from the table.
BCP is used to import the data from the sending site into the receiving site database.
After the import has completed the rowcount from the bcp process is compared to the row count in the .rowcount file. Assuming the values match the next table is processed.

Once all the tables have been processed the group status is changed to active and the site begins processing any messages in the queue.

We will also try re-initialization if we see any error on any specific group. When you run replication analyzer it will try auto remediate once and that particular group will be re-initialized.

We can also re-initialize putting a .pub file in RCM.box . The file <replicationgroupname>.pub works fine for Global Data. But for site-data where the CAS is the subscriber you have to add the sitecode to the file name, so it is like <replicationgroupname>-<sitecode>.pub, this is so the CAS knows which primary to re-init from.

Global data eg: configuration data.pub => Drop these on Primary server RCM.BOX

Site Data eg: hardware_inventory_8-PR1.pub => Drop these on CAS server RCM.BOX

This is all theory, Now what it if it is failing to re-initialize. The question we all have is, where to look and how to track. The remaining part of this document will go through that.

Always exec spdiagdrs is always a way to know if the replication is active. I will not be going to the details of the output here but will take you through the flow of re-initialization of a particular group.

Once we find that a particular group is having error in the output of spdiagdrs you will find that the following in the hierarchy information as well

This means that there is a Site data replication issue. Also under monitoring you will find the same information with a Link error for site data with Link error

So now to solve this we will re-initialize the group and track the flow. In this I am taking hardware_inventory_8 as an example. To re-initiate a specific group there are various method the safe method according to me is to put <Groupname>-<SITECODE>.pub in our case eg : hardware_inventory_8-PR1.pub

I enable enhanced logging to get more information so that it will be helpful to understand what happened when we see error again and again

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Components\SMS_REPLICATION_CONFIGURATION_MONITOR ==>Verbose Logging : 2

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\Tracing ==>Sqlenabled : 1

We have two kind of logging in ConfigMgr 2012. For DRS initialization we can use the rcmctrl.log and inside the database vlogs view. For the database I used the following query to get the data out of it while I was performing this action.

Select * from vLogs where LogTime >GETDATE()-1 and ProcedureName <> 'spDRSSendChangesForGroup' ORDER BY LogTime DESC

To re-initialize the group put the file in \Microsoft Configuration Manager\inboxes\rcm.box .In some time we will see that vanishing from the box and the RCM will take control.Once the same happens you will see the following in the rcmctrl.log in CAS

Processing replication group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:02:24 1820 (0x071C)

Current status is Active. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:02:24 1820 (0x071C)

Requesting initialization for replication group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:02:24 1820 (0x071C)

Checking if initialization request is needed for replication group Hardware_Inventory_8 from site PR1. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:02:27 1820 (0x071C)

LogLine	LogTime	ComponentName	MachineName	ProcedureName	LogText
429508	02:24.9	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Received DRS_SubscriptionInvalid from Site CAS for replication group: Hardware_Inventory_8 and fulfilling site: PR1 and requesting site: CAS
429509	02:24.9	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: DRS_SubscriptionInvalid is for full initialization - marking required replication group.
429510	02:24.9	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Finished processing DRS_SubscriptionInvalid from Site CAS for replication group: Hardware_Inventory_8

Now on the primary server on the rcmctrl.log you will see

Processing replication role: DrsReplicationSite, child SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:03 3364 (0x0D24)

Processing replication group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:03 3364 (0x0D24)

Current status is PendingCreation. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:03 3364 (0x0D24)

Checking if we need to create an initialization package for replication group Hardware_Inventory_8 for site CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:04 3364 (0x0D24)

STATMSG: ID=7802 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_REPLICATION_CONFIGURATION_MONITOR" SYS=CMLABPRI.CMLAB.COM SITE=PR1 PID=5060 TID=3364 GMTDATE=Sat Oct 20 09:03:04.342 2012 ISTR0="CAS" ISTR1="Hardware_Inventory_8" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:04 3364 (0x0D24)

Flushing DRS queue messages coming from CAS for replication group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:04 3364 (0x0D24)

Changed the status of ConfigMgrDRSSiteQueue to OFF if it exists. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:04 3364 (0x0D24)

Changed the status of ConfigMgrDRSSiteQueue to ON if it exists. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

Files will be copied to directory C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

Cab File to be sent will be copied to directory C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\CabFiles. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

XML CreateTime: 20-10-2012 09:02:31 LastModifyTime: 20-10-2012 09:02:31 SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

Creating version file C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\781708.version SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

Creating trackingGuid file C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\d74dc244-a526-4387-86b0-efacf67df680.trackingGuid SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

Creating pubName file C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\Hardware_Inventory_8-PR1.pubName SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

………………………..

……………………….

Calling BCP out with SELECT BINFILEVERSION00, BINPRODUCTVERSION00, DESCRIPTION00, FILENAME00, FILEPROPERTIESHASH00, FILEPROPERTIESHASHEX00, FILEVERSION00, LOCATION00, PRODUCT00, PRODUCTVERSION00, PUBLISHER00, STARTUPTYPE00, STARTUPVALUE00, MACHINEID, INSTANCEKEY, TIMEKEY, REVISIONID, AGENTID, ROWVERSION~FROM AUTOSTART_SOFTWARE_HIST where (MachineID between 16777216 and 33554431) , C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\AUTOSTART_SOFTWARE_HIST.bcp, C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\bcpErrors.errors. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

………………………………..

……………………………….

Successfully created BCP file [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\AUTOSTART_SOFTWARE_DATA.bcp] with rows [6] based on SQL query [SELECT BINFILEVERSION00, BINPRODUCTVERSION00, DESCRIPTION00, FILENAME00, FILEPROPERTIESHASH00, FILEPROPERTIESHASHEX00, FILEVERSION00, LOCATION00, PRODUCT00, PRODUCTVERSION00, PUBLISHER00, STARTUPTYPE00, STARTUPVALUE00, MACHINEID, INSTANCEKEY, TIMEKEY, REVISIONID, AGENTID, ROWVERSION~FROM AUTOSTART_SOFTWARE_DATA where (MachineID between 16777216 and 33554431) ] SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

BCP out result is 0. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

Table XML: <TABLE NAME="AUTOSTART_SOFTWARE_HIST"><COLUMN COLUMN_ID="1" NAME="BINFILEVERSION00" TYPENAME="nvarchar" TYPEID="231" MAX_LENGTH="510" IS_NULLABLE="1" HAS_DEFAULTVALUE="0" /><

………………………..

…………………………

SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:07 3364 (0x0D24)

This shows the BCP out commands being fired and also you will see the files like shown in the figure below. The Version file ,trackinguid file, Errors file ,pubnamefile and then for each table in the group .bcp file and .row count file.

In the database on the primary you will see the following .

LogLine	LogTime	ComponentName	MachineName	ProcedureName	LogText
7E+16	02:24.9	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Received DRS_SubscriptionInvalid from Site CAS for replication group: Hardware_Inventory_8 and fulfilling site: PR1 and requesting site: CAS
7E+16	02:24.9	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: DRS_SubscriptionInvalid is for full initialization - marking required replication group.
7E+16	02:24.9	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Finished processing DRS_SubscriptionInvalid from Site CAS for replication group: Hardware_Inventory_8
7E+16	02:31.4	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Received DRS_InitRequest from Site CAS for replication group: Hardware_Inventory_8
7E+16	03:08.4	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Creating init package for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:04
7E+16	03:08.4	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION_ CONFIGURATION _MONITOR	INFO: Flushing DRS queue messages coming from subscriber CAS for replication group Hardware_Inventory_8. -- 10/20/2012 02:03:04
7E+16	03:08.4	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	INFO: Turned off DRS queue ConfigMgrDRSSiteQueue on publisher PR1. -- 10/20/2012 02:03:04
7E+16	03:08.4	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	INFO: Turned on DRS queue ConfigMgrDRSSiteQueue on publisher PR1 . -- 10/20/2012 02:03:07
7E+16	03:08.4	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	INFO: Init package XML CreateTime: 20-10-2012 09:02:31 LastModifyTime: 20-10-2012 09:02:31 for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_ REPLICATION_ CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	INFO: Created version file for init package for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	INFO: Created tracking GUID file for init package for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	INFO: Created pub file for init package for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table AUTOSTART_SOFTWARE_DATA. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table AUTOSTART_SOFTWARE_DATA is 0. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table AUTOSTART_SOFTWARE_HIST. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table AUTOSTART_SOFTWARE_HIST is 0. -- 10/20/2012 02:03:07
7E+16	03:08.5	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table BROWSER_HELPER_OBJECT_DATA. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table BROWSER_HELPER_OBJECT_DATA is 0. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table BROWSER_HELPER_OBJECT_HIST. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION_ MONITOR	BCP out result for table BROWSER_HELPER_OBJECT_HIST is 0. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table SW_LICENSING_PRODUCT_DATA. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table SW_LICENSING_PRODUCT_DATA is 0. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table SW_LICENSING_PRODUCT_HIST. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table SW_LICENSING_PRODUCT_HIST is 0. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table SW_LICENSING_SERVICE_DATA. -- 10/20/2012 02:03:07
7E+16	03:08.6	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table SW_LICENSING_SERVICE_DATA is 0. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table SW_LICENSING_SERVICE_HIST. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table SW_LICENSING_SERVICE_HIST is 0. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table USB_DEVICE_DATA. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table USB_DEVICE_DATA is 0. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Calling BCP out for table USB_DEVICE_HIST. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	BCP out result for table USB_DEVICE_HIST is 0. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION_ MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Sending the init package for replication group Hardware_Inventory_8 to subscriber CAS. -- 10/20/2012 02:03:08
7E+16	03:08.7	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Send result for init package for replication group Hardware_Inventory_8 to subscriber CAS is 0. -- 10/20/2012 02:03:08
7E+16	03:08.8	SMS_REPLICATION _CONFIGURATION _MONITOR	CMLABPRI	SMS_REPLICATION _CONFIGURATION _MONITOR	Init package created and sent for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:08

Once the BCP out is completed the compression will happen and file will be stored in the CABFiles folder as shown below

The rcmctrl.log will have the following

Calling drs_init_send method now with parameters C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194 and CAS. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

Starting to compress files under folder [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194\] to [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\CabFiles\CAS_4C7EB459-2631-455B-93C1-8C08926BAD07.cab] ... SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

Deleting all files under folder [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\a4ba357d-1cb4-408c-9e89-681686974194]. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

Created minijob to send compressed copy of DRS INIT BCP Package to site CAS. Tranfer root = C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\CabFiles\CAS_4C7EB459-2631-455B-93C1-8C08926BAD07.cab. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

drs_init_send returned 0. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

STATMSG: ID=7803 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_REPLICATION_CONFIGURATION_MONITOR" SYS=CMLABPRI.CMLAB.COM SITE=PR1 PID=5060 TID=3364 GMTDATE=Sat Oct 20 09:03:08.373 2012 ISTR0="Hardware_Inventory_8" ISTR1="CAS" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

Current status is PackageCreated. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

Found 1 replication roles. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:08 3364 (0x0D24)

Now once this is done the sender will send the files to the CAS server.

Sender.log

=======

Passed the xmit file test, use the existing connection SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Package file = C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\CabFiles\CAS_4C7EB459-2631-455B-93C1-8C08926BAD07.cab SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Instruction file = C:\Program Files\Microsoft Configuration Manager\inboxes\schedule.box\tosend\00000085.I59 SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Checking for remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.PCK SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Checking for remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.SNI SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Checking for remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.TMP SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Attempt to create/open the remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.PCK SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Created/opened the remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.PCK SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Attempt to create/open the remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.PCK SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Created/opened the remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.PCK SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Sending Started [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\CabFiles\CAS_4C7EB459-2631-455B-93C1-8C08926BAD07.cab] SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Attempt to write 1024 bytes to \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.PCK at position 0 SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

……………………….

S.CMLAB.COM\SMS_SITE\1003PPR1.TMP SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Created/opened the remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.TMP SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Sending Started [C:\Program Files\Microsoft Configuration Manager\inboxes\schedule.box\tosend\00000085.I59] SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Attempt to write 650 bytes to \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.TMP at position 0 SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Wrote 650 bytes to \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.TMP at position 0 SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Sending completed [C:\Program Files\Microsoft Configuration Manager\inboxes\schedule.box\tosend\00000085.I59] SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Renaming remote file \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.TMP to \\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.SNI SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Rename completed [\\CMLABCAS.CMLAB.COM\SMS_SITE\1003PPR1.TMP] SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

Sending completed successfully SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

COutbox::TakeNextToSend(pszSiteCode) SMS_LAN_SENDER 20-10-2012 02:03:33 5012 (0x1394)

We have 0 active connections SMS_LAN_SENDER 20-10-2012 02:03:38 4784 (0x12B0)

Checking for sending capacity. Used 0 out of 5. SMS_LAN_SENDER 20-10-2012 02:03:38 4784 (0x12B0)

Connecting to C:\Program Files\Microsoft Configuration Manager\inboxes\schedule.box\outboxes\LAN. SMS_LAN_SENDER 20-10-2012 02:03:38 4784 (0x12B0)

COutbox::TakeNextToSend(pszSiteCode) SMS_LAN_SENDER 20-10-2012 02:03:38 4784 (0x12B0)

No (more) send requests found to process. SMS_LAN_SENDER 20-10-2012 02:03:38 4784 (0x12B0)

Waiting for new/rescheduled send requests, Maximum Sleep Time = 60 minutes SMS_LAN_SENDER 20-10-2012 02:03:38 4784 (0x12B0)

One the database logs you will find the following

LogLine	LogTime	ComponentName	MachineName	ProcedureName	LogText
7.20576E+16	03:08.7	SMS_REPLICATION_ CONFIGURATION_ MONITOR	CMLABPRI	SMS_REPLICATION_ CONFIGURATION_ MONITOR	Sending the init package for replication group Hardware_Inventory_8 to subscriber CAS. -- 10/20/2012 02:03:08
7.20576E+16	03:08.7	SMS_REPLICATION_ CONFIGURATION_ MONITOR	CMLABPRI	SMS_REPLICATION_ CONFIGURATION_ MONITOR	Send result for init package for replication group Hardware_Inventory_8 t o subscriber CAS is 0. -- 10/20/2012 02:03:08
7.20576E+16	03:08.8	SMS_REPLICATION_ CONFIGURATION_ MONITOR	CMLABPRI	SMS_REPLICATION_C ONFIGURATION_ MONITOR	Init package created and sent for replication group Hardware_Inventory_8 for site CAS. -- 10/20/2012 02:03:08

Now once the CAS receives the files the despooler will start pressing the files inside RCM.box\<GUID> just like it created in Primary. The despooler.log will show you the same

Despoolr.log

=========

Waiting for ready instruction file.... SMS_DESPOOLER 20-10-2012 02:03:38 3972 (0x0F84)

Decompressed C:\Program Files\Microsoft Configuration Manager\inboxes\despoolr.box\receive\ds_fl24a.pkg to C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\DBAF3A0C-9FE0-4A93-B771-E2DD3784E755\ SMS_DESPOOLER 20-10-2012 02:03:38 3376 (0x0D30)

Despooler successfully executed one instruction. SMS_DESPOOLER 20-10-2012 02:03:38 3376 (0x0D30)

Once it is decompressed the RCM will start processing . It will compare and see the tracking GUID and if publication matches and then will delete the old data BCP in (Bulk copy)the values after verifying with the rowcount files .

RCMctrl.log

===========

Processing replication group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Current status is PackageCreated. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Checking if initialization request is needed for replication group Hardware_Inventory_8 from site PR1. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Checking if there are bcp file to apply for replication group Hardware_Inventory_8 from site PR1. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

found a tracking guid, searching through .init files. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Checking bcpDirectory C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\DBAF3A0C-9FE0-4A93-B771-E2DD3784E755 SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Found files for publication Hardware_Inventory_8-PR1. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Publication names match. Checking vesrion. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Found our tracking guid SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Setting deadlock priority level to high. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Initializing to version number 781708. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Publication Hardware_Inventory_8 has ID 30. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Flushing DRS queue messages coming from PR1 for replication group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:41 1820 (0x071C)

Executing pre-snapshot stored procedures for group Hardware_Inventory_8. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:42 1820 (0x071C)

Pre-snapshot stored procedures for group Hardware_Inventory_8 finished. Applying bcp files. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:42 1820 (0x071C)

Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'AUTOSTART_SOFTWARE_DATA', 1;] SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:42 1820 (0x071C)

Rowcount from file [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\DBAF3A0C-9FE0-4A93-B771-E2DD3784E755\AUTOSTART_SOFTWARE_DATA.bcp.rowcount] is [6]. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:42 1820 (0x071C)

Successfully bulk copied file [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\DBAF3A0C-9FE0-4A93-B771-E2DD3784E755\AUTOSTART_SOFTWARE_DATA.bcp] into table [AUTOSTART_SOFTWARE_DATA] with rows [6]. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:43 1820 (0x071C)

Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'AUTOSTART_SOFTWARE_HIST', 1;] SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:43 1820 (0x071C)

Rowcount from file [C:\Program Files\Microsoft Configuration Manager\inboxes\rcm.box\DBAF3A0C-9FE0-4A93-B771-E2DD3784E755\AUTOSTART_SOFTWARE_HIST.bcp.rowcount] is [0]. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:43 1820 (0x071C)

‘’’’’’’’’’’’’’’’’’’’’’’

Setting deadlock priority level to normal. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:45 1820 (0x071C)

Current status is Active. SMS_REPLICATION_CONFIGURATION_MONITOR 20-10-2012 02:03:45 1820 (0x071C)

--------------

In the database logs also you will find this

LogLine	LogTime	ComponentName	MachineName	ProcedureName	LogText
429511	02:31.4	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Received DRS_InitRequestReceived for replication group: Hardware_Inventory_8
429512	02:32.8	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	INFO: Creating initialization request for 10 articles in replication group Hardware_Inventory_8 from site PR1. -- 10/20/2012 02:02:27
429513	02:32.8	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Built the init request XML for replication group Hardware_Inventory_8 for site PR1. -- 10/20/2012 02:02:31
429514	03:08.3	Microsoft SQL Server Service Broker Activation		spRCMActivation	INFO: Received DRS_InitPackageCreated for replication group: Hardware_Inventory_8
429516	03:45.0	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Applying the BCP for replication group Hardware_Inventory_8 from site PR1. Tracking guid d74dc244-a526-4387-86b0-efacf67df680. -- 10/20/2012 02:03:41
429517	03:45.0	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	BCP version number for replication group Hardware_Inventory_8 from site PR1 is 781708. -- 10/20/2012 02:03:41
429518	03:45.0	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Flushing DRS queue messages coming from site PR1 for replication group Hardware_Inventory_8.-- 10/20/2012 02:03:41
429519	03:45.1	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Executing pre-snapshot stored procedures for replication group Hardware_Inventory_8. -- 10/20/2012 02:03:42
429520	03:45.1	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Pre-snapshot stored procedures for replication group Hardware_Inventory_8 finished. Applying bcp files. -- 10/20/2012 02:03:42
429521	03:45.1	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Disable foreign keys for replication group Hardware_Inventory_8. -- 10/20/2012 02:03:42
429522	03:45.1	SMS_REPLICATION_C ONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table .. . [EXEC spSMSTruncatePartitionTable 'AUTOSTART_SOFTWARE_DATA', 1;] -- 10/20/2012 02:03:42
429523	03:45.1	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'AUTOSTART_SOFTWARE_HIST', 1;] -- 10/20/2012 02:03:43
429524	03:45.1	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'BROWSER_HELPER_OBJECT_DATA', 1;] -- 10/20/2012 02:03:43
429525	03:45.1	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'BROWSER_HELPER_OBJECT_HIST', 1;] -- 10/20/2012 02:03:43
429526	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'SW_LICENSING_PRODUCT_DATA', 1;] -- 10/20/2012 02:03:43
429527	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable ' SW_LICENSING_PRODUCT_HIST', 1;] -- 10/20/2012 02:03:43
429528	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'SW_LICENSING_SERVICE_DATA', 1;] -- 10/20/2012 02:03:43
429529	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_C ONFIGURATION_MONITOR	Removing old data for site table . .. [EXEC spSMSTruncatePartitionTable 'SW_LICENSING_SERVICE_HIST', 1;] -- 10/20/2012 02:03:44
429530	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table .. . [EXEC spSMSTruncatePartitionTable 'USB_DEVICE_DATA', 1;] -- 10/20/2012 02:03:44
429531	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Removing old data for site table ... [EXEC spSMSTruncatePartitionTable 'USB_DEVICE_HIST', 1;] -- 10/20/2012 02:03:44
429532	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Applied the BCP files for replication group Hardware_Inventory_8 from site PR1. -- 10/20/2012 02:03:44
429533	03:45.2	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Enable foreign keys for replication group Hardware_Inventory_8. -- 10/20/2012 02:03:44
429534	03:45.3	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Restore table's identity value for replication group Hardware_Inventory_8. -- 10/20/2012 02:03:44
429535	03:45.3	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Executing post-snapshot stored procedures for replication group Hardware_Inventory_8. -- 10/20/2012 02:03:44
429536	03:45.3	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Post-snapshot stored procedures for replication group Hardware_Inventory_8 finished. -- 10/20/2012 02:03:44
429537	03:45.3	SMS_REPLICATION_ CONFIGURATION_MONITOR	CMLABCAS	SMS_REPLICATION_ CONFIGURATION_MONITOR	Finished applying the BCP for replication group Hardware_Inventory_8 from site PR1. -- 10/20/2012 02:03:45

Once the same is completed then on the primary server you will find the replication is finished.

LogLine

LogTime

ComponentName

MachineName

ProcedureName

LogText

7.20576E+16

03:44.8

Microsoft SQL Server

Service Broker Activation

spRCMActivation

INFO: Received DRS_InitFinished from

Site CAS for replication group:

Hardware_Inventory_8 with Version 135769

Once the same happens you will see the link moving from initialization to active in the monitoring phase.

Sudheesh Narayanaswamy

Support Escalation Engineer

Microsoft System Center Support

How to install SCUP and configure

2012-01-05T06:54:34Z

How to install SCUP and configure

This will show the steps on how to install SCUP and also configure a third party catalogue, (EH Adobe Flash player) and deploy the clients reporting to SCCM server.

You can download the SCUP from the following link http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0446cce9-94a4-4fb0-b335-e7516044063d&displaylang=en

On the SCCM server or on any other server you can install System Center Updates Publisher.

The perquisite is to have SQL server. You can use the express installation or use any other SQL server.

Updates Publisher is supported on the following operating systems:

· The Microsoft Windows® XP Professional operating system with Service Pack 2 (SP2)
· The Microsoft Windows® XP Professional x64 Edition operating system
· The 32-bit versions of the Microsoft Windows Server®°2003 operating systems with Service Pack 1 (SP1)
· The x64-based editions of the Microsoft Windows Server®°2003 operating systems
· The 32-bit versions of the Microsoft Windows Server®°2003 R2 operating systems
· The x64-based editions of the Microsoft Windows Server®°2003 R2 operating systems
· The Windows Vista™ operating systems
· The x64-based editions of the Windows Vista™ x64 Edition operating systems

Software Requirements

· Updates Publisher has the following software requirements:
· Microsoft Management Console 3.0 (MMC). MMC 3.0 must be installed prior to running the Updates Publisher Setup. You can download the MMC 3.0 from the Microsoft Download Center Web site (http://go.microsoft.com/fwlink/?linkid=21788).
· For Updates Publisher 4.5, WSUS 3.0 SP2SP1 Administration Console. If WSUS 3.0 SP2 is not already installed on the local computer, the WSUS 3.0 SP2 Administration Console must be installed prior to running the Updates Publisher Setup. You can download the WSUS 3.0 SP2 Administration Console from the Windows Server Update Services Web site
· Microsoft Internet Explorer 6 SP1 or later. A supported version of Internet Explorer must be installed prior to running the Updates Publisher Setup. You can download Internet Explorer 6 SP1 from the Microsoft Download Center Web site (http://go.microsoft.com/fwlink/?linkid=21788).
· Microsoft Windows Installer 3.1. The Updates Publisher Setup installs Windows Installer 3.1, if required.
· Microsoft .NET Framework 2.0. The Updates Publisher Setup installs .NET Framework 2.0, if required.
· Microsoft SQL Server 2005 SP1 or Microsoft SQL Server 2005 Express Edition SP2. The Updates Publisher Setup installs SQL Server 2005 Express Edition SP2, if required.

How to install SCUP

Double click the SystemCenterUpdatesPublisher45.exe.

Click next and it will ask to select local database or install SQL express edition. DO the same

Once clicked next it will install the perquisite and then will proceed the installation

Select The folder

Installation will proceed and will complete the installation

Once done complete the installation click on finish.

How to configure SCUP

Once the installation is over open the console of SCUP.

Click on import updates from the right side. You can download the adobe flash player catalogue from the following link http://fpdownload.adobe.com/get/flashplayer/current/licensing/win/AdobeFlashPlayerCatalog_SCUP.cab

Click on Single Catalogue Import

Point to the CAB file downloaded.

IT will then start uploading

Click on Accept

Once you have completed this you will find adobe flash player as shown below.

Now the set the Publish flag. On the Adobe flash player select settings and then do the following configuration. Select the update server if locally installed the same one or you can select the remote in case you install SCUP.

First, you have to configure SCUP to sign patches with the WSSC. To do that, select the settings option from the console screen

On the Update Server tab, select create to create the WSSC

Once complete, you should have a new WSSC as shown

This action creates the WSSC in the WSUS > Certificates note of the Certificates.msc as shown

So the certificate we need is now created, but we aren’t ready to go yet. Next we have to make sure the WSSC cert is included in the Trusted Publishers > Certificates and the Trusted Root Certificate Authorities > Certificates store.Simple process to export the cert and import it to the other two stores. To export the cert, just right click on it and select to export – take all the defaults and save the cert to a .cer file. To import, just right click on the Trusted Publishers and Trusted Root Certificate Authorities nodes, respectively, and select to import and point to the file.

One this is completed On the SCUP console please do the following. Click on Publish updates

Click on Accept

Once successfully published run the Synchronization in the SCCM server

Once the synchronization is completed the security update you would see the adobe flash layer

Now on the SCCM server Download the update and then create a deployment

Select the DP

Create a Deployment

Now on the clients do the following settings

So now SCUP should be configured to sign updates with the WSSC and publish updates to the SCCM Software Update point and you can deploy them to clients. But, the clients aren’t ready to receive them and will reject the update if it arrives. To get the client ready to receive updates you need to transfer the WSSC to the clients certificate store as well. You can do this manually or even through software distribution using the certutil command.

To deploy the certificate with software distribution, do the following.

Export the WSUS Publishers Self-signed certificate and public key to a directory on the local computer.
Copy the Certutil.exe and Certadm.dll files to the same directory as the exported files. Certutil.exe is a command-line program that is installed as part of Certificate Services in the Windows Server 2003 family and both files are installed in %windir%\system32, by default.
Create a software distribution package containing the files from step 1 and step 2. For more information, see How to Create a Package (http://go.microsoft.com/fwlink/?LinkId=108444)
Add a software distribution program that runs the following command-line: certutil.exe -addstore TrustedPublisher wsus.cer, where TrustedPublisher is the name of the certificate store and wsus.cer is the name of the exported certificate. For more information about creating a software distribution program, see How to Create a Program (http://go.microsoft.com/fwlink/?LinkId=108446). For more information about certutil.exe, see the Certutil Web site on TechNet (http://go.microsoft.com/fwlink/?LinkId=108447)
Create an advertisement for distributing the package and program to the appropriate collection. For more information, see How to Create an Advertisement (http://go.microsoft.com/fwlink/?LinkId=108449).

You may also have to include the WSSC in the Trusted Root Certificate Authorities node as well, which can be done with easy adjustments to the package if needed. Be sure and test first to determine exactly what is needed for your environment.

Once you have the certificates deployed, now you just have to adjust local policy to allow signed cupdates from an intranet Microsoft update service location. You can find that setting as shown below.

To test that everything is working, deploy a SCUP patch to a test client and review the WUAHandler.log. If all is configured properly, you should see the patch install if needed. If there are problems you will notice errors similar to the following in the log.

In the server the updatepublisher.log in %temp% on the SCUP installed machine also help to check the error.

Hope this information would be useful

Sudheesh Narayanaswamy

GUI Tool to Manually Exchange Public Keys Between Sites

2012-01-03T05:38:00Z

GUI Tool to Exchange Public Keys Between Sites

I had feedback from few of the customers and colleagues of mine that the process of manually exchange of keys as per this link http://technet.microsoft.com/en-us/library/bb693690.aspx
takes time and confusing because of similar steps. So for the same I had made a GUI tool which does this works.

Once you extract the content to a same folder in central server or parent server and run the preinstUI.exe you will get a UI as shown below and you can select the Parent site and the child site.

Once you click on Exchange, the GUI vanishes and you will be asked if you really want to proceed with the exchange and if pressed yes it does the exchange. After the exchange the GUI again pops up.

The steps are logged in the <InstallationLocation>\bin\i386\<languageCode>\preinst.log on the server from you are running and would like this.

Note: Please read the readme.txt before using this tool. And as usual, Microsoft makes no warranties or guarantee's regarding the applicability of this utility nor does Microsoft support the use of this tool in any way.This is just one of those 'use at your own risk' type of things that hopefully you'll find helpful

if you have any feedback or questions on this you can write to me and depending up on the time avilabilty I will check if I could help you here.

Download the exe and required files from the link below

Thanks

Sudheesh Narayanaswamy

Administartive Checklist for Configuration Manager 2007

2011-06-08T10:26:00Z

Many have been asking for what i need to check to make sure SCCM is healthy. According to me if I were you these are things I would have checked :)

This might not be complete but had tried to include what ever I could think of.

Administrative Activities:

Daily Administrative Task

Daily Site Monitoring Tasks

To best maintain your system, perform the following monitoring tasks on a daily basis. If there is any indication of a problem, isolate and repair the problem to ensure that the site remains healthy.

Daily site monitoring tasks include:

Checking SCCM site database status.
Checking site server status.
Checking site systems status.
Checking client status.
Checking the operating system event log.
Checking the SQL Server error log.
Checking system performance.
Checking SCCM system folders.

Check SCCM Site Database Status

Use the SQL Server DBCC command to check the health of the SCCM site database. Use any other tools available to test the health of the SCCM site database.

Check Site Server Status

View site status summary information in the SCCM Administrator console, or create reports that summarize the server activity and status (such as the Clients that Received a Specific Advertised Program report). If necessary, check status messages of individual components. For further details, in case status messages indicate that a problem exists, view the relevant log files. Isolate and fix conditions that generate errors or warnings. If appropriate, reconfigure the status system so that only relevant and helpful messages are recorded.

Check the status of items such as:

Site components and services. Check if any site server component or service is experiencing any problems.
Packages and advertisements. Check the status of packages and advertisements in your site. Check package and advertisement status messages to ensure that package source files reach distribution points, and that advertised programs reach clients. Check status messages that are returned from clients to see whether the clients run programs successfully or not.
Site-to-Site Communication. Check communication between the site and its parent and child sites (if they exist). Check status messages and, if necessary, check log files of the Replication Manager, Scheduler, and Senders on the site to determine whether the site is having communication problems.

Check Site Systems Status

Check the state of site systems throughout the SCCM hierarchy. Use the status system and, if necessary, use log files to determine if site systems are having problems, such as:

Low level of available disk space.
SCCM components that cannot connect with a site system.

Check Clients Status

Check the state of clients in the hierarchy. Run queries on status messages to detect any problems that clients might be having, such as:

Client components are experiencing problems.
Clients are failing to install.
Clients are not reporting software inventory or hardware inventory.
Clients that are not reporting heartbeat discovery data regularly (or for the past x days).
Client count unexpectedly increasing or decreasing at a fast rate.

You can monitor a client's status only if it creates status messages, and these status messages reach the site server.To detect clients from which you are missing status messages, you need to run a query that returns all clients that have not reported a status message within the last <n> days. In this query, <n> is the length of time you would expect to receive a status message from that client (taking into account the frequency of hardware or software inventory and the regular time it takes for status messages to reach the site server.)

Check the Operating System Event Log

On key servers, check the application, system, and security system event logs. You can access those through the Event Viewer administrative tool. Look for messages that indicate error conditions or developing problems. Isolate and repair the conditions that generate error or warning messages.

When installing an SCCM site server, its default configuration is to write status messages to the event log. This helps you identify any developing problems with SCCM.

Note :When SCCM is configured to write status messages to Windows event logs, SCCM error status messages are written as Information events, not Error events.

Save instances of the most recent event log files for future comparison. When you can compare current log files with previous log files, it is easier to detect problems that are developing. After saving the log files, you can clear them from the event log so it is easier to detect new problems.

Check the SQL Server Error Log

Check the SQL Server error log in SQL Enterprise Manager. Look for messages that indicate error conditions. Isolate and repair the conditions that generate error or warning messages.

Check System Performance

To check whether the site server and component servers have sufficient resources and that SCCM site services are running optimally, you must monitor site server and component server performance. Use performance-monitoring tools such as System Monitor in the Performance console. Check the status of critical components on the site server, on the computer running SQL Server, and other SCCM site systems.

SCCM installs many performance monitor counters, but you can add, remove and configure counters as needed. You can also use the SQL Server performance counters.

Save performance log files for future comparison. It is easier to detect performance trends, and to identify potential bottlenecks, when comparing current performance log file to previous performance log files.

Check Status Filter Rules

Check whether it is possible to reduce the amount of traffic generated by status messages being replicated throughout the hierarchy. If the site is currently healthy, it might be possible to add status filter rules to prevent replication of status messages, which are not necessary.

Check the Inboxes to Monitor

Listed here is a list of the ConfigMgr 2007 inboxes that should be checked on a regular basis to ensure that your site(s) function as expected.
Auth\Dataldr.Box : A backlog of files can indicate problems accessing the site database.
Auth\Dataldr.Box\Process :A backlog of files can indicate problems accessing the site database.

Auth\Ddm.box\Bad_DDRs :A backlog of files can indicate a network corruption problem or a problem with the DDM
Auth\Sinv.Box :A backlog of files can indicate that the Software Inventory Processor cannot connect to the site database or that too many files were received.
Auth\Sinv.Box\Orphans :A backlog of files can indicate problems with specific clients, with management points, or with the network that could cause data corruption.
Compsumm.Box : A backlog of files can indicate that the Component Status Summarizer cannot process the volume of messages.
Dataldr.Box :A backlog of files can indicate problems accessing the Systems Management Server (SCCM) database
Dataldr.Box\Badmifs :A backlog of files can indicate a bad custom MIF file or that a client computer cannot transfer the file correctly.
Ddm.Box :A backlog of files can indicate a bad DDR is preventing other DDR’s to process.
Ddm.Box\Bad_DDRs :A backlog of files can indicate a network corruption problem or a problem with the DDM
OfferSum.Box : A backlog of files can indicate a performance problem that is caused by a large number of messages.
Policypv.Box :A backlog of files in the policypv.box folder indicates that the policy provider component is not running.
Replmgr.Box\Ready:A backlog of files can indicate that the Scheduler is backlogged or is already processing files of the same priority
Schedule.Box:A backlog of files can indicate that the Sender cannot connect to or cannot transfer data to another site.
Schedule.Box\Outboxes :A backlog of .srq files indicates that the sender cannot process the number of jobs scheduled for that sender or that the sender cannot connect to or transfer data to another site.
Schedule.Box\Tosend :A backlog of files can indicate that many send requests are not completed or that the Scheduler has not yet deleted the files.
Sinv.Box :A backlog of files can indicate that the Software Inventory Processor cannot connect to the site database or that too many files were received.
Sinv.Box\BadSinv :A backlog of files can indicate problems with specific clients, with management points, or with the network, causing data corruption.

SiteStat.Box :A backlog of files can indicate a performance problem. Examine status messages for the Site System Status Summarizer for possible problems.
Statmgr.Box\Futureq :A backlog of files can indicate that some site systems' clocks are not synchronized with the site server.
Statmgr.Box\Queue :A backlog of files can indicate a problem with the Status Manager or that the component is trying to process too many messages.
Statmgr.Box\Retry :A backlog of files can indicate problems with the connection to the computer that is running SQL Server.
Statmgr.Box\Statmsgs :A backlog of files can indicate a problem with the Status Manager or that the Status Manager is trying to process too many messages
Swmproc.Box :A backlog of .sum and .sur files can indicate that the Software Metering Processor component cannot connect to the SCCM database.

Check Daily Maintenance Task

Check and make sure that the daily Maintenance Task if any. We can use the smsdbmon.log for more details.

Weekly Administrative Task

Weekly Site Monitoring Tasks

To best maintain your system, perform the following monitoring tasks on a weekly basis. If there is any indication of a problem, isolate and repair the problem, to ensure that the site remains healthy.

Weekly site monitoring tasks include:

Checking SCCM site database available space.
Checking available disk space.

Check SCCM Site Database Available Space

To find the amount of space used by database devices, run the SQL Server stored procedure sp_spaceused against the SCCM site database. For more details about sp_spaceused, see the SQL Server Help. Check the tempdb device at peak usage, when several instances of the SCCM Administrator console are using the database and the site is actively processing objects.

Check Available Disk Space

Check the amount of available disk space on the site server, the SCCM site database server, and other SCCM servers. Ensure that the amount of free disk space is sufficient for SCCM and SQL Server to perform properly during regular and increased activity load.

To use the Status System to view information about site system disk space

In the SCCM Administrator console, navigate to Site System Status.

Configuration Manager > Site Database > System Status> Site Status> <site name>> Site System Status

In the details pane, view status information of site systems such as free disk space.

Weekly Site Maintenance Tasks

To best maintain your system, perform the maintenance tasks in this section on a weekly basis. You can automate some tasks by scheduling predefined maintenance tasks or custom maintenance tasks, as appropriate, to run on a weekly basis.

Weekly site maintenance tasks are:

Weekly automated tasks.
Delete unnecessary files.
Delete unnecessary SCCM objects.
Produce and distribute end-user reports.
Run disk defragmentation tools.
Back up application, security, and system event logs.

Weekly Automated Tasks

The following predefined maintenance tasks should be scheduled to run on a weekly basis. For more information about these tasks, see the "Predefined Site Maintenance Tasks" section earlier in this chapter.

Rebuilding Indexes
Monitor keys
Delete aged inventory history
Delete aged discovery data
Delete aged collected files
Delete aged software metering data
Delete aged software metering summary data
Summarize software metering data
Summarize software metering periodic usage data

Delete Unnecessary Files

If Management Information Format (MIF) files or IDMIFs are used to extend hardware inventory in your site, then any MIF files that are not valid are placed in the SCCM\inboxes\dataldr.box\BADMIFS folder and SCCM never removes them. You must empty this folder manually. If a large number of MIFs are placed in the BADMIFS folder, it is likely that a MIF generating tool is producing the MIFs with an incorrect format. Investigate and repair the cause of the bad MIFs.

Delete Unnecessary SCCM Objects

Delete objects such as collections, queries, and packages that are no longer needed at the site. Deleting unnecessary objects saves disk space, reduces intersite replications, and increases performance.

Caution :When deleting a collection, any advertisements to that collection are also deleted.

Run Disk Defragmentation Tools

Over time, disk volumes on SCCM site systems become fragmented. Site operations such as distributing large software packages might significantly increase fragmentation on site servers and distribution points. As fragmentation increases, disk operations take longer, thus, the overall site performance decreases.

Run disk defragmentation tools on the SCCM site server and all other site systems to maintain the performance level of disk operations.

Back Up Application, Security, and System Event Logs

Windows event logs can get full, and by default, new items will start to overwrite older items. To diagnose problems, and for other reasons, it might be necessary to refer to an older event log. It is recommended that you back up Windows event logs, and store the backups in a safe and accessible location. If necessary, increase default logs file size to accommodate larger amounts of data.

Periodic Administrative Task

Periodic Site Maintenance Tasks

To best maintain your system, perform the following tasks periodically. Use the predefined maintenance tasks when appropriate.

Periodic site maintenance tasks include:

Backing up account data.
Changing accounts and passwords.
Checking network performance.
Reviewing the security plan.
Reviewing the maintenance plan.
Performing recovery tests.

Back Up Account Data

To properly recover a site server, you must have information about the accounts that SCCM used before the site failed. Account data is stored in domain controllers.

Use Microsoft tools, such as the NTBackup.exe tool that comes with Windows Server, or third-party tools to back up account data as follows:

If there are multiple domain controllers in your infrastructure that contain the SCCM account database, you need to periodically back up the account database. (If Active Directory® directory service is implemented in your organization, then such a task might be included in the Active Directory maintenance plan.)
If the account database is stored on a single domain controller, then back up the account database frequently. Depending on the frequency of changes to account data, you might need to add this task to the site's daily or weekly maintenance tasks.
If the account data is stored on member servers, then regularly back up the whole operating system that contains the account data, using software that backs up account lists and the account database.
Whenever there is a change to the password of the Client Push Installation account or to the site system connection accounts, you should note that change. For security reasons, SCCM encrypts the Client Push Installation account and the site system connection accounts. You need to be able to retrieve these accounts' passwords so that you can re-enter them during a site recovery operation.
In between account database backups, document any changes to accounts. Write down and save any changes made to SCCM accounts and share rights so that you can apply those changes again after recovering the site.

Change Accounts and Passwords

To maintain the level of security in your hierarchy, you must periodically change the passwords and the accounts that SCCM sites use. Report any changes to the security staff so that security administrators know that these changes are planned and authorized.

To develop an effective security maintenance plan for your SCCM hierarchy, you must thoroughly understand how security is deployed in your hierarchy and make the following decisions:

Which accounts need to be changed, and for which accounts is it sufficient to change only the password.
How often to change passwords and accounts.
How to change passwords and accounts (such as by running SCCM site reset).
Which accounts cannot be configured by the administrator (either the account name cannot be changed, or the password cannot be manually modified).

Check Network Performance

Check the available bandwidth and error rates on the networks used by the SCCM hierarchy. Use Network Monitor to capture and analyze network frames so you can diagnose network problems and look for optimization opportunities.

Review the Security Plan

SCCM evolves with time. User roles change, and people might no longer need access to some or any of the SCCM functions. Although most changes in access permission should be implemented after role or staff changes, you should also periodically review the access for all users or groups to identify and delete unauthorized access permissions.

The security plan implemented for the SCCM hierarchy in your organization needs to support the risk assessment of your organization. As your organization changes, policies can become ineffective.

Review security-related settings such as:

Who has access to SQL Server and to the SCCM site database.
Who can download from SCCM distribution points.
Which accounts have permissions within SCCM security.
Periodically, re-evaluate the risk assessment of your organization, and then review and update the security plan accordingly.

Review the Maintenance Plan

Use the maintenance plan document to review the SCCM maintenance plan. SCCM evolves with time, and it might be necessary to adjust the maintenance plan to accommodate growth, development, and other changes in your organization.

If there were any changes in your organization's security strategy, backup and recovery strategy, or any other strategy that affects SCCM, then determine if the maintenance plan needs to be adjusted to reflect these changes.

Review maintenance tasks configuration. Check the amount of data in the site database and evaluate the usefulness of that data against the amount of space that it occupies in the database. If necessary, adjust the settings that determine the number of days that data is retained in the database.

Update the maintenance plan document to reflect any changes to the maintenance plan, and then distribute it to all SCCM administrators that are using it.

Perform Recovery Tests in a Test Lab

The best way to be fully prepared for a site recovery operation is to ensure that the recovery plan is adequate and that administrators are familiar with the recovery process. After you develop a recovery plan for your site, it is recommended that you perform periodic recovery tests in a test lab.

A recovery test should follow the recovery plan developed for the production environment. Plan to perform a recovery test of the central site, and of any other systems deployed in your hierarchy. A recovery test should test all phases of recovery, including:

Backing up a site.
Archiving the backup snapshot.
Simulating a site failure, such as by turning a server off.
Recovering the failed site.
Verifying the success of the recovery operation.
You might schedule periodic recovery tests. Company policy might require that new administrators always perform a recovery test. It is strongly recommended that you always include a recovery test when testing major changes to the hierarchy.
For example, before upgrading site server operating systems, you should probably first test the upgrade in the test lab. After completing the upgrade in the test lab, you should perform a recovery test to identify any issues or adjustments to the recovery plan associated with the operating system upgrade. This ensures that if you upgrade the servers in the production environment, you will still be able to successfully recover a failed site.
Include a recovery test in every major deployment test, such as:
A major operating system upgrade (not service pack).
A major change to the networking infrastructure.
New equipment deployment or building relocation.
An SCCM major version site upgrade.

Periodic Site Monitoring Tasks

To best maintain your system, perform the following monitoring tasks periodically. If there is any indication of a problem, isolate and repair the problem to ensure that the site remains healthy.

Periodic site monitoring tasks include:

Checking hardware.
Checking site's overall health.
Checking the backup snapshot.

Check Hardware

Even high-quality hardware occasionally fails. Sometimes, it fails gradually, so there might be early signs. Replacing hardware before it completely fails is a key step in preventing site failure. Both Windows and SCCM provide performance counters, which you can use to monitor the performance and state of the hardware used in the site.

As soon as you notice any signs of hardware-related unreliable behavior of an SCCM server, replace the hardware. To properly replace server hardware, you must use the Recovery Expert. For more information about swapping the computer of SCCM servers, see the "Swapping the Computer of a Site Server" section later in this chapter.

Check Site's Overall Health

It is recommended that you periodically perform a more thorough health check, as follows:

Ensure that all SCCM services are running.
Review the Status Message System for Critical status.
Ensure that all the latest service packs are installed.
Ensure that the latest critical security patches are installed.
Examine the System and Application Event logs for errors.
Note
- When SCCM is configured to write status messages to the system's event log, SCCM error status messages are written as information events, not error events.
Run a query to determine if discovery data is being updated correctly in the SCCM site database. The query should list all installed clients in which System Resource - Agent Time is not within the heartbeat interval. It is expected that some clients might be offline, but in other cases, it might indicate a problem.
Run a query to determine if software inventory data is being updated correctly in the SCCM site database. The query should list all installed clients in which Last Software Scan - Last Inventory Collection is not within the software inventory interval. It is expected that some clients might be offline, but in other cases, it might indicate a problem.
Run a query to determine if hardware inventory data is being updated correctly in the SCCM site database. The query should list all installed clients in which Workstation Status - Last Hardware Scan is not within the hardware inventory interval. It is expected that some clients might be offline, but in other cases, it might indicate a problem.

If any of these tests fail, you need to diagnose the problem and repair it.

Check the Backup Snapshot

At the end of every site backup cycle you should check the validity of the backup snapshot. Periodically, you should perform a more thorough check to ensure that the site's backup snapshots can be successfully used for recovery.

Restore a recent backup snapshot to a disk and examine file continuity, file size, and other file properties to ensure that they do not seem corrupted. Check critical files by restoring these files to their respective applications to ensure that the application can use the restored file.

Audit Collector Filter GUI version (V1) of ADTADMIN.exe

2011-02-05T16:18:00Z

Audit Collector in Operations Manager 2007 is one of the most frequently used. When I was supporting the SCOM and ACS, the challenge many of customers informed me was that applying filter query using adtadmin tool. This is more important to make sure that unnecessary data is not inserted to the ACS database and that the ACS database is within the manageable size limits.

You can get more details from this link on the Adtadmin tool.

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

This tool designed by me is a GUI tool which uses adtadmin tool behind but will make the user level experience better. This will work with the following condition.

· This tool is supposed to run only on ACS collector system

· This is not for complex quires.

· This tool can be run with a user having administrator rights

· With System with UAC enabled you need to use Run as Administrator to the tool.

I have tested this with Windows Server 2003 and Windows Server 2008 but keep in mind that this is not an official Microsoft tool and just something that I created for my own personal use. As such, Microsoft makes no warranties or guarantee's regarding the applicability of this utility, nor does Microsoft support the use of this tool in any way. This is just one of those 'use at your own risk' type of things that hopefully you'll find helpful

If you have any question please let me know.

Hope this will be Helpful

Sudheesh N

Sudheesh.Narayanaswamy@microsoft.com

Troubleshooting SCCM Part VI ..........Software Distribution

2011-02-01T05:10:00Z

Software Distribution

The Microsoft System Center Configuration Manager 2007 software distribution feature provides a set of tools and resources that help you create and manage packages and advertisements used to distribute software to client resources within your enterprise.

For more details please check the following link

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

Troubleshooting Software Distribution

Server Side

Once you create a package then you need to check the status messages to see if the package has been created you will have the following entries

Status ID : 30000 => User "Domain\User" created a package named " Test Package " (LAB00003).
Status ID : 2301 => SMS Distribution Manager successfully processed package "Test Package" (package ID = LAB00003).

Also you will have 2300 and 2311 for starting and creation of the packages Once you add the distribution point you then have to see if the following status messages are displayed.

Status ID : 30125 User "Domain\User" added new distribution points to a package named " Test Package " (LAB00003).

Severity Type Site code Date / Time System Component Message ID Description Thread ID Process ID

Information Milestone LAB 4/26/2010 10:28:51 PM SCCM SMS_DISTRIBUTION_MANAGER 2330 SMS Distribution Manager successfully distributed package "LAB00003" to distribution point "["Display=\\SCCM\"]MSWNET:["SMS_SITE=LAB"]\\SCCM\". 4412 3040

Information Milestone LAB 4/26/2010 10:28:51 PM SCCM SMS_DISTRIBUTION_MANAGER 2329 SMS Distribution Manager copied package "LAB00003" from "C:\SOFTDUMP\" to "MSWNET:["SMS_SITE=LAB"]\\SCCM\SMSPKGC$\LAB00003\". 4412 3040

Information Milestone LAB 4/26/2010 10:28:29 PM SCCM SMS_DISTRIBUTION_MANAGER 2342 SMS Distribution Manager is starting to distribute package "Test Package" to distribution point "["Display=\\SCCM\"]MSWNET:["SMS_SITE=LAB"]\\SCCM\". 4412 3040

If you see the errors you can check the distmgr.log for the same. The distmgr.log will have the following entries

STATMSG: ID=2300 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_DISTRIBUTION_MANAGER" SYS=SCCM SITE=LAB PID=3040 TID=3276 GMTDATE=Mon Apr 26 16:59:00.772 2010 ISTR0="Test Package" ISTR1="LAB00003" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=400 AVAL0="LAB00003" SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

No action specified for the package LAB00003. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

No action specified for the package on server ["Display=\\SCCM\"]MSWNET:["SMS_SITE=LAB"]\\SCCM\. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

Updating package info for package LAB00003 SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

Package LAB00003 does not have a preferred sender. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

The package and/or program properties for package LAB00003 have not changed, need to determine which site(s) need updated package info. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

StoredPkgVersion (0) of package LAB00003. StoredPkgVersion in database is 0. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

SourceVersion (1) of package LAB00003. SourceVersion in database is 1. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:00 PM 3276 (0x0CCC)

STATMSG: ID=2301 SEV=I LEV=M SOURCE="SMS Server" COMP="SMS_DISTRIBUTION_MANAGER" SYS=SCCM SITE=LAB PID=3040 TID=3276 GMTDATE=Mon Apr 26 16:59:01.073 2010 ISTR0="Test Package" ISTR1="LAB00003" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=400 AVAL0="LAB00003" SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:01 PM 3276 (0x0CCC)

Exiting package processing thread. SMS_DISTRIBUTION_MANAGER 4/26/2010 10:29:01 PM 3276 (0x0CCC)

In case you see errors please make sure that the following

· There is no network issue between the server and the and the DP server

· Make sure that the SMSPKG<DriveLettre>$ share has been created and that has the folder with the package ID

· There is no DNS resolution issue.

· Make sure that the share has the require permission to write the data.

Once this is verified the next step is to check if the advertisement is created .These are the following status which will give you an idea on the creation

Information Milestone LAB 4/26/2010 10:44:36 PM SCCM SMS_OFFER_MANAGER 3900 SMS Offer Manager successfully processed new advertisement Test Advr.

Information Audit LAB 4/26/2010 10:44:24 PM SCCM Microsoft.ConfigurationManagement.dll 30006 User "MYLAB\Administrator" created an advertisement named "Test Advr" (LAB20000) advertising program "Test Program".

Once the advertisement is received by the client you will have the following status messages

Severity Type Site code Date / Time System Component Message ID Description

Information Milestone LAB 4/26/2010 10:44:36 PM SCCM SMS_OFFER_MANAGER 3900 SMS Offer Manager successfully processed new advertisement Test Advr.

Now on you need to check the client logs.

Client Side

Once the agent refreshes the policy according the policy refresh interval you will have the policy downloaded and evaluated.

Policyagnet.log

Download of policy CCM_Policy_Policy4.PolicyID="LAB20000-LAB00003-9785047B",PolicySource="SMS:LAB",PolicyVersion="1.00" completed (DTS Job ID: {231E2AE2-7ED2-4AA3-84F4-81CA1712217E}) PolicyAgent_PolicyDownload 4/26/2010 10:47:12 PM 1944 (0x0798)

Raising event:

instance of CCM_PolicyAgent_PolicyDownloadSucceeded

{

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

DateTime = "20100426171712.258000+000";

DownloadMethod = "BITS";

DownloadSource = "http://SCCM.MYLAB.IN/SMS_MP/.sms_pol?LAB20000-LAB00003-9785047B.1_00";

PolicyNamespace = "\\\\SQL\\ROOT\\ccm\\Policy\\Machine\\RequestedConfig";

PolicyPath = "CCM_Policy_Policy4.PolicyID=\"LAB20000-LAB00003-9785047B\",PolicySource=\"SMS:LAB\",PolicyVersion=\"1.00\"";

ProcessID = 3568;

ThreadID = 1944;

};

PolicyAgent_PolicyDownload 4/26/2010 10:47:12 PM 1944 (0x0798)

Policy Evaluvator.log

Raising event:

instance of CCM_PolicyAgent_PolicyEvaluationComplete

{

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

DateTime = "20100426171716.924000+000";

PolicyNamespace = "\\\\SQL\\ROOT\\ccm\\Policy\\Machine\\RequestedConfig";

PolicyPath = "CCM_Policy_Policy4.PolicyID=\"LAB20000-LAB00003-9785047B\",PolicySource=\"SMS:LAB\",PolicyVersion=\"1.00\"";

ProcessID = 3568;

ThreadID = 1944;

};

PolicyAgent_PolicyEvaluator 4/26/2010 10:47:16 PM 1944 (0x0798)

Policy state for [CCM_Policy_Policy4.PolicyID="LAB20000-LAB00003-9785047B",PolicyVersion="1.00",PolicySource="SMS:LAB"] is currently [Active] PolicyAgent_PolicyEvaluator 4/26/2010 10:47:16 PM 3488 (0x0DA0)

Updating settings in \\sql\root\ccm\policy\machine\actualconfig PolicyAgent_PolicyEvaluator 4/26/2010 10:47:16 PM 3488 (0x0DA0)

Raising event:

instance of CCM_PolicyAgent_SettingsEvaluationComplete

{

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

DateTime = "20100426171718.827000+000";

PolicyNamespace = "\\\\sql\\root\\ccm\\policy\\machine\\actualconfig";

ProcessID = 3568;

ThreadID = 3488;

};

PolicyAgent_PolicyEvaluator 4/26/2010 10:47:18 PM 3488 (0x0DA0)

On the execution manager you will have the following entry

Execmgr.log

Policy arrived for parent package LAB00003 program Test Program execmgr 4/26/2010 10:47:19 PM 2004 (0x07D4)

Raising event:

[SMS_CodePage(437), SMS_LocaleID(1033)]

instance of SoftDistProgramOfferReceivedEvent

{

AdvertisementId = "LAB20000";

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

DateTime = "20100426171720.299000+000";

MachineName = "SQL";

ProcessID = 3568;

SiteCode = "LAB";

ThreadID = 2004;

};

execmgr 4/26/2010 10:47:20 PM 2004 (0x07D4)

Requesting content from CAS for package LAB00003 version 1 execmgr 4/26/2010 10:47:25 PM 1944 (0x0798)

Successfully created a content request handle {80539F34-D400-4978-95F2-9D26151C9BF8} for the package LAB00003 version 1 execmgr 4/26/2010 10:47:29 PM 1944 (0x0798)

Then you will see the download in the datatransferservices.log

DatatransferServices.log

UpdateURLWithTransportSettings(): OLD URL - http://SCCM.MYLAB.IN/SMS_MP/.sms_pol?LAB20000-LAB00003-9785047B.1_00 DataTransferService 4/26/2010 10:47:06 PM 3208 (0x0C88)

UpdateURLWithTransportSettings(): NEW URL - http://SCCM.MYLAB.IN:80/SMS_MP/.sms_pol?LAB20000-LAB00003-9785047B.1_00 DataTransferService 4/26/2010 10:47:06 PM 3208 (0x0C88)

DTSJob {231E2AE2-7ED2-4AA3-84F4-81CA1712217E} created to download from 'http://SCCM.MYLAB.IN/SMS_MP/.sms_pol?LAB20000-LAB00003-9785047B.1_00' to 'C:\WINDOWS\system32\CCM\Temp\{55C3178E-C27D-4C29-AC2D-439C6E87D53D}.tmp'. DataTransferService 4/26/2010 10:47:06 PM 3208 (0x0C88)

DTSJob {231E2AE2-7ED2-4AA3-84F4-81CA1712217E} in state 'PendingDownload'. DataTransferService 4/26/2010 10:47:06 PM 1944 (0x0798)

DTS::AddTransportSecurityOptionsToBITSJob - Failed to QueryInterface for IBackgroundCopyJobHttpOptions. BITS 2.5+ may not be installed properly. DataTransferService 4/26/2010 10:47:09 PM 1944 (0x0798)

DTSJob {231E2AE2-7ED2-4AA3-84F4-81CA1712217E} in state 'DownloadingData'. DataTransferService 4/26/2010 10:47:09 PM 1944 (0x0798)

DTSJob {231E2AE2-7ED2-4AA3-84F4-81CA1712217E} in state 'RetrievedData'. DataTransferService 4/26/2010 10:47:11 PM 2004 (0x07D4)

DTSJob {B40BBB03-0BA0-460A-B822-3DB2535AFCF1} successfully completed download. DataTransferService 4/26/2010 10:48:10 PM 3208 (0x0C88)

DTSJob {B40BBB03-0BA0-460A-B822-3DB2535AFCF1} in state 'NotifiedComplete'. DataTransferService 4/26/2010 10:48:11 PM 3488 (0x0DA0)

DTS job {B40BBB03-0BA0-460A-B822-3DB2535AFCF1} has completed:

Status : SUCCESS

Start time : 04/26/2010 22:48:07

Completion time : 04/26/2010 22:48:10

Elapsed time : 3 seconds DataTransferService 4/26/2010 10:48:11 PM 3488 (0x0DA0)

Then you will see the downloaded progress and completed with the execution of the process. If it is failing make sure that the DP is available and also that the BITS is working fine.

Execmgr.log

Program Test Program change to state STATE_ADVANCED_DOWNLOAD content in progress execmgr 4/26/2010 10:47:29 PM 1944 (0x0798)

Execution Request for package LAB00003 program Test Program state change from NotExist to AdvancedDownload execmgr 4/26/2010 10:47:29 PM 1944 (0x0798)

Mandatory execution requested for program Test Program and advertisement LAB20000 execmgr 4/26/2010 10:47:29 PM 3208 (0x0C88)

Creating mandatory request for advert LAB20000, program Test Program, package LAB00003 execmgr 4/26/2010 10:47:29 PM 3208 (0x0C88)

Raising event:

[SMS_CodePage(437), SMS_LocaleID(1033)]

instance of SoftDistWaitingContentEvent

{

AdvertisementId = "LAB20000";

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

DateTime = "20100426171731.545000+000";

MachineName = "SQL";

PackageName = "LAB00003";

PackageVersion = "1";

ProcessID = 3568;

ProgramName = "Test Program";

SiteCode = "LAB";

ThreadID = 3208;

};

execmgr 4/26/2010 10:47:31 PM 3208 (0x0C88)

Successfully raised SoftDistWaitingContentEvent event for program Test Program execmgr 4/26/2010 10:47:31 PM 3208 (0x0C88)

Execution Request for package LAB00003 program Test Program state change from WaitingDependency to WaitingContent execmgr 4/26/2010 10:47:31 PM 3208 (0x0C88)

Content is available for program Test Program. execmgr 4/26/2010 10:48:18 PM 3488 (0x0DA0)

CExecutionRequest::Service Windows Manager has allowed us to run. execmgr 4/26/2010 10:48:18 PM 3488 (0x0DA0)

Execution Request for package LAB00003 program Test Program state change from WaitingContent to NotifyExecution execmgr 4/26/2010 10:48:18 PM 3488 (0x0DA0)

Notify user mandatory program Test Program is about to run execmgr 4/26/2010 10:48:18 PM 3488 (0x0DA0)

Execution Manager timer has been fired. execmgr 4/26/2010 10:53:18 PM 2184 (0x0888)

Executing program test.bat in Admin context execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Execution Manager timer has been fired. execmgr 4/26/2010 10:53:19 PM 3752 (0x0EA8)

Execution Request for package LAB00003 program Test Program state change from Running to NotifyExecution execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Checking content location C:\WINDOWS\system32\CCM\Cache\LAB00003.1.System for use execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Successfully selected content location C:\WINDOWS\system32\CCM\Cache\LAB00003.1.System execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Executing program as a script execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Successfully prepared command line "C:\WINDOWS\system32\CCM\Cache\LAB00003.1.System\test.bat" execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Command line = "C:\WINDOWS\system32\CCM\Cache\LAB00003.1.System\test.bat", Working Directory = C:\WINDOWS\system32\CCM\Cache\LAB00003.1.System\ execmgr 4/26/2010 10:53:19 PM 2184 (0x0888)

Created Process for the passed command line execmgr 4/26/2010 10:53:20 PM 2184 (0x0888)

Raising event:

[SMS_CodePage(437), SMS_LocaleID(1033)]

instance of SoftDistProgramStartedEvent

{

AdvertisementId = "LAB20000";

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

CommandLine = "\"C:\\WINDOWS\\system32\\CCM\\Cache\\LAB00003.1.System\\test.bat\"";

DateTime = "20100426172320.000000+000";

MachineName = "SQL";

PackageName = "LAB00003";

ProcessID = 3568;

ProgramName = "Test Program";

SiteCode = "LAB";

ThreadID = 2184;

UserContext = "NT AUTHORITY\\SYSTEM";

WorkingDirectory = "C:\\WINDOWS\\system32\\CCM\\Cache\\LAB00003.1.System\\";

};

execmgr 4/26/2010 10:53:20 PM 2184 (0x0888)

Raised Program Started Event for Ad:LAB20000, Package:LAB00003, Program: Test Program execmgr 4/26/2010 10:53:20 PM 2184 (0x0888)

Program exit code 0 execmgr 4/26/2010 10:53:24 PM 3752 (0x0EA8)

Looking for MIF file to get program status execmgr 4/26/2010 10:53:24 PM 3752 (0x0EA8)

Script for Package:LAB00003, Program: Test Program succeeded with exit code 0 execmgr 4/26/2010 10:53:24 PM 3752 (0x0EA8)

Raising event:

[SMS_CodePage(437), SMS_LocaleID(1033)]

instance of SoftDistProgramCompletedSuccessfullyEvent

{

AdvertisementId = "LAB20000";

ClientID = "GUID:76B6D180-F0B6-4689-B294-6CCE9033D7EB";

DateTime = "20100426172324.741000+000";

MachineName = "SQL";

PackageName = "LAB00003";

ProcessID = 3568;

ProgramName = "Test Program";

SiteCode = "LAB";

ThreadID = 3752;

UserContext = "NT AUTHORITY\\SYSTEM";

};

execmgr 4/26/2010 10:53:24 PM 3752 (0x0EA8)

Raised Program Success Event for Ad:LAB20000, Package:LAB00003, Program: Test Program execmgr 4/26/2010 10:53:24 PM 3752 (0x0EA8)

Execution is complete for program Test Program. The exit code is 0, the execution status is Success execmgr 4/26/2010 10:53:24 PM 2184 (0x0888)

Execution Manager timer has been fired. execmgr 4/26/2010 10:55:29 PM 2184 (0x0888)

If there are errors here you need to check the program command line and check if you can execute this command manually in your system. Please note that in SCCM software distribution is a just a command carrier and it will carry the command which you have requested with the set of files required so if there is any execution error you need to troubleshoot the same differently.

For more details please see the following link

http://technet.microsoft.com/en-us/library/bb632640.aspx Software Distribution in Configuration Manager

http://technet.microsoft.com/en-us/library/bb892792.aspx : Troubleshooting Software Distribution Issues

http://technet.microsoft.com/en-us/library/bb932214.aspx : Software Distribution Troubleshooting Flowcharts

http://technet.microsoft.com/en-us/library/bb735865.aspx : Troubleshooting Software Distribution Using Custom Error Codes

Troubleshooting SCCM Part V.........Heartbeat Discovery

2011-02-01T05:09:00Z

Heartbeat Discovery

This is important for the understanding of the health state of the agent, this can be scheduled in the SCCM server using the console and the settings are available under discovery rules

Depending on the schedules set on the server, once initiated, the agent reads the inventory type to determine by querying WMI.

Once the Discovery Agent has determined its Scan type, it must now determine precisely what it needs to inventory. This is accomplished by again pulling configuration data from WMI. Discovery Rule information is stored within the same namespace of WMI (Root\CCM\Policy\Machine)

The scheduler sends a message to the Inventory Agent:

Client Side

Schedule.log:

Sending message for schedule 'Machine/{00000000-0000-0000-0000-000000000003}' (Target: 'direct:InventoryAgent', Name: '') $$<Scheduler><Sun Apr 24 9:39:06.003 2010 Eastern Standard Time><thread=2768 (0xAD0)>

smscliui.log:

Site is in mixed mode. Internet tab will not be displayed. smscliui 2/1/2010 9:02:22 AM 3544 (0x0DD8)

Perform Action: Discovery Data Collection Cycle - {00000000-0000-0000-0000-000000000103}. Message sent, id={7EAD483B-17D6-45FD-A7E2-F8B2AE3797B5} smscliui 2/1/2010 9:03:17 AM 3564 (0x0DEC)

Then the Inventory agent collects the data and sends the xml file to the Management Point.

Inventoryagent.log:

Inventory: *********************** Start of message processing. *********************** InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Inventory: Message type is InventoryAction InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Inventory: Temp directory = C:\WINDOWS\system32\CCM\Inventory\Temp\ InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Inventory: Clearing old collected files. InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Inventory: Opening store for action {00000000-0000-0000-0000-000000000003} ... InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Inventory: Action=Discovery ReportType=Full InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Inventory: Initialization completed in 0.400 seconds InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, IPAddress, IPXAddress, MACAddress FROM Win32_NetworkAdapterConfiguration WHERE IPEnabled=TRUE; Timeout = 600 secs. InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Collection: Namespace = \\.\root\cimv2; Query = SELECT __CLASS, __PATH, __RELPATH, UserName FROM Win32_ComputerSystem; Timeout = 600 secs. InventoryAgent 4/23/2010 10:04:46 AM 2176 (0x0880)

Collection: Namespace = \\.\root\ccm\invagt; Query = SELECT __CLASS, __PATH, __RELPATH, IPv6Address FROM

………………….

………………

…………………….

Collection: 13/14 inventory data items successfully inventoried. InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Collection Task completed in 0.621 seconds InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: 1 Collection Task(s) failed. InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Temp report = C:\WINDOWS\system32\CCM\Inventory\Temp\302aac72-7191-41b1-9b92-40b6b08b31c6.xml InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Starting reporting task. InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Reporting: 11 report entries created. InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Reporting Task completed in 0.090 seconds InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Successfully sent report. Destination:mp:MP_DdrEndpoint, ID: {209E69B5-519E-414F-AB47-703B1F1DC1AE}, Timeout: 80640 minutes MsgMode: Signed, Not Encrypted InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Cycle completed in 1.812 seconds InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Inventory: Action completed. InventoryAgent 4/23/2010 10:04:47 AM 2176 (0x0880)

Server Side

After that the processing takes place on the MP. The xml file is translated into a DDR:

MP_Ddr.log:

Ddr Task: Translate report attachment to file "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\BO4QB24H.DDR" returned 0 MP_DdrEndpoint 4/21/2010 10:38:37 AM 4360 (0x1108)

Mp Message Handler: copying attachment to C:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\DdrAttachment2R4M0DLR.xml MP_DdrEndpoint 4/23/2010 10:04:47 AM 2600 (0x0A28)

Inv-Ddr Task: processing xml file "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\DdrAttachment2R4M0DLR.xml" MP_DdrEndpoint 4/23/2010 10:04:47 AM 2512 (0x09D0)

Full report from client SQL, action description = Discovery MP_DdrEndpoint 4/23/2010 10:04:47 AM 2512 (0x09D0)

Ddr Task: Translate report attachment to file "C:\Program Files\Microsoft Configuration Manager\inboxes\auth\ddm.box\H5AVRZ5O.DDR" returned 0 MP_DdrEndpoint 4/23/2010 10:04:48 AM 2512 (0x09D0)

The Management Point File Dispatch Manager copies the files from the MP folder structure to the site server folder structure.

And after this on the site server the Discovery Data Manager inserts the data into the SCCM database:

ddm.log:

DDM is configured to synchronize the network config data (NCF) files at startup and every 15 minutes thereafter. SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:34 AM 3864 (0x0F18)

CDiscoverDataManager::GetSiteStatus - Registering SQL types, Server = SQL, Database = SMS_LAB, User = SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:34 AM 3864 (0x0F18)

Preparing to sync deletes... SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:34 AM 3864 (0x0F18)

No system deletions to replicate. SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:34 AM 3864 (0x0F18)

Looking for ClientKeyData changes SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:34 AM 3864 (0x0F18)

No ClientKeyData changes to replicate SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:34 AM 3864 (0x0F18)

Synchronizing network config data (NCF) files with site control data in the database. SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:54 AM 1472 (0x05C0)

Synchronization of network config data (NCF) files is complete. SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:01:54 AM 1472 (0x05C0)

Refreshing site settings..... SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:49 AM 3864 (0x0F18)

Updated inbox def 15, Discovery Data Manager SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:49 AM 3864 (0x0F18)

Updated inbox def 41, Discovery Data Manager (Trusted) SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

Updated inbox def 48, Discovery Data Manager (Registration) SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

Updated inbox def 14, Discovery Asst Rules SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

Updated inbox def 50, Discovery Data Manager (Notification) SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

Updated inbox def 9, Data Loader SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

Updated inbox def 10, Software Inventory Processor (Site) SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

Updated inbox def 23, Client Configuration Record (Incoming) SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

DDM is configured to synchronize the network config data (NCF) files at startup and every 15 minutes thereafter. SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

CDiscoverDataManager::GetSiteStatus - Registering SQL types, Server = SQL, Database = SMS_LAB, User = SMS_DISCOVERY_DATA_MANAGER 4/23/2010 10:04:50 AM 3864 (0x0F18)

The same log but with SQL logging enabled on the site server:

Ddm.log:

Processing file a4z7f6ye.DDRSMS_DISCOVERY_DATA_MANAGER3/13/2010 3:24:06 PM316 (0x013C)

SQL>>>select d1.DiscArchKey,d1.DiscArchName,d1.BaseTableName,d1.Flags,d2.PropertyName,d2.ColumnName,d2.ValueType,d2.MaxWidth,d2.Flags,d2.ArrayTableName FROM DiscoveryArchitectures AS d1 LEFT JOIN DiscPropertyDefs AS d2 ON d1.DiscArchKey = d2.DiscArchKey where d1.DiscArchName = "System" order by d1.DiscArchKeySMS_DISCOVERY_DATA_MANAGER3/13/2010 3:24:06 PM316 (0x013C)