Regenerate a TAT (Temporal Aggregation Table) for TIBCO LogLogic SEM

Regenerate a TAT (Temporal Aggregation Table) for TIBCO LogLogic SEM

book

Article ID: KB0077539

calendar_today

Updated On:

Products Versions
TIBCO LogLogic Security Event Manager all versions

Description

The procedure below describes how to regenerate a TAT (Temporal Aggregation Table) for LogLogic SEM to include information from the alerts database if the initial TAT did not include this alert data.

Issue/Introduction

This article explains how to regenerate a TAT (Temporal Aggregation Table) for LogLogic SEM.

Resolution

To manually generate a TAT to comprise the time period between two dates, use this script:
  /usr/local/exaprotect/esms-setup/scripts/others/exa_report_scheduler.sh

with these options:

INSTANCE_NAME 'launching date' 'beginning date' 'ending date'

If you want the script to execute immediately, specify a "launching date" that is earlier than today's date.

For example, if you want to generate a TAT for the month of May (year 2006) and immediately launch the script on the TOTO instance:

/usr/local/exaprotect/esms-setup/scripts/others/exa_report_scheduler.sh TOTO '2000-01-01 00:00:00' '2006-05-01 00:00:00' '2006-05-31 23:59:59'

You will obtain these lines in your console:
[root@exabench2 root]# /usr/local/exaprotect/esms-setup/scripts/others/exa_report_scheduler.sh TOTO '2006-01-01 00:00:00' '2006-10-22 00:00:00' '2006-10-22 00:59:59'
clientName = TOTO

startDate = 2006-01-01 00:00:00
fromDate = 2006-10-22 00:00:00
toDate = 2006-10-22 00:59:59