Jump to content

Reporting on time spent in Service Manager

Stephen Banfield

Recommended Posts

We are in the process of migrating from Supportworks to Service Manager.

Currently I do queries on the updated table to see how much time a member of my staff spends on a call. Can anyone advise on where the equivalent information is stored in the Service Manager database?

Thanks Stephen.

Link to comment
Share on other sites


I  am just trying to understand the relationships between tables in the new version of your software.

1) If say I wanted to work out how much time somebody in my team spent on a particular call how do I link the time  to a call?

2) Is h_timesheet_values the only table used in recording time? For example, is there a separate table for recording time on tasks as opposed to general updates?

3) Previously I used to for the most part to run queries on the opencall and updatedb tables. As I understand it h_itsm_requests is the equivalent of opencall, what is the equivalent of updatedb?

Thanks again.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...