Report on Incident Template ?

[simonfurnish]

Hi,

We have Incident templates that we use in ITSM (Eureka). Does anybody know a way on how I can report on how many Incident templates have been used ?

Thanks

[vijivt]

Hi Simon,

Is this what you are looking for? A report on the incident templates used?

[simonfurnish]

Hi,

I don't appear to have those tables available for me to view in my system ? Can you confirm which Tables you have selected   (are they the ones in your screenshot)

Simon

[vijivt]

Hi Simon,

The template table name is   sys_template and you need admin access for it. You can ask your admin to create the report for that table. I checked this out on my personal developer instance.

In case you want to explain to your admin this is what I did.

System tables are not available for reporting so instead of selecting "Table" from the drop down list on Data field,   I selected the "Report Source" which I had created for the sys_template table.

On the Report Sources, you can provide the conditions like Active = true, Table = incident   or according to your requirement.

You can read more on system tables here : Reporting on System Tables - ServiceNow Wiki

[vijivt · Accepted solution]

Hi Simon,

Please check if you are able to do this :

1. go to the navigation filter and type sys_template_list.do, this should give you the list of templates

2. right click on header of the table column and select Bar chart, this will take you to the Create reports form

3. change the report type to List and run the report

Hope this helps