Jump to content

Which table contains data found in request timeline?


Recommended Posts

Good afternoon,

As title suggests, I'm trying to extract timeline data (update contents etc) for some reporting. Having a look through the schema designer the table I thought would contain what I need (h_itsm_requesthistupdates) doesn't contain any data apparently!

Any help would be greatly appreciated

Link to comment
Share on other sites

Hi Greg

What you are looking for is the following

select h_pk_reference,h_buz_activities.h_content from h_itsm_requests

RIGHT JOIN h_buz_activities

ON h_itsm_requests.h_activity_stream_id = h_buz_activities.h_target;

This will get you all of the posts in an activity stream associated to a request, you might also want to look in h_buz_comments as that contains all the comments made on each post.

Kind Regards

Trevor Killick

  • Like 1
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...