Notification Store Query

[Raghuvir]

Hi All,

i have configured a notification store database in the cognos configuration. the tables created in the database hold the information related to the schedules in cognos coneection.

can anyone help me to track the table name which holds the information for the status of the scheduled reports, for example i want to track down reports which have failed during execution.

thanks in advance.

Regards

[AussiePete2011]

Hi there

I ran this type of query against the Audit database

SELECT *
FROM COGIPF_USERLOGON,     
         COGIPF_RUNREPORT
   WHERE     COGIPF_RUNREPORT.COGIPF_SESSIONID = COGIPF_USERLOGON.COGIPF_SESSIONID
         AND COGIPF_RUNREPORT.COGIPF_SESSIONID = COGIPF_USERLOGON.COGIPF_SESSIONID

This should be modified with a data range like
***Oracle Syntax where you can change 0 for any number of days prior to current.
TRUNC (COGIPF_RUNREPORT.COGIPF_LOCALTIMESTAMP) BETWEEN TRUNC (
                                                                         SYSDATE
                                                                       - 0)
                                                                AND TRUNC (
                                                                       SYSDATE)

There are other means but see what you think

Cheers
AussiePete