Twitter
-
Recent Posts
- Day-5 #TE14D5 is less than two weeks away!
- System Center News & Updates – 2014 M1
- Concerned about the merging of MMS with TechEd? Post your comments on Cameron Fuller’s blog!
- Count of instances of specific software registered with Add or Remove Programs – Wrong counts SCCM 2012
- System Center 2012 Configuration Manager (SCCM): Prevent automatic upgrade on deployment to device collection
Recent Comments
- SCCM – Controlling Application Supersedence – FoxDeploy.com on System Center 2012 Configuration Manager (SCCM): Prevent automatic upgrade on deployment to device collection
- SCCM SQL Queries Mega-Pack | automatizeblog on SCCM 2012 Poor Console Performance In Software Updates
- Automation Scripting PowerShell: Servicios, SSRS, etc « El TecnoBaúl de Kiquenet on PowerShell Script To Restart Service And Dependents
- Estopa on Because of an error in data encryption, this session will end
- Adding A Basic PowerShell recovery to a Monitor | Living with SCOM on PowerShell Script To Restart Service And Dependents
Archives
- May 2014
- February 2014
- October 2013
- August 2013
- June 2013
- May 2013
- January 2013
- August 2012
- December 2011
- April 2011
- February 2011
- December 2010
- October 2010
- June 2010
- March 2010
- November 2009
- October 2009
- September 2009
- July 2009
- June 2009
- November 2008
- October 2008
- August 2008
- July 2008
- January 2008
- December 2007
Categories
Meta
Archive for the Category: Configuration Manager
Count of instances of specific software registered with Add or Remove Programs – Wrong counts SCCM 2012
The problem with the query is that there can be multiple ProdID’s for the same DisplayName0, Publisher0, Version0 returned. So it counts them all, skewing the expected result. I fixed this by changing Count(ProdID0) to Count(Distinct arp.ResourceID) in the dataset… SELECT DisplayName0, COUNT(DISTINCT arp.ResourceID) AS ‘Count’, Publisher0, Version0, @CollID AS CollectionID FROM fn_rbac_Add_Remove_Programs(@UserSIDs) arp JOIN […]
System Center 2012 Configuration Manager (SCCM): Prevent automatic upgrade on deployment to device collection
UPDATE 10/15/2013: Microsoft changed the connect bug I filed a few months back from closed to active. Guess there was a change of heart? 🙂 https://connect.microsoft.com/ConfigurationManagervnext/feedback/details/796927/automatically-upgrade-any-superseded-versions-of-this-application-grayed-out-for-device-collection-deployments UPDATE 10/14/2013: Rusty Ratliff, a member of our user group (HASMUG) has brought to my attention this also affects task sequences that reference an application that supersedes a discovered […]
Also posted in System Center 2012 Tagged 2012, Application Model, Configuration Manager, Deployment, System Center
1 Comment
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 […]
Also posted in Microsoft, System Center 2012 Tagged 2012, CI, command, Configuration Manager, deploymenttype, install, SCCM, SQL, System Center, uninstall, xpath
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 […]
Also posted in Microsoft, System Center 2012 Tagged 2012, Application, Configuration Manager, Contact, Owner, SCCM, SQL, Support, XQUERY
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
Also posted in Microsoft, System Center 2012 Tagged 11, 2011, 2012, Acrobat, Adobe, Configuration Manager, Reader, SCCM, SCUP, System Center, XI
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 […]
Also posted in System Center 2012 Tagged 2012, Configuration Manager, Performance, SCCM, Software Updates, System Center
1 Comment