ConfigMgr and SQL – NTFS allocation unit size
It’s been many years since I read that SQL databases should use an NTFS volume formatted with at 64KB file…
Category: T-SQL
Sorting ConfigMgr data by IP Address
If you’ve ever wanted to report on ConfigMgr client IPAddress you know it can be a challenge. ConfigMgr stores IP…
A Collection of ConfigMgr 2012 Collection Queries
Tommy Gunn started a great post on this same topic at SystemCenterCentral. I’m adding my own here. *note: these are…
SQL Reports Subscription Ownership
We have a number SCCM Reporting Services subscriptions for our automated reporting. Yesterday I had a former team member’s ID…
Case Sensitive comparison in SQL
The default collation that Microsoft SQL uses (and requried collation for SCCM) is case-insensitive. Here are some tips for performing…
SCCM Report of Operating Systems and Types
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,…
SCCM Unused Packages
This is a t-sql query to help find Packages which you are no longer using so they can be properly…
Drivers and Boot Images
I’m reposting two wiki’s I had written awhile ago. I don’t really use my wiki anymore so I’m moving some…