System Center 2012 Service Manager Knowledge Management report

In one of our previous posts, we presented a knowledge management report based on the OLAP cube. In this post, I provide management packs required to create a report that utilizes Reporting Services.

The management packs consist of two files:

1. SCUtils.KBArticle.DW.Library.mp
2. SCUtils.KnowledgeManagement.Report.mpb

The first management pack contains definitions for Service Manager Data Warehouse. The management pack has been created using a free utility SCUtils DWMPCreator (use this link for the details). The second management pack holds the report named List of Knowledge Articles with User Rate. 

The report’s headers are presented on the next screenshot.

I have to note that out-of-the-box Microsoft System Center 2012 Service Manager lets to access the knowledge articles and leave comments only in the console. That significantly limits the helpfulness of the features. Using SCUtils Knowledge Base add-on you can overcome this annoying limitation. The information about that and many other features of SCUtils Knowledge Base you can find on the product’s page.

Download Knowledge Management report