[Reporting on time spent in Service Manager]

Thanks.

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.

[Reporting on time spent in Service Manager]

Thanks.

In our sandbox test system I cant see that table in  the list of db tables in the report creation tool. Is the table not within the schema accessible by the sandbox?

Stephen

[Reporting on time spent in Service Manager]

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.