Column and table name of created and last updated time

[MrOkik]

Hello Everyone,

 

I had a request from My Customer and they want to do some customized reporting to get current active alarms.

 

I would like to know which table and column name to store Created and Last updated time? I ran the query from table Alerts but (ReportedTime, LoggedTime, RetireTimeStamp) it shows difference value.

 

Does anyone having experience in the database SAMStore.

 

Thanks and Regards,

Okik Setianto

[Brahmaiah Addepalli]

Hello Okik,

 

These values are coming from Alerts table from SAMStore DB

 

LoggedTime:                      Time when SOI gets the alert (Last Update column in the console)

ReportedTime:                 Time when the alert occurred (Created column in the console)

ClearedTime:                     Time when the alert was cleared

 

 

Created: column represents the time when the alert was created in MDR in other words...Time when the alert is occurred in MDR (Ex: Spectrum, Nimsoft etc)

=> This column is mapped to 'ReportedTime' column in the 'Alerts' table in SAMStore DB

 

Last Updated: column represents the time when alert was received at SOI or Time when SOI gets the alert

=> This column is mapped to 'LoggedTime' column in the Alerts table

=> This column will be updated for any alert update be at MDR or SOI

 

Note: "LoggedTime" and "ReportedTime" are in GMT

 

Regards

Brahma

[MrOkik]

Hi Brahma,

 

Thanks for the reply. I already checked the LoggedTime and ReportedTime but it shows difference value between SOI Console and Alerts Table. Please see below picture:

 

DB:

 

Logged Time July, 22th 2018

 

SOI:

Last Updated July 13th 2018

 

Do you have any ideas for this?

 

Thanks,

Okik