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

[Shruti D]

Hello @pampapathi1,

Please refer the  https://www.servicenow.com/docs/bundle/zurich-platform-security/page/administer/security/task/t_Enab... 

To audit the available field: Navigate to System Definition > Dictionary.

Filter by: Table = sys_user_grmember         Column name = available

Check the box "Audit" and set it to True.

To check the audit history,

Option 1: Via the sys_audit Table (Backend)

Filter by:

• Table = sys_user_grmember

• Field name = available

Option 2: From the Record Itself

• Go to a sys_user_grmember record.

• Right-click the header (or use the context menu).

• Choose "History > List".

• This will show:

  • Who made the change

  • When it happened

  • Before and after values
    
    

Please Mark Correct ✔️ if this solves your query and also mark Helpful 👍 if you find my response worthy based on the impact.

Regards,
Shruti

[Bhuvan]

@pampapathi1 

By default this table is not audited. You can enabled audit for the table or enable audit for specific fields in a table.

Follow below link to enabled audit that would capture the changes going forward but there is no way to track past historical changes,

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

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

Thanks,

Bhuvan