Database View based on sys_audit table

[Thomas G]

Hi,

I know that it is not best practice reporting on the sys_audit table but I am trying anyway 😉

I have this Database View:

I guess I need to add sys_audit table more than once because 'newvalue' holds both group and user sys_ids depending on the Field Name(?).

Then I have created a report based on this Database View and it is almost working. However, it can not show both the name of assigned to and group name at the same time. It is either assigned to or group name and I can't figure out why. Can you?

Best regards
Thomas

[Kieran Anson · Accepted solution]

As an FYI, if you haven't looked already, OOB there are metric definitions that track assigned to and assignment group in the metric_instance table for incidents. That should generate the same data as using sys_audit.

[Thomas G]

Hi Kieran,

I did not knew that those were there OOB. I will have a look at them instead, and thanks for the heads up 😉

Best regards
Thomas