Search all tickets updated by members of assignment group

[Lartiste]

Hi guys,

I want to search in all tickets a member of assignment group when a ticket is updated.

Now, I search with reports, the field "updated by" for find all tickets updated by one of members of my group but I don't know if the tickets founded is all tickets updated.

Can you help me please ?

Thanking you for advance

[Tony Chatfield1 · Accepted solution]

Hi, sys_updated_by identifies the last user to update a record, if someone other than your group users was the last to up the record then it will not appear in your report.

[Lartiste]

Hello Tony, Thanks for your response. If I can't found it in a report, what do I do ? I want to found all tickets Who one of user of my group updated in a incident (even if the action isn't the last update).

[Tony Chatfield1]

You can find details of user updates to tasks in the sys journal and audit tables,
but I would strongly recommend that you do not query\report on these tables as your platform performance may be degraded.

If you need to report on this sort of information, then you should be using the OOB functionality that is designed to deliver this behaviour 'Metrics'

https://docs.servicenow.com/bundle/paris-platform-administration/page/use/reporting/concept/c_MetricDefinitionSupport.html

[Lartiste]

Re up