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

WSUS database and content migration

No Gravatar

This is the simplistic process of moving the db and files for WSUS to a new drive or folder.

Move content

Using the command prompt, run the following

Move the database

Running Microsoft SQL Server Management Studio Express

  • connect to the the Database Engine using \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query as the server and use Windows Authentication
  • select the SUSDB database and detach it dropping any connections
  • move the SUSDB.mdf and SUSDB.ldf files to a new location using Windows Explorer
  • using SSMSE, attache the database (right-click on Databases, select attach)

*If you have trouble connecting to SQL, see this forum chain: http://channel9.msdn.com/Forums/TechOff/255490-How-to-connect-MICROSOFTSSEE

References:

  • http://blogs.technet.com/b/sus/archive/2008/05/19/wsus-how-to-change-the-location-where-wsus-stores-updates-locally.aspx
  • http://blogs.technet.com/b/sbs/archive/2009/09/23/how-to-move-wsus-content-and-database-files-to-a-different-partition.aspx

 

 

October 15, 2012

Posted In: WSUS

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, ConfigMgr 2007

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