Monthly Archives: October 2013

Concerned about the merging of MMS with TechEd? Post your comments on Cameron Fuller’s blog!

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

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

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

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