DX Operational Intelligence

Expand all | Collapse all

Column and table name of created and last updated time

  • 1.  Column and table name of created and last updated time

    Posted 07-12-2018 06:43 AM

    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



  • 2.  Re: Column and table name of created and last updated time

    Posted 07-12-2018 10:55 AM

    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



  • 3.  Re: Column and table name of created and last updated time

    Posted 07-13-2018 02:48 AM

    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