/build/static/layout/Breadcrumb_cap_w.png

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

0 Comments   [ + ] Show comments

Answers (6)

Posted by: dchristian 13 years ago
Red Belt
0
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]
Posted by: billythekid45 13 years ago
Senior Yellow Belt
0
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
Posted by: billythekid45 13 years ago
Senior Yellow Belt
0
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
Posted by: dchristian 13 years ago
Red Belt
0
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.
Posted by: billythekid45 13 years ago
Senior Yellow Belt
0
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
Posted by: Capt.Morgan 13 years ago
Orange Belt
0
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.
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ