Which table contains data found in request timeline?

[IntegraGreg]

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

[TrevorKillick]

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

[IntegraGreg]

Hi Trevor,

Many thanks, that was exactly what I was looking for!

Have a good weekend.