- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2019 10:53 AM
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
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2019 05:48 PM
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
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.
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:
Hope this help. Please mark the answer as helpful/correct based on impact.
Regards,
Shloke
Regards,
Shloke

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2019 11:28 AM
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
Thanks
Yash K.Agrawal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2019 11:45 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2019 11:32 AM
Hi,
You only want a report where you want to see duplicate incident where short description is same right?
Thanks,
Ashutosh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2019 11:41 AM
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