CA Service Management

 View Only
  • 1.  Report of services with a 24x7 maintenance window

    Posted Apr 15, 2016 11:44 AM

    I have to create a report that lists all services with a maintenance window of 24x7.

     

    I think this information on SDM is here:

     

    I can do this either in Xtraction or straight from the Oracle DB, but I don't know where this information is stored in. Can anyone point me to the right direction?



  • 2.  Re: Report of services with a 24x7 maintenance window

    Posted Apr 25, 2016 01:28 AM

    You can find the maintenance window information on the "window" object (table usp_window) and the connection between CIs and maintenance windows on the "ci_window" object (table usp_ci_window).