I had to limit my query to some collections but simply put IsCompliant = 0 or 1 depending on your purpose. I’m assuming the summarization task has to run as well for this to update. If that is the case just run Invoke-CMSoftwareUpdateSummarization in PowerShell in order to get up to date info.

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 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!

“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 hope it is useful and informative for the global System Center community.

Are you an MMS original? Concerned about the merger of MMS and TechEd? You have someone that can champion your thoughts to the upper echelons of Microsoft’s System Center product groups, give your feedback on Cameron Fuller’s blog.

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…

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.

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 in this link http://gallery.technet.microsoft.com/scriptcenter/Count-of-EP-Definition-59c06ea2 and added Install and Uninstall columns.