How to generate an Incident report?

[porknan]

Hi,  

I hope someone can help me with this.

I am trying to create a couple of reports through ServiceNow but am struggling a bit!

I would like a fairly simple report that shows the following:

• My average ticket volumes per month (for Incidents/Service Requests and change request)       Would this have to be 3 different reports?
• How are the above tickets split by category?

Thanks

Stuart

[Rajesh T]

Okay. you can create one database view (Nothing but custom table)   to combine all three tables to fetch data in single reprot .

For more info

http://wiki.servicenow.com/index.php?title=Database_Views#gsc.tab=0

Reporting against two tables Incident and Task (Database view)

Thanks,

Rajesh T

[porknan]

that sounds complicated.

I am happy to create a report for each area.. just need help to do it.

[Varuna]

Hi,

You can use the Task table, which is the parent of incident, change and requests.

You can group these based on 'Task Type' - incident , Requested Item and Request for Change

PS: Please mark helpful or like if this helped you.

Regards,

Varuna

[porknan]

Thanks for this.   Can you help me with this a little further as I think this could be what I need

[Varuna]

you can have filter conditions - 'assigned to'- you and 'assigned' -date assigned.