Timespent values in database
Hi,
I need to pull the timespent values from the SD database into our reporting tool. I have found these tables; servicedesk.public.wo_assessment
servicedesk.public.wo_status_info
I can't work out how the database holds timespent by a status if the ticket is still open. I have attached an example which shows the timespent value for 2 status' but the last doesn't have a value, I gues because it's still open. Where can I find the "counter value" the tool uses to display it?
Thanks,
Lee
I need to pull the timespent values from the SD database into our reporting tool. I have found these tables; servicedesk.public.wo_assessment
servicedesk.public.wo_status_info
I can't work out how the database holds timespent by a status if the ticket is still open. I have attached an example which shows the timespent value for 2 status' but the last doesn't have a value, I gues because it's still open. Where can I find the "counter value" the tool uses to display it?
Thanks,
Lee