How to create a report of all incidents with the same Short Description

brysonelson
Kilo Contributor

Hello,

I am trying to create a report that pulls all incidents with the same short description and a state of "new".

I'm able to create a report that groups all incidents by their short description, however that report still includes all other short descriptions as well. 

I'm using the report creator in studio for this. 

Any tips?

Thanks

1 ACCEPTED SOLUTION

Hi,

 

Navigate to "Create New" module available under Reports Application menu and then follow the steps as mentioned below:

 

  • Under Data Tab Give a Report Name, then Select Source Type as "Table" and select the Table Name as "Incident"
  • Under Type Tab select the type of Report as "List"
  • Under Configure Tab select the columns you want to display and then use Group By as Number.
  • Give a Filter condition as "Short Description CONTAINS "Your Text" and State is New as shown below

find_real_file.png

The you can navigate to the module called "Scheduled Reports" as shown below and click on the New button if you want to automatically send this report to users.

 

find_real_file.png

 

Fill out the mandate fields like frequency of the report , recipient of the report and select the Report which you created above ans shown below:

 

find_real_file.png

 

Hope this help. Please mark the answer as helpful/correct based on impact.

 

Regards,

Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

5 REPLIES 5

Yash Agrawal1
Tera Guru

Hello brysonelson,

 

I just create a report with same short descrition .so i get all the short description with count that how many time a incident created with same short description. to check the count of every short description just hover the mouse from the bar u will get the count.

 and In Configure Tab just Uncheck the "Show Other" checkbox so you get only that incident which has short description repeated more than 1 . i displayed count on bar itself

I am also  attaching the screenshot for your reference.

 

 

Please Mark it correct if your work is done by my answer

find_real_file.png

 

find_real_file.png

Thanks 

 

Yash K.Agrawal

I only want to show incidents with the short description "Contract expires in one week". 

 

I don't want any other short descriptions included in the report, as I want to be able to email this report, so that I only have contracts that are about to expire included

Ashutosh Munot1
Kilo Patron
Kilo Patron

Hi,


You only want a report where you want to see duplicate incident where short description is same right?

 

Thanks,
Ashutosh

Ya, I want to see all incidents with the short description "Contract Expiring in One Week". That way I can send an email notification of all contracts that are about to expire. I don't want to include any other incidents in the report