How to extract/report on the Comments people leave on Updates in the Timeline

[Berto2002]

I have a report which draws-out the latest Update (buz activities) on a Request and presents it alongside the Request ID and other information. It has the following joined tables:

The data goes into PowerBI which filters and displays the Activity content information if the User who added the Update has a Job Title (this effectively excludes sys_bpm_manager updates:

Now, an end User might make a Comment against an existing Timeline entry and my question is where/how are those comments stored in the database so I can add them in to my scheme also?

Any help appreciated.

[AlexTumber]

@Berto2002 the table where comments is stored is called h_buz_comments.

The foreign key in this table is h_activity_id. This should give you what you need to create your additional join.

Alex