HASMUG and I are working with Maarten Goet and Cameron Fuller (System Center MVP’s) to organize a 2-track learning event the day directly after TechEd ends. We will have 12 System Center, Azure, and Hyper-V MVP speakers along with Microsoft product group staff presenting on great deep dive sessions.

We have 10+ sessions scheduled along with interactive breaks and a community mixer all at George R. Brown, the same venue as TechEd!

Rock Star Lineup: Wally Mead, Michael Niehaus, Johan Arwidmark, Jason Sandys, Hans Vredevoort, Marc van Eijk, Pete Zerger, Damian Flynn, Robert Hedblom, Marcel Zehner, Chris Ross, Cameron Fuller, and Maarten Goet.

If you would like more information or if you would like to support the event please visit the HASMUG site.

Sessions are currently published on Twitter.

Space is limited, register today: http://hasmug.eventbrite.com

The link to the slides is here: http://tinyurl.com/scnews2014m1

HASMUG Post (HTML format): http://wp.me/p1OE8p-8j

http://blogs.catapultsystems.com/cfuller/archive/2013/10/30/mms-and-teched.aspx?id=607&List=52b49438-d7a8-4f25-91ea-392a6e92c57f&ItemID=607

SELECT DisplayName0, Count(Distinct arp.ResourceID) AS 'Count', Publisher0, Version0, @CollID as CollectionID 
FROM fn_rbac_Add_Remove_Programs(@UserSIDs)  arp 
JOIN fn_rbac_FullCollectionMembership(@UserSIDs)  fcm on arp.ResourceID=fcm.ResourceID 
WHERE ((Publisher0 like @softwarenamefilter) OR (DisplayName0 like @softwarenamefilter) ) 
and fcm.CollectionID=@CollID 
GROUP BY DisplayName0, Publisher0, Version0  
ORDER BY Publisher0, Version0

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 application.

I use ConfigMgr to also manage server environments. I ran into an issue where I was trying to supersede an application and test the deployment however I cannot remove the “Automatically upgrade any superseded versions of this application” option during deployment. I am targeting servers (devices) and not users in this scenario. I want to test and manage the app upgrade without it being forced and still be able to take full advantage of the app model.

The only work-around I found thus far was to create the deployment prior to adding superseded applicaiton(s) to the deployed application. I’m assuming we should be able to create a deployment using PowerShell or the ConfigMgr 2012 SDK without forcing superseded applications to be upgraded as another workaround but haven’t tried it yet. I’ll update this post when I have any other confirmed workarounds. In the mean time please vote up the feedback I’ve posted on Microsoft Connect for this issue: https://connect.microsoft.com/ConfigurationManagervnext/feedback/details/796927/automatically-upgrade-any-superseded-versions-of-this-application-grayed-out-for-device-collection-deployments

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 Windows 8.1
• Support for Windows Server 2012 R2
• Maintenance Windows exclusively for Software Updates
• UI Improvements
• Automatic Deployment Rules (ADR) improvements for software updates
• Clearer summary messages
• Enhanced DP data usage reports
• Creation, modification and offline servicing of VHDs and the uploading of VHDs to System Center 2012 R2 Virtual Machine Manager

System Center 2012 R2 Operations Manager Highlights:

• Availability and performance metrics across storage, network, and compute for the datacenter administrator
• New dashboard includes health metrics on a variety of resources, such as load balancers, IIS pools, storage LUNs, hosts, storage pools, file servers, VMs, VMM servers and host clusters.
• System Center Advisor (Best practice workload configuration) accessibility in the Operations Manager console
• Hybrid view of on-premise and cloud hosted components
• Code level issue traceability – for .NET and Java applications
• Java APM (Application Performance Monitoring) including Java Tomcat and other Java web services
• Unified monitoring agent between System Center and Visual Studio to further simplify issue debugging and collaboration.

Windows Server 2012 R2: http://www.microsoft.com/en-us/server-cloud/windows-server/windows-server-2012-r2.aspx & http://technet.microsoft.com/en-US/windows/dn140266.aspx

Windows 8.1:  http://technet.microsoft.com/en-US/windows/dn140266.aspx

SELECT 
	CI_ID,
	CI_UniqueID,
	SDMPackageDigest,
    SDMPackageDigest.value('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Title)[1]', 'nvarchar(max)') AS DTTitle,
    SDMPackageDigest.value('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/@Technology)[1]', 'nvarchar(max)') AS DTTechnology,
    SDMPackageDigest.value('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:Contents/p1:Content/p1:Location)[1]', 'nvarchar(max)') AS DTContentLocation,       
    SDMPackageDigest.value('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:InstallAction/p1:Args/p1:Arg)[1]', 'nvarchar(MAX)') AS Install,
    SDMPackageDigest.value('declare namespace p1="http://schemas.microsoft.com/SystemCenterConfigurationManager/2009/AppMgmtDigest"; 
    (p1:AppMgmtDigest/p1:DeploymentType/p1:Installer/p1:UninstallAction/p1:Args/p1:Arg)[1]', 'nvarchar(MAX)') AS Uninstall
FROM 
	v_ConfigurationItems
WHERE 
	CIType_ID = 21 -- DeploymentType CI's

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
AND IsLatest = 1

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

From within Microsoft SQL Management Studio, run the query below to check fragmentation:

SELECT a.index_id, name, avg_fragmentation_in_percent FROM

sys.dm_db_index_physical_stats (NULL,NULL, NULL, NULL, NULL) AS a JOIN sys.indexes

AS b ON a.object_id = b.object_id AND a.index_id = b.index_id Where

avg_fragmentation_in_percent > 30

GO

2)    Run this command on the tables:

Exec sp_MSForEachtable 'DBCC DBREINDEX (''?'')'

go

3)    Once this was done, run the “Rebuild Indexes” task from Site Maintenance of the primary server.

4)    Finally run this command back on the SQL Server via SQL Management Studio.

Exec sp_MSForEachTable "UPDATE STATISTICS ? with fullscan"

go