Query Panel

Use the Query panel to build queries that search the TM1® audit log.

The Query panel toolbar contains a Run Query icon Run Query button to query the audit log after you set the query options.

The query options are organized into the following groups:

Date and Time
Event Owner
Event Type

Date and Time Options

The Date and Time options include set the time period that you want to query.

Option	Description
Time Period	Contains a list of predefined time periods for the query. Select a predefined time period or select Custom Time Period to enable the Start and End time options.
Start Time	The start date/time for the query. This option is enabled only when you select Custom Time Period for the Time Period option. TM1 queries against all records written to the audit log on or after this date/time. Click to open the calendar tool where you can select a date and time.
End Time	The end date and time for the query. This option is enabled only when you select Custom Time Period for the Time Period option. TM1 queries against all audit records up to the end time you specify. Click the Calendar icon to open the calendar tool where you can select a date and time. The default end time is the current date and time.

Option

Description

Time Period

Contains a list of predefined time periods for the query.

Select a predefined time period or select Custom Time Period to enable the Start and End time options.

Start Time

The start date/time for the query.

This option is enabled only when you select Custom Time Period for the Time Period option.

TM1 queries against all records written to the audit log on or after this date/time.

Click Calendar button to open the calendar tool where you can select a date and time.

End Time

The end date and time for the query.

This option is enabled only when you select Custom Time Period for the Time Period option.

TM1 queries against all audit records up to the end time you specify.

Click the Calendar button Calendar icon to open the calendar tool where you can select a date and time.

The default end time is the current date and time.

Event Owner Options

The Event Owner options answer the question "Who caused this event". The owner of the event can be an actual TM1 user or a scheduled chore.

The Event Owner options include the following parameters:

Option	Description
All	Sets the query to search for audit events caused by any TM1 user or scheduled chore.
Client	Sets the query to search for audit events caused only by TM1 users. To search for events caused by a specific TM1 user, click the Select Client button . You can select a single client or multiple clients. The default is all clients.
Scheduled Chore	Sets the query to search for audit events caused only by scheduled chores. To search for events caused by a specific scheduled chore, click the Select Scheduled Chore button . You can select a single scheduled chore or multiple scheduled chores. The default is all scheduled chore.

Option

Description

All

Sets the query to search for audit events caused by any TM1 user or scheduled chore.

Client

Sets the query to search for audit events caused only by TM1 users.

To search for events caused by a specific TM1 user, click the Select Client button . You can select a single client or multiple clients.

The default is all clients.

Scheduled Chore

Sets the query to search for audit events caused only by scheduled chores.

To search for events caused by a specific scheduled chore, click the Select Scheduled Chore button . You can select a single scheduled chore or multiple scheduled chores.

The default is all scheduled chore.