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,
Although the question is for Bhuvan, I would like to answer this.

Go to:

• Reports > Create New

Select:

• Source type: Table
• Table: Audit [sys_audit]

Apply Filters:

• Field name = Available
• Table = (your target table, e.g., sys_user_grmember)

Add Columns to Display:

• User (who made the change)
• Field Name
• Old Value
• New Value
• Updated on (timestamp)

Sort or Group by: Time or User as needed

Save and Run the report

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

Regards,
Shruti

[pampapathi1]

@Shruti D ,

Thank you for your response. I used the sys_audit table as per our last conversation, but I noticed that the updated and updated_by fields are not available.

Thanks,

Pampa

[Shruti D]

Hello @pampapathi1 ,

There is no "Updated" and "Updated By" fields on sys_audit table

You can refer the "User/Created by" and "Created" while creating the report / referring the Audit [sys_audit] table to verify

• Who made the change
• When it happened
  
  

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

Regards,
Shruti

[Ankur Bawiskar]

@pampapathi1 

I couldn't find that available field on sys_user_grmember table

Is that a custom field?

If it's a custom field then 1st of all that table is not audited

1) you need to enable auditing on that table

Enable Audit on Collection type of dictionary

2) then on your custom field enable auditing as well

-> repeat the same for your custom field

Then you can track changes done to that field over period of time

good explanation here

Configuring auditing for a table 

Exclusion list Auditing - How to activate/deactivate auditing for a specific table or field 

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