Reporting on time spent in Service Manager

[Stephen Banfield]

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.

[Martyn Houghton]

@Stephen Banfield

These are held within Timesheet manage app, specifically h_timesheet_values table.

Cheers

Martyn

[Victor]

Just to add on this topic, the tables mentioned by @Martyn Houghton are available if you also have the Timesheet Manager app installed in your instance...

[Martyn Houghton]

@Stephen Banfield

Just to follow up Victor update, the Time Sheet Manager app is a inclusive (free) app on the Hornbill Platform.

Cheers

Martyn

[Stephen Banfield]

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

[Martyn Houghton]

@Stephen Banfield

If you go into the Admin Tool and choose the '+ Add More Apps' option you should then be able to install the Timesheet Manager app. This will create the database tables when this install is done.

Cheers

Martyn

[Stephen Banfield]

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.