| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Audit.Statistics
Queries statistics for Audit functions.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Audit | 12.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Audit.Statistics" )
Parameters
none
Result
Returns JSON or error.
Description
Queries statistics for Audit functions.Values are returned as JSON.
| Calls | Number of Audit.Changed, Audit.Changed2, etc. calls. |
| Records | Number of records checked. |
| Fields | Number of fields checked. |
| InsertErrors | Number of times the Inserts to AuditLog table failed. |
| GetFieldErrors | Number of times calls to GetField() failed. |
| GetCountErrors | Number of times calls to Count() failed. |
| FieldTypeErrors | Number of times calls to FieldType() failed. |
| SelectValueErrors | Number of times calls to SELECT to get old value failed. |
| SchemaTables | Number of times schema got queried for tables. |
| SchemaFields | Number of times schema got queried for fields. |
| SchemaErrors | Number 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
- Added Audit.Statistics function.
Example Databases
Blog Entries
- MBS FileMaker Plugin, version 12.2pr1
- New in MBS FileMaker Plugin 12.1
- Neues MBS FileMaker Plugin 12.1
- MBS FileMaker Plugin 12.1 - More than 6700 Functions In One Plugin
- MBS FileMaker Plugin, version 12.1pr6
This function checks for a license.
Created 2nd March 2022, last changed 2nd March 2022
