Better Living Through Narratology

Moving Orphaned Secondary Site Systems in ConfigMgr 2007

Recently, I came across an issue in which a Secondary Site Server experienced unrecoverable hardware failure.  After the server was rebuilt, the old site was deleted with PreInst.exe /DELSITE and a new Secondary Site was created, I had to start re-adding all of the servers that were members of the failed Seconday Site.

For simplification, we’ll say the site code of the crashed Secondary Site is OLD and the site code of the newly created Secondary Site is NEW.  (Gotta love convenient three-letter words when it comes to SCCM!)

After adding the Site Systems and installing some component roles, I noticed ID 1048 in the Site Status error logs.  Error 1048 states: “SMS Site Component Manager detected that site system \\SERVERNAME is currently in use by SMS site OLD.”

OLD had been deleted but the Site Systems could not be removed before deletion, so they were, in effect, orphaned.  SCCM should  (more…)

Posted in IT, SCCM | Comments Off on Moving Orphaned Secondary Site Systems in ConfigMgr 2007


SCCM Keeps Processing Package

Occasionally, SCCM may seem to get stuck processing a package.  When viewing Status Messages, you’ll see :

SMS Distribution Manager successfully processed package “PRIN Windows 7 SP1 12.3″ (package ID = PRI00263).
SMS Distribution Manager is beginning to process package “PRIN Windows 7 SP1 12.3″ (package ID = PRI00263).
SMS Distribution Manager successfully processed package “PRIN Windows 7 SP1 12.3″ (package ID = PRI00263).
SMS Distribution Manager is beginning to process package “PRIN Windows 7 SP1 12.3″ (package ID = PRI00263).
SMS Distribution Manager successfully processed package “PRIN Windows 7 SP1 12.3″ (package ID = PRI00263).
SMS Distribution Manager is beginning to process package “PRIN Windows 7 SP1 12.3″ (package ID = PRI00263).

This will keep going for sometime with no clear progress on distribution.  For example, if you’re trying to send a package to SEC-DP-SERVER and the package continues to be processed as above, then when you look at distmgr.log, you may see something like this:

Used 0 out of 3 allowed processing threads.
Sleep 3600 seconds…
Processing incoming file C:\Program Files (x86)\Microsoft Configuration Manager\inboxes\distmgr.box\INCOMING\WHCXFL1G.PKG.
Adding package PRI00263 to the active package array.
StoredPkgVersion (1) of package PRI00263. StoredPkgVersion in database is 1.
Distribution Manager will not update the StoredPkgVersion in the Database as Despooler will.
Updated replicated package info for package PRI00263
No changed detected for package server [“Display=\\SEC-DP-SERVER1\”]MSWNET:[“SMS_SITE=SEC”]\\SEC-DP-SERVER1\ for package PRI00263, no need to update

Updated replicated package server [“Display=\\SEC-DP-SERVER\”]MSWNET:[“SMS_SITE=SEC”]\\SEC-DP-SERVER\ for package PRI00263

Updated replicated package program info for package PRI00263, program *, dependent program
Successfully processed C:\Program Files (x86)\Microsoft Configuration Manager\inboxes\distmgr.box\INCOMING\WHCXFL1G.PKG, delete it
Removing package PRI00263 from the active package array.
Used 0 out of 3 allowed processing threads.
(more…)

Posted in IT, SCCM | Comments Off on SCCM Keeps Processing Package


Persist Task Sequence After Reboot

One of the nightmares projects I’ve been working on recently (with my guru co-worker ZenShaze) deals with integrating SCCM and a product that reverts workstations to a previous state.  Like a forced “snapshot” that will remove malware and unwanted programs with a single reboot.  The software essentially “anchors” specific files and directories and allows any changes made to those anchored targets to be saved after a reboot – everything else gets locked down and reverted to an earlier state.

Not a big issue when it comes to ConfigMgr running normally – until you run a Task Sequence that calls for a reboot.  When this happens, SCCM makes (more…)

Posted in IT, SCCM | Comments Off on Persist Task Sequence After Reboot


SCCM Report listing count of computers and associated hardware information

I needed a report today that would show me the amount of computers that we had of a certain make and model (easy enough) but the report also had to show the associated hardware information for those models.  Mildly problematic on a certain scale because someone with a specific model of computer out there is bound to have more or less RAM than someone else with the same model of computer.

After a good deal of fumbling around (SQL is not my strong suit), I pieced this together and it worked.

select
 GSCS.Manufacturer0 as [Manufacturer],
 GSCS.Model0 as [Model],
 MRY.TotalPhysicalMemory0 as [RAM],
 GSP.MaxClockSpeed0 as [CPU Speed (MHz)],
 GSLD.Size0 as [Disk Size (MB)],
 count(*) as [Count]
from v_R_System RS
left join v_GS_PROCESSOR GSP on RS.ResourceID = GSP.ResourceID
left join v_GS_X86_PC_MEMORY MRY on RS.ResourceID = MRY.ResourceID
left join v_GS_COMPUTER_SYSTEM GSCS on RS.ResourceID = GSCS.ResourceID
left join v_GS_LOGICAL_DISK GSLD on RS.ResourceID = GSLD.ResourceID
 Group by GSCS.Model0, MRY.TotalPhysicalMemory0, GSP.MaxClockSpeed0, GSCS.Manufacturer0, GSLD.Size0
 Order by GSCS.Model0

(more…)

Posted in IT, SCCM, SQL | Comments Off on SCCM Report listing count of computers and associated hardware information