Time until owner no longer = unassigned
Hello all,
We need a report that tracks the time a ticket was in the unassigned queue until it was assigned to an owner. The problem I am having is the results are based on the live data. We would like to report on historical data vs live data which is the part that is tripping me up.
Thanks in advance guys!
-Brad
We need a report that tracks the time a ticket was in the unassigned queue until it was assigned to an owner. The problem I am having is the results are based on the live data. We would like to report on historical data vs live data which is the part that is tripping me up.
Thanks in advance guys!
-Brad
0 Comments
[ + ] Show comments
Answers (6)
Please log in to answer
Posted by:
dchristian
13 years ago
I think I'm missing something....
What differentiates live data from historical data?
Also have you taken a look at the response time report from the support site?
[link]http://www.kace.com/support/kb/index.php?action=artikel&cat=64&id=688&artlang=en[/link]
What differentiates live data from historical data?
Also have you taken a look at the response time report from the support site?
[link]http://www.kace.com/support/kb/index.php?action=artikel&cat=64&id=688&artlang=en[/link]
Posted by:
billythekid45
13 years ago
Thanks for the link David, I'll check it out.
The historical data I am referring to is when the ticket was the dflt owner “unassignedâ€Â. If I run a query using the report wizard I get results based on current ticket owner instead of the previous ticket owner of “unassignedâ€Â.
We are trying to generate a report that tracks how long a ticket had the owner “unassignedâ€Â. I tried to use the report wizard specifying “owner IS NULL†but it only reports on current tickets instead of (historical) all tickets. Since only a few tickets have the owner “unassigned†it will only provide the tickets that currently have the “unassigned†owner.
Am I being unrealistic in wanting this in a report format?
-Brad
The historical data I am referring to is when the ticket was the dflt owner “unassignedâ€Â. If I run a query using the report wizard I get results based on current ticket owner instead of the previous ticket owner of “unassignedâ€Â.
We are trying to generate a report that tracks how long a ticket had the owner “unassignedâ€Â. I tried to use the report wizard specifying “owner IS NULL†but it only reports on current tickets instead of (historical) all tickets. Since only a few tickets have the owner “unassigned†it will only provide the tickets that currently have the “unassigned†owner.
Am I being unrealistic in wanting this in a report format?
-Brad
Posted by:
billythekid45
13 years ago
I created the report from the Kace support site (the link suggested above) but it doesn't quite satisfy our requirements. Does anyone have any other suggestions? [8D]
-Brad
-Brad
Posted by:
dchristian
13 years ago
brad,
Ok i get what your looking for.
I would take a look at the HD_TICKET_CHANGE table and look for the event owner changed.
You should be able to compare this time with the ticket creation time and be good to go.
Ok i get what your looking for.
I would take a look at the HD_TICKET_CHANGE table and look for the event owner changed.
You should be able to compare this time with the ticket creation time and be good to go.
Posted by:
billythekid45
13 years ago
Thanks for the direction but sadly the HD_TICKET_CHANGE table doesn't have an event for owner changed.
Would there be any other way around it?
-Brad
Would there be any other way around it?
-Brad
Posted by:
Capt.Morgan
13 years ago
Actually it does. It is under Description.
If you can write a Query to look for 'Changed ticket Owner from Unassigned to' and grab the time stamp you are set.
If you can write a Query to look for 'Changed ticket Owner from Unassigned to' and grab the time stamp you are set.
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.