Help Needed to Track History of "Available" Field in sys_user_grmember Table

[pampapathi1]

Hi Team,

I have a query regarding how to track changes to the "available" field in the sys_user_grmember table, specifically:

• Who enabled or disabled the field
• When the change occurred (timestamp)
• How to view the full history of updates

I created a report directly using the sys_user_grmember table, and while it shows the last updated timestamp and updated by user, it seems to only reflect the most recent change. I need to track all historical changes to this field, including who made each change and when.

Could someone please guide me on how to properly audit or report on this field's history?

Thanks in advance for your help!

Best regards,
Pampa

[Bhuvan]

@pampapathi1 

Create a audit on the table for specific field 'Available'. Once audit is configured, any changes to the field will be tracked in sys_audit table. Follow below steps to enable audit for only specific field in a table,

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0723730

You can create a list view [or any visualization type that suits] on sys_audit table and filter to show changes to specific field by creating filter conditions as per your requirement. Below is a sample,

By default, some of the system tables are not allowed for reports or dashboards. sys_audit table is allowed by default. If sys_audit table does not show under reports or dashboards, check below property and make sure sys_audit table is available in allowed list

Since you are creating auditing only for 1 field on a table, there should not be any performance impact. As a best practices, when you enable auditing keep it to minimum and only for required fields mandated by business requirements.

I hope you appreciate the efforts to provide you with detailed information. If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Bhuvan]

@pampapathi1 

Did you get a chance to review this ?

If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Ankur Bawiskar]

@pampapathi1 

First of all that field is not available on sys_user_grmember table

Did you get a chance to check my below response?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[pampapathi1]

@Ankur Bawiskar ,

Thank you for your valuable response. I would like to clarify that the "Available" field is a standard field defined in the dictionary entry and not a custom field. We are specifically looking to generate a report that shows who checked or unchecked the "Available" field in the sys_user_grmember table, along with the corresponding timestamp of the update.

Could you please guide us on how to achieve this?

Please find the screen shot for your reference.

[Ankur Bawiskar]

@pampapathi1 

sorry but that field is not available in my instance.

that's fine, the approach still remains the same which I shared about enabling audit on table and that field.

If my response helped please mark it correct and close the thread so that it benefits future readers.