Tag Archives: System Center

Day-5 #TE14D5 is less than two weeks away!

May 4, 2014 Stephen Leuthold

 As you might know, TechEd North America is just around the corner. It’s going to be a great event! How can we make a great event even better? By inviting Microsoft Most Valuable Professionals from all over the world to present complementary sessions on Day-5, May 16th. HASMUG and I are working with Maarten Goet and Cameron Fuller (System Center MVP’s) to organize a […]

Configuration Manager, Microsoft Also tagged , , , Leave a comment

System Center News & Updates – 2014 M1

February 1, 2014 Stephen Leuthold

“System Center News & Updates” is apart of an annual 4 part series of anything new & noteworthy in the System Center world. We publish it at the end of every HASMUG (Houston Area Systems Management User Group meeting). The publication has two placeholders: (ECM) Enterprise Client Management, and (CDM) Cloud and Datacenter Management. We […]

Microsoft, System Center Also tagged , , , , , , , , Leave a comment

Count of instances of specific software registered with Add or Remove Programs‏ – Wrong counts SCCM 2012

October 30, 2013 Stephen Leuthold

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 […]

Configuration Manager, Microsoft, System Center 2012 Also tagged , , , Leave a comment

System Center 2012 Configuration Manager (SCCM): Prevent automatic upgrade on deployment to device collection

August 12, 2013 Stephen Leuthold

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 […]

Configuration Manager, System Center 2012 Also tagged , , , 1 Comment

System Center 2012 R2 Preview Highlights

June 4, 2013 Stephen Leuthold

This was announced at TechEd 2013 yesterday and they are anticipating a release by the end of the year. This release will be the successor to System Center 2012 SP1. System Center 2012 R2 Preview: http://www.microsoft.com/en-us/server-cloud/system-center/system-center-2012-r2.aspx White Paper: http://download.microsoft.com/download/7/7/2/7721670F-DEF0-40D3-9771-43146DED5132/System_Center_2012%20R2_Overview_White_Paper.pdf System Center 2012 R2 Configuration Manager: http://www.microsoft.com/en-us/server-cloud/system-center/system-center-2012-r2-configuration-manager.aspx System Center 2012 R2 Configuration Manager Highlights: Support for […]

Microsoft, System Center 2012 Also tagged , , , Leave a comment

Configuration Manager 2012: SQL XPATH Query for Deployment Type

May 23, 2013 Stephen Leuthold

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 Also tagged , , , , , , , , , Leave a comment

Add Adobe Acrobat XI and Reader XI catalogs to SCUP 2011

May 21, 2013 Stephen Leuthold

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 Also tagged , , , , , , , , , Leave a comment

SCCM 2012 Poor Console Performance In Software Updates

May 21, 2013 Stephen Leuthold

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 Also tagged , , , , 1 Comment

Beta Private Cloud exams from MMS not showing on MCP transcript

August 24, 2012 Stephen Leuthold

A few month ago I came across Kevin Holman’s blog post on checking the status of the Private Cloud beta exams I took at MMS (71-246 Monitoring and Operating a Private Cloud with System Center 2012 & 71-247 Configuring and Deploying a Private Cloud with System Center 2012) and to my excitement I passed both […]

Certification, Microsoft, Private Cloud, SCCM, SCOM Also tagged , , , , Leave a comment

How to Install Systems Center Capacity Planner on Windows 7

October 6, 2009 Stephen Leuthold

Had an issue installing Systems Center Capacity Planner on Windows 7 today… it would not. It kept prompting me with a blank window with the options “yes” or “no”. The Setup MSI package is looking for MDAC. MDAC already is included with Windows 7 so there is no need to install. Basically you need to […]

Microsoft, SCOM Also tagged , , , 2 Comments