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… Continue reading “ConfigMgr and SQL – NTFS allocation unit size”…
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… Continue reading “Sorting ConfigMgr data by IP Address”…
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… Continue reading “A Collection of ConfigMgr 2012 Collection Queries”…
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… Continue reading “SQL Reports Subscription Ownership”…
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… Continue reading “Case Sensitive comparison in SQL”…
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,… Continue reading “SCCM Report of Operating Systems and Types”…
SCCM Unused Packages This is a t-sql query to help find Packages which you are no longer using so they can be properly… Continue reading “SCCM Unused Packages”…
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… Continue reading “Drivers and Boot Images”…