What is sys_prefix

[test62]

Hi Community,

I have a question regarding the term "sys_prefix" mentioned in the following documentation: https://www.servicenow.com/docs/bundle/yokohama-platform-security/page/administer/system-logs/task/t...

I tried looking for this field/attribute in the "sys_db_object" table, but I was unable to find any information. Could anyone clarify what this represents?

Best regards,

[Anand2799 · Accepted solution]

Hi @test62 ,

This is not an attribute in the table. As per the document the table starts with "sys_" prefix are not audited by default. 

If you want to enable auditing for any of this table you can update the property "glide.ui.audit_deleted_tables" and add table name

The tables start with "sys_" prefix are system tables (E.g. sys_user, sys_user_group, sys_log).

Thanks

Anand

[test62]

Hi, @ Anand2799 

Thank you for your quick reply.

To audit record deletions for custom tables (e.g., those with a prefix starting with "x_"), should the table names be added to the property?

[Anand2799]

Hi @test62 ,

No, this property is only for system tables. 

To enable auding in any table other than system refer below document:

Configuring auditing for a table

Thanks

Anand

[Chaitanya ILCR]

Hi @test62 ,

When they mention sys_prefix, they are referring to tables with the "sys_" prefix.

By default, the system excludes tables whose names start with "sys_" (system tables) from auditing.

If you need to track or capture deletions on these tables, you must add the table name to the property glide.ui.audit_deleted_tables. However, this is generally not recommended because these tables typically contain a large volume of data.

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya