Creating and running queries

Use search parameters in the Query panel of the Audit Log window to narrow your search.

1. Set the Date and Time option.

   This option includes pre-defined time periods including today, and the last 10, 30, 60 and 90 days.

   If you are looking for events from a specific time period, select Custom Time Period from the Time Period drop-down box. Enter a start and end time.

2. Set the Event Owner option.

   This option asks the question "Who caused this event?" This can be an actual TM1® user or a scheduled chore.

   • Click All to search for events caused by any user or any scheduled chore.
   • Click Client to search for events caused only by a user.
   • Click Scheduled Chore to search for events caused only by a scheduled chore.

   To select a specific user or scheduled chore, click the Select button next to the related field.

   The Select Client or Select Chore dialog box opens.

   • To select an individual user or chore name, click the item.
   • To select an adjacent range of user or chore names, click the first item in the range, hold down SHIFT, and click the last item in the range.
   • To select multiple nonadjacent user or chore names, hold down CTRL and click each item.
3. Set the Event Type option.

   Use this option to select the exact type of event for which you want to search. For example, "find unsuccessful login attempts" or "find events where a dimension was deleted".

   • Click All to search for both types of audit events; system-wide and object related events.
   • Click System-wide to search for only system-wide audit events.

     To search for a specific system-wide event, select the event from the Event list.

     The default setting, *, searches for all system-wide events.

   • Click Object to search for events related to only TM1 objects.

   The Object option has the following sub-options:

   • Set the Object Type option to limit the query to only a specific type of TM1 object. For example, events related only to dimensions.
   • Set the Object Name option to find events for a specific object name.
   • Set the Event option to search for a specific object event.

     The list of events changes depending on which type of object you select in the Object Type drop-down box.

   Click the Select Object Name button next to the Object Name field to display a dialog box where you can select objects by name.

   • To select an individual object name, click the item.
   • To select an adjacent range of object names, click the first item in the range, hold down SHIFT, and click the last item in the range.
   • To select multiple non-adjacent object names, hold down CTRL and click each item.

   Note: When you set Object Type to Element, the Select Object Name button becomes disabled because the element list could be too large to display. If you want to search for events related to a specific element, you must manually enter an element name using the following format:

   DimensionName:ElementName

   For example: region:italy

4. Click the Run Query button .

   The records retrieved by the query appear in the Results panel grid.