Monthly Archives: May 2013

Configuration Manager 2012: SQL XPATH Query for Deployment Type

Below is an example of how to write a SQL XPATH query to extract details from a deployment type CI contained in an XML data type. In this query we are returning columns for deployment type Title, SDMPackageDigets (XML), Technology (MSI, Script, etc.), Content Location, and Install and Uninstall strings. I basically found an example […]

Configuration Manager, Microsoft, System Center 2012 Tagged , , , , , , , , , , Leave a comment

Configuration Manager 2012: Query for the Application Owners and Support Contacts

Below is an example of how to formulate a SQL query to obtain the “first” app owner and support contact on an Application.   1 2 3 4 5 6 7 8 9 WITH XMLNAMESPACES ( DEFAULT ‘http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest’ ) SELECT SDMPackageDigest.value('(/AppMgmtDigest/Application/Title)[1]’, ‘nvarchar(MAX)’) [Title], SDMPackageDigest.value('(/AppMgmtDigest/Application/Owners/User/@Id)[1]’, ‘nvarchar(MAX)’) [Owners], SDMPackageDigest.value('(/AppMgmtDigest/Application/Contacts/User/@Id)[1]’, ‘nvarchar(MAX)’) [Support Contact] FROM  CI_ConfigurationItems WHERE CIType_ID = 10 […]

Configuration Manager, Microsoft, System Center 2012 Tagged , , , , , , , , Leave a comment

Add Adobe Acrobat XI and Reader XI catalogs to SCUP 2011

Adobe Acrobat XI (11): http://armmf.adobe.com/arm-manifests/win/SCUP/Acrobat11_Catalog.cab AdobeReader XI (11): http://armmf.adobe.com/arm-manifests/win/SCUP/Reader11_Catalog.cab Tweet

Configuration Manager, Microsoft, System Center 2012 Tagged , , , , , , , , , , Leave a comment

SCCM 2012 Poor Console Performance In Software Updates

UPDATE 5/21/2013: Just heard from the MVP community that some folks are referencing this article to improve performance: http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html From within Microsoft SQL Management Studio, run the query below to check fragmentation: 1 2 3 4 5 6 7 8 9 SELECT a.index_id, name, avg_fragmentation_in_percent FROM   sys.dm_db_index_physical_stats (NULL,NULL, NULL, NULL, NULL) AS a JOIN […]

Configuration Manager, System Center 2012 Tagged , , , , , 1 Comment