SCCM 2012 Debug Mode
There is a hidden feature that is built into the SCCM 2012 product. This will help aid in your troubleshooting steps.
First create a shortcut on your desktop for the ConfigMgr 2012 application.
Open the properties of the shortcut.
At the end of the line add SMS:DebugView
Launch the application and you will now notice a new “Tools” on the WonderBar.
Click on Tools and you will have additional troubleshooting options. You will be able to select a class, ref patch and a type of query to troubleshoot.