Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.5   11.0   11.1   11.2   11.3   11.4   11.5   12.0   12.1   12.2    Statistic    FMM    Blog  


Queries statistics for Audit functions.

Component Version macOS Windows Linux Server iOS SDK License
Audit 12.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes Paid
MBS( "Audit.Statistics" )




Returns JSON or error.


Queries statistics for Audit functions.
Values are returned as JSON.

CallsNumber of Audit.Changed, Audit.Changed2, etc. calls.
RecordsNumber of records checked.
FieldsNumber of fields checked.
InsertErrorsNumber of times the Inserts to AuditLog table failed.
GetFieldErrorsNumber of times calls to GetField() failed.
GetCountErrorsNumber of times calls to Count() failed.
FieldTypeErrorsNumber of times calls to FieldType() failed.
SelectValueErrorsNumber of times calls to SELECT to get old value failed.
SchemaTablesNumber of times schema got queried for tables.
SchemaFieldsNumber of times schema got queried for fields.
SchemaErrorsNumber of errors related to schema queries.

If things run normally, the error counts should be all zero. Calls should be higher than records.
Since we cache schema information, the SchemaTables and SchemaFields numbers should not change except every few minutes.

See also

Release notes

  • Version 12.2
    • Added SchemaCacheFlushed counter for Audit.Statistics function to show how often we flushed the table cache.
  • Version 12.1

Blog Entries

Created 2nd March 2022, last changed 2nd March 2022

Audit.SetUUIDField - Audit.TableIDForName

Feedback: Report problem or ask question.

Start Chat