How to retrieve deleted downtime job

[Goja]

Hi Experts,

My query is how can I retrieve deleted Downtime jobs from DB/CLI. Is there anyway to get.

I Dig into DB and found few tables under mgmt DB (DT_CIS,DT_CATEGORY,DT_CONTEXT.DT_CONTEXT_PROP,DT_DOWNTIME,DT_NOTIFICATION,DT_RECIPIENTS,DT_SCHEDULE) which contain all the information for downtime.
I am struggling with SQL Query to get information from the DB. I tried with query (select * from DT_DOWNTIME as d join DT_CIS as c on c.DT_ID=d.ID) OUPUT but I am unable to get proper details.

select * from DT_DOWNTIME as d join DT_CIS as c on c.DT_ID=d.ID

Output:

ID           CUSTOMER_ID   DT_NAME           DT_DESCRIPTION             PLANNED            APPROVER               CATEGORY_ID    CREATION_DATE              LAST_MODIFIED_BY        NOTIFICATION_ID               SCHEDULE_ID    DT_EXTERNAL_REF          DT_MANAGING_SYSTEM               LAST_MODIFIED_BY_USER           ID           DT_ID    CI_ID     VIEW_ID

0x05E8E101FA8B4B46A17DDC0E15A9739B          1             CHG0497755      Cisco router replacement because of the clock signal issue      1                            6               1541682429130.000000                0             0x9CFBC9F4346546B8AF964CBC4EB26B3C               0xB6A0709F68A64F8687C21BB72F76BC51                                          32d5ab2c-b41a-456b-9b7b-a447e2cdbae1        0x7D685166B44E4DCDAFB097D4D4D129AC               0x05E8E101FA8B4B46A17DDC0E15A9739B               0x8805284A099EDDA831F0A1EE266A6F46           Infrastructure_Common

I am looking for below fields from the above output.

Name(Change number)                 CI's(All the CI information which are in Change number.               Stats(Active,Inactive)       Scheduling           Next Occurrence.

Please help me how can I get this and another point how can I convert this time.

Thanks in advance

GOJA

[Edward_C_OMi1]

Hello Goja,

I hope you are doing well,

Did you try accessing from the JMX console and collect this information.

To do this please go to:
https://<FQDN>:29000/

Them go to:

Topaz

•  
• Topaz:service=DowntimeManager

After that please go to:

java.lang.String listAllDowntimesAsHTML

The customer ID is 1.

[Goja]

Hi Edward,

Thanks for your reply. yes the above infomration helps me on certain level. I am unable to get the CI information from the JMX. is there anyway to get CI information rather than CI ID's. Please see the result and m refering to coloum 9.

[Edward_C_OMi1]

Unfortunately from what I know, only the CI ID will show, once that the dowtime is configure all is handle by ID's.

[Goja]

Thanks Edward.

Any one else can share any thoughts on this topic.

Thanks,

Goja.

[SahilGupta]

Hello Goja,

What Edward said is true, you will get CI ID's from JMX for downtime.

However, if you need CI Name instead of CI ID's, you can pull a list of CI's and corresponding CI ID's from RTSM. Later, replace CI ID's with CI Names in Excel.

Regards,
Sahil Gupta

[Goja]

HI guys,

I could find the below information from the Mgmt DB but Still strugling to get information CID (I fI can the table name then I can play to join CID with CI name) and Status (I am unable to see this information in any of the DT tables). I am looking here to fidn this tables under Mgmt DB.

change Number(Values under DM)===>DT_Downtime (Table name)===>DT_Name(colum Name)
Modified By===>DT_Downtime===>LAST_MODIFIED_BY_USER
Start Date===>DT_SCHEDULE===>start_date - for this ID =  Schedule_ID of DT_DOWNTIME
end date===>DT_SCHEDULE===>end_date
Status===>??===>??
CI's===>??===>??

[gun339]

Hi Goja,

You can try by validating the audit logs. Follow the below path.

Administration > Setup and Maintenance > Audit Log

In the Audit Log context select Downtime/Event Scheduling and see if it works for you or not.

Regards

Gun