SCCM Configmgr 2012 way to find Who Created modified Deleted the collection using SSRS Reports

Quick Post: There was a question on TechNet forum asking,about who created the collection ,More read http://social.technet.microsoft.com/Forums/en-US/e5ea645e-84ec-49ce-82f5-e5d92b0f49a5/details-on-sccm-collection-creation?forum=configmanagergeneral I have seen few cases in Configmgr 2007 and less in Configmgr 2012 due to RBA ,that Configmgr guys will try to do something on collection but it ends at something that causes the resources to disappear from…

Its always painful to check via reports for specific application if an assigned application successfully installed for Computer or User ,especially for GSD/helpdesk guys as they are the first point of contact for basic troubleshooting and they cannot always browse to default reports for such information and there is no straight report to give this…
SCCM Configmgr 2012 SSRS Dashboard Client Health Summary Report

Another Configmgr 2012 SSRS Report that brings Client Health Summary.This time,it will be a dashboard instead normal SSRS report.Dashboard is nice way to display multiple reports into one report.Dashboard reports are very helpful if you want to monitor the information about client health (mainly the Count),client hardware/software,operating system,IE versions etc.You can also link all these…
SCCM Configmgr 2012 How to change Custom Data source to Shared Data Source for multiple SSRS reports

Background: I had a requirement to not allow others except Configmgr admins to deny access to Configmgr 2012 Console, also to Configmgr SQL Database access (this can be done by revoking access from SSRS_Read Group.If the users are part of this group,they can install SQL and try to connect to configmgr database remotely to run…
SCCM Report Applications packages assigned to specific collection with user experience settings

Recently there was a question asked in the forum about 'How to get list of applications ,packages assigned to specific collection with its deployment settings like user experience ,Deployment action like install or uninstall etc' . If you are in need of identifying the list of applications or packages deployed to specific collection with its…
Configmgr SSRS Report Patch Compliance Statistics Last 30 days

Year ago,I created CM07 report to know the patch compliance stats for active patches last 30 days.More info can be found from here.But this report was for configuration manager 2007 which will not work with Configmgr 2012 due to the changes in storing the information in SQL tables/Views. I have created similar report for configuration…