Hi All,
I must be missing something simple. I'm just trying to run a report on tickets that haven't been updated in 10 days. I don't see an attribute or category that accomplishes that. Can anyone tip me off on how to run one?
Thank you
Hi All,
I must be missing something simple. I'm just trying to run a report on tickets that haven't been updated in 10 days. I don't see an attribute or category that accomplishes that. Can anyone tip me off on how to run one?
Thank you
You can't do this with a ticket search, as it doesn't give you "Updated" as a field to filter on, but you can do this with a report.
Create a new ticket report, table is best for this, set the category to be what you want (e.g., department, company, location, whatever you use), choose Tickets as the table data and the time period should be Relative From (leave blank) To: 10 Business Days ago and set the Date Attribute for Time Range to be "Date Worked On."
You'll need to setup filters for the report to exclude all of your "Closed" status (or if it's easier in your setup, Include all of your "Open" statuses). That way, you're only getting the list of still OPEN tickets that haven't been worked on in the past 10 days.
UPDATE: Nevermind, this one still includes tech updates more recent than the 10 days. This report includes tickets worked on more than 10 days ago, but still includes them in the report if they have been updated since. Just looking for the tickets that haven't been worked on.
Thank you for your help. It works. I am reviewing this by technician, so i figured I would put the details of the report I use in case it will be helpful down the road for another.
Chart Type: Table Only
Row Category: Assigned Tech
Table Data: Tickets
Time Range From: Past to 5 Days ago (I reduced to 5 days from original post)
Date Attribute: Date Worked On
For my filters I updated my statuses (Status) to EXCLUDE all closed/resolved type status. I filtered (Assigned Tech) to include only the technicians that report to me instead of all IT.
Thank you
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.