Your company's ad could live here and reach over 50,000 people a month!

Share This Post

Sccm – Add a description to the error code in sccm reports

In some of the reports in sccm the result will display a error code for troubleshooting purpose, but often they dont provide any description about this error code. So here’s a example on how you can get more detail on these errors. Note that in this example I will use a report on Software update – client health report.

1- You must download the following file, convert it to csv, replace all the comma by two single quote, import the file as a flat file in your sccm database, then assign the appropriate permission on the newly created table.

– Download Custom ConfigMgr Error Code document;

https://skydrive.live.com/?cid=80514c55d60387d4&id=80514C55D60387D4%211522

2- Create a reports with the following SQL Query (make sure to change ConfigMgr_Error_Descriptions to reflect the newly created table);

Query 

Original Post ; http://anotherblabla.wordpress.com/2012/03/23/sccm-add-a-description-to-the-error-code-in-sccm-reports/

References;     http://blogs.msdn.com/b/shitanshu/archive/2010/10/09/part-4-sql-queries-for-creating-configuration-manager-client-health-and-problem-management-dashboard.aspx

 

Share This Post

Leave a Reply