Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

SD 5.1 Custom Reports

Highlighted
scsadmin1
Occasional Advisor

SD 5.1 Custom Reports

Need to create some custom reports. Can anyone provide some advice on the schema of the views used by SD 5.1

2 REPLIES
bpgraham
Collector

Re: SD 5.1 Custom Reports

The easiest way to do this is to define views in service desk. We use HP Openview Performance Insight which comes with a set of pre-packaged reports for service desk SLM, Change Management, etc.
Carol Hibbard
Honored Contributor

Re: SD 5.1 Custom Reports

There is a chapter on Reporting in the Admin Guide. Have you generated the database views and are you looking at them from your reporting tool? When viewing the database objects, note that all generated views have the prefix V_. These views make it easier to get access to the data for each entity vs going directly against the DB.

If you find a need to go directly against the SD tables, you can generate a data dictionary (from pg 194 of the Admin Guide):
System Settings ->Report Settings icon, Click the Generate Data Dictionary

You can print it or publish it to html files.
//Add this to "OnDomLoad" event