Remove SCCM 2007 Child Primary Site

No Gravatar

Thanks to Tom Popov for a nice set of instructions (instead of Microsoft’s spaghetti @

CEN – Central Site
PRI – Child Primary Site
SEC – Secondary Site

Here is the procedure how to remove PRI SCCM Child Primary Site from its CEN SCCM Parent Site.

  1. from CEN Central Site via SCCM console
    1. delete PRI child site address
  2. from CEN Central Server execute Preinst.exe which is located in C:\Program Files (x86)\Microsoft Configuration Manager\bin\i386\00000409 folder
    1. Preinst.exe /dump -> shows SCCM sites in SCCM Parent Central Site. The target is to remove PRI Child Primary Site.
    2. Preinst.exe /deljob PRI-> Delete jobs for PRI site
    3. Preinst.exe /delSITE PRI CEN -> Delete PRI site
    4. Preinst.exe /deljob PRI -> Execute again to delete any job in meantime
    5. Preinst.exe /dump -> Executing again shows that PRI Child Primary Site has been removed from SCCM Parent site.
  3. from PRI Primary Site via SCCM console remove settings from Report to parent site to Central site

Finally you can see that all locked out items have been removed. All Software deployments packages, Advertisements, OS deployment packages, and Task Sequences have been inherited form SCCM Parent site into SCCM Child Site and can be modified.

September 20, 2012

Posted In: ConfigMgr 2007

Installing SCCM 2012 Secondary Site using A Pre-Installed SQL Express 2008 R2 Instance

No Gravatar

This is a very helpful article on pre-installing SQL Express on a SCCM 2012 Secondary server so you can customize the install to fit your needs.

Even after all of the tweaking noted in the article I still had issues.
I ran into these errors logged in \\CM12-Primary\%systemDrive%\ConfigMgrSetup.log

However, even after enabling TCP/IP and setting the port to 1433 I still could not connect.

  • I then validated that SQL Browser was running, but didn’t help.
  • I used netstat -a to validate that TCP 1433 was listening and UDP 1434 shows as *:*.
  • I could connect to SQL locally using SQL Server Management Studio and SQLCMD, but I could not remotely UNTIL I added the port to the connection string (CM12-Secondary\CONFIGMGRSEC,1433).

It turns out that I didn’t set an exclusion in my SCCM Servers Firewall GPO for SQL Browser (UDP 1434). After adding the exclusion and running GPUpdate all is well.

August 16, 2012

Posted In: ConfigMgr, Trackback

Drivers and Boot Images

No Gravatar

I’m reposting two wiki’s I had written awhile ago.  I don’t really use my wiki anymore so I’m moving some content to my blog.

Finding drivers in a Boot Image

[cc lang=’sql’ line_numbers=’false’]
use CM_xxx
— All Drivers in a Boot Image
select D.CI_ID, D.DriverClass, D.DriverProvider, D.DisplayName, D.DriverType, D.DriverINFFile, D.DriverVersion, D.DriverDate, D.ContentSourcePath, D.CI_ID
from fn_ListDriverCIs(1033) as D
inner join v_BootImagePackage_References as R on D.CI_ID = R.CI_ID
inner join v_BootImagePackage as P on R.PkgID = P.PackageID
where P.Name = ‘MDT Boot Image (x86)’
–and D.DriverINFFile = ‘e1k6232.inf’
–and D.DisplayName = ‘Intel(R) PRO/1000 Gigabit Server Adapter’
— and R.CI_ID = 24948
Order By D.DriverClass, D.DriverProvider, D.DriverVersion

[cc lang=’sql’ line_numbers=’false’]
— All Drivers
select D.DriverClass, D.DriverProvider, D.DisplayName, D.DriverType, D.DriverINFFile, D.DriverVersion, D.DriverDate, D.ContentSourcePath, D.CI_ID
from fn_ListDriverCIs(1033) as D
D.DisplayName like ‘3Com 10/100/1000 PCI’
–and D.DriverINFFile like ‘b57x%’
–and D.DriverProvider like ‘%vmware%’
— and R.CI_ID = 24938
Order By D.DriverClass, D.DriverProvider, D.DriverVersion

Finding boot drivers for OSD

Michael Petersen has a good article on Finding and adding only the correct device driver to the Boot image on his CoreTech blog which is also in the TrueSec July 2011 newsletter.

The day before I saw Michael’s article I worked out a method of using the VEN & DEV ID to find the right driver. I *think* my method is more accurate and will help get the RIGHT driver that is in the SCCM database. I also don’t have to dig through .INF files.

DeviceManager_for_Boot_Devices DeviceManager_Details

[cc lang=’sql’ line_numbers=’false’]
select D.*, DHID.*, DM.*
from v_CI_DriversCIs AS D
inner join v_CI_DriverHardwareIDs AS DHID on DHID.CI_ID = D.CI_ID
inner join v_CI_DriverModels AS DM on DM.CI_ID = D.CI_ID
where DHID.HardwareID = ‘PCI\VEN_8086&DEV_10BD’
— D.CI_ID = 24992
— D.DriverINFFile in (‘b57nd60x.inf’,’couide2.inf’)
— DM.ModelName = ‘VMware Accelerated AMD PCNet Adapter’
— DriverBootCritical = 1 Order by HardwareID

After finding the CI_ID from the SQL Query, I search for that in the SCCM Console and add it to the boot disc.

This way I avoid using the name which can have many duplicates.

July 28, 2011

Posted In: ConfigMgr, ConfigMgr 2007, T-SQL