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

service desk reporting through crystal reports

Highlighted
SWATI SHARMA
Collector

service desk reporting through crystal reports

Hi

I hav SD4.5 sp23 and using crystal report2008.
I want to generate report like this:Suppose there r ten servers and 2 routers,i hav to make report stating that what is the total duration of time in the last month,each one is down.
ie the total time period of each router and server whn they r down.
1 REPLY
-=R=-
Frequent Visitor

Re: service desk reporting through crystal reports

First you have to make sure of the following

1) On your incidents actually have a hard link to those CI's (if indeed they're stored in your CMDB).

2) Your incidents must track an outage time. If you're not autopopulating incidents via monitoring software, and you're not getting the data manually from people logging incidents, then the only resort is to do a datediff on the actual start / actual finish fields.

Once you've ensured those two things you build a report like this...
Selection criteria: Select only the CI's you mention above with a time period
Details: Incident #, CI, "Duration" (however you're determining the second point above)
Grouping: Probably by CI
Summary: Sum the "duration" field for each CI
//Add this to "OnDomLoad" event