If you’ve ever wanted to report on ConfigMgr client IPAddress you know it can be a challenge. ConfigMgr stores IP Address information in the v_GS_NETWORK_ADAPTER_CONFIGURAITON SQL view (and other places) but it is actually an array of both IPv4 and
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 WQL queries for ConfigMgr/SCCM collections, but all will translate to T-SQL queries for reporting. Computers which are joined to a
SQL 2012, BIDS, and SSDT
With SQL Server 2012 Business Intelligence Development Studio is replaced with SQL Server Data Tools. BIDS = Business Intelligence Development Studio SSDT = SQL Server Data Tools (http://msdn.com/data/tools.aspx) If you customize SQL Reporting Services reports for SCCM 2007 or ConfigMgr
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 a case-sensitive comparison despite the case-insensitve collation. Convert data to binary [cc lang=’sql’ line_numbers=’false’]SELECT * FROM MyTable WHERE CAST(Value1 AS
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, and Computer count.
|
1 2 3 4 5 6 7 |
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 |
Among other things, this will let you know if you need KB2793312B (see MyITforum), Cumulative Update 1
SCCM Unused Packages
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
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 content to my blog. Finding drivers in a Boot Image [cc lang=’sql’ line_numbers=’false’] use CM_xxx — All Drivers in a