Jump to content

Service Manager - Reporting on Updates


Recommended Posts


We need to be able to report on how many times requests have been updated by a customer via the service portal. Previously, in Supportworks, there was updatedb table which enabled us to report on this.

Is there a similar table in Service Manager we can use for this?



Link to comment
Share on other sites

Hi @Lauren All updates on a request are written to the h_buz_activities table.  You can join the h_itsm_requests table on the activity stream id and the target id from the h_buz_activities table.  What you will then need to do in order to limit the count to only those of the customer, you can filter the results matching the customer id in the request table with the actor_id in the h_buz_activities table.  The user id's are in slightly different formats in these two tables so you will need to use CONCAT to match.

I have attached a simple report example which does the above and prompt for the request id when running the report, so the results returned are a count of the customer updates on that specific request (when joining tables etc and large data sets we need to be mindful of load / performance etc, hence the request prompt), of course you could but in date ranges etc to limit the results returned. 

Hope that helps




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...