Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Search for | Example | Results |
---|---|---|
A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Search for | Operator | Example |
---|---|---|
Two or more words in the same topic |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
- Data persistence
- Database dictionary
- Keys and indexes in Service Manager
- Data maps
- Exporting records
- Importing records
- Unload script utility
- Purging and archiving records
- Add, delete or update a master data record
- Database record auditing
- Invoke auditing
- Invoke auditing from the file in Database Manager (Change Management only)
- Start database record auditing
- Test Audit Lookup functionality
- Audit processing
- Determine if a file has audit processing
- Audit log file
- Verify the field name
- Verify the file name
- Add an audit specifications record
- Open the audit specifications table
- Define an audit specifications entry
- Audit specifications file
- Audit specifications file description
- The Subroutines form
- IR Expert
- Record retrieval
- Queries
- Database performance tuning
- Running the database maintenance utility
Database record auditing
Database record auditing allows you to check the Service Manager database for modifications to specified fields within a file. When you update records in a file, record auditing tracks the updates when Paging is not available, whereas Paging creates a unique record or page for every update.
Database Manager detects field modifications by comparing the input values in fields from the original version of a record to the values of the same fields in the updated version. When a modification is detected, Database Manager generates an Audit Log entry containing the following information:
- The name of the modified fields.
- The old and new version of the data.
- The date and time of the modification.
- The user ID of the operator who modified the record.
Related topics
Audit log file
Audit processing
Audit specifications file
Start database record auditing
Add an audit specifications record
Add lookup functionality to Format Control
Define an audit specifications entry
Invoke auditing
Open the audit specifications table
Set up event triggers
Test audit lookup functionality