SCCM Report of Operating Systems and Types

No Gravatar

Based on Sherry Kissinger’s blog http://myitforum.com/cs2/blogs/skissinger/archive/2009/06/23/32bit-vs-64bit-report.aspx here is the summary report for a list of Processors, OS Type, OS Name, and Computer count

[cc lang=’sql’ line_numbers=’false’]
select pr.datawidth0 [Processor bits]
, pr.addresswidth0 [OS bits]
, sys.Operating_system_Name_and0 [OS Name]
,count(sys.resourceid) [Computers]
from v_r_system sys join v_gs_processor pr on sys.resourceid=pr.resourceid
group by pr.datawidth0, pr.addresswidth0, sys.Operating_system_Name_and0
order by pr.datawidth0, pr.addresswidth0, sys.Operating_system_Name_and0
[/cc]

Among other things, this will let you know if you need KB2793312B (see MyITforum), Cumulative Update 1 for SCM 2012 RTM, or even Cumulative Update 2.

 

January 8, 2013

Posted In: ConfigMgr 2007, ConfigMgr 2012, T-SQL

SCCM and BranchCache

No Gravatar

 

 

Configuring BranchCache on the SCCM Distribution Point

  • On the Distribution Point properties, enable “Allow clients to transfer content from this distribution point using BITS, HTTP, and HTTPS”
  • In Server Manager
    • install the BranchCache Feature
    • configure the Windows Firewall to ensure content can be requested
      • [TODO]

Configuring BranchCache on the SCCM Clients.  A domain Group Policy is best, but a local Group Policy as well as a few NETSH commands will work.

  • From a policy
    • Computer Configuration \ Policies \ Administrative Templates \
      • Enable Turn on BranchCache
      • Enable Set BranchCache Distributed Cache mode
      • Enable Configure BranchCache for network files = ?? milliseconds (default is 80, I suggest 20)
      • (optional) Enable Set percentage of disk space used for client computer cache (default is 5%)
    • Computer Configuration \ Policies \ Windows Settings \ Windows firewall with Advanced Security \ Windows Firewall with Advanced Security \ Inbound Rules
      • Enable BranchCache Content Retrieval (HTTP-In)
      • Enable BranchCache Peer Discovery (WSD-In)
    • Computer Configuration \ Policies \ Windows Settings \ Windows firewall with Advanced Security \ Windows Firewall with Advanced Security \ Outbound Rules
      • Enable BranchCache Content Retrieval (HTTP-Out)
      • Enable BranchCache Peer Discovery (WSD-Out)
  • From the command line
  • ?????

How to tell if it is working

  • Start Performance Monitor
  • Add monitor elements (probably from a remote computer)
  • Add BranchCache (specifically
    • BITS: Bytes from cache
    • BITS: Bytes from server
    • Discovery: Attempted discoveries
    • Discovery: Successful discoveries
    • Retrieval: Bytes from cache
    • Retrieval: Bytes from server
    • Retrieval: Bytes served (show how much this computer is providing to other peers)
  • Monitor these counters
  • Deploy something NEW from SCCM ensuring that “download from distribution point” is enabled in order to force BITS.  You could also manually transfer data via BITSAdmin.exe
  • Run this locally to see some good basic configuration and utilization info
  • Calcuate Savings percentage = Retrieval: Bytes from cache / (Retrieval: Bytes from cache + Retrieval: Bytes from server)
  • Calculate Bytes Saved = Hypothetical Server Bytes Without Caching – Client Cache Miss Bytes – Server Cache Miss Bytes – Hash Bytes

Requires:

  • Windows Server 2008 R2
  • Windows 7 Enterprise or Ultimate
  • BITS 4.0

References

October 4, 2012

Posted In: ConfigMgr 2007, ConfigMgr 2012

SCCM Unused Packages

No Gravatar

This is a t-sql query to help find Packages which you are no longer using so they can be properly organized/categorized/deleted.

Thanks to John Nelson (Number 2) and Christjan Schumann for doing the heavy lifting.  I only put the two puzzle pieces together.

References:

September 20, 2012

Posted In: ConfigMgr 2007, ConfigMgr 2012, T-SQL

Remove SCCM 2007 Child Primary Site

No Gravatar

Thanks to Tom Popov for a nice set of instructions (instead of Microsoft’s spaghetti @ http://technet.microsoft.com/en-us/library/bb632662.aspx).

http://tompopov.blogspot.com/2011/08/remove-sccm-child-primary-connection.html

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

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]

[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
Where
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
[/cc]

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
[/cc]

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 2007, ConfigMgr 2012, T-SQL