Download SCCM Configmgr 2012 SQL Views Documentation

Configuration Manager Queries SQL Server views in the Configmgr site database when retrieving the information displayed in reports .Configmgr database contains large information about computer,User related resource and other components as well. If you are looking for some particular information while creating reports and if you are not sure which table the information has,you will…

When you are doing Migration from SCCM 2007 to SCCM 2012,you may want to remove some of the drivers which are no longer needed . This report list all the drivers which are part of any driver package so you can take action on them before you migrate to SCCM Configmgr 2012. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c82cc16a-06b7-49ae-ac11-2f6399047b6a…

Status of Specific Advertisement can get from Default available report but what if you want to find the status of specific advertisement with its LastAcceptanceStatusTime greater or less than X days. Full Details :http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/30e4dbda-982b-43dc-8665-8dd142925d4f DECLARE  @olddate datetime         ,@NullVal datetime SET @olddate = DATEADD(day,-5, GETUTCDATE()) select adv.AdvertisementName 'Application', sys.Name0 'System', LastAcceptanceStateName 'Acceptance', sts.LastAcceptanceStatusTime 'AcceptTime_GMT', sts.LastStatusMessageIDName…
SCCM Patch compliance Report Last 1 month for specific Collection

Update: SSRS Report for Configuration manager 2012 (all Versions) is available on http://eskonr.com/2014/02/configmgr-ssrs-report-patch-compliance-statistics-last-30-days/ In my previous blogs,I posted couple of reports for Patch compliance status based on the KB/MS ID numbers . SCCM Patch Compliance Progress report:  http://eskonr.com/2009/10/patch-status-compliancesoftware-updates-report-in-sms-sccm/ Software Update Compliance Status on Specific Collection : http://eskonr.com/2009/09/report-for-software-update-report-for-software-update-compliance/ SCCM monthly Patch statistics report http://eskonr.com/2011/10/sccm-monthly-patch-statistics-reports-to-the-management-in-a-simplified-manner/ This report is going to…

When you deploy software updates using SCCM/configmgr to clients ,patch status will be sent back to SCCM site.It is always good to know the Last state ID's and its state names for custom reporting. Below are the available Last state ID's and State Names. These state IDs do exist in SQL View called v_GS_PatchStatusEx .   LastState LastStateName…

Having multiple sites and checking the status of WSUS synchronization on all servers tedious job and child sites must sync with its parent sites to ensure right compliance levels from clients. This report will give you the status of WSUS server with Right content version. When SCCM sync with Microsoft Updates,Content version will get increment…

Sometimes I find Difficult to locate specific site from the Hierarchy(mostly if you are in large environment with many nodes) until you know where they attached to. I use the report data most of the times as reference to locate where the site resides based in its reporting site (primary) and primary site reporting to…