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…
Tag: T-SQL
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 2012, BIDS, and SSDT
With SQL Server 2012 Business Intelligence Development Studio is replaced with SQL Server Data Tools. BIDS = Business Intelligence Development…
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…