SOI - Query all CIs in maintenance mode from the database

[Rui Miguel Goncalves Dinis]

Hello All,

I have to create a report to show all the current CIs in maintenance in SOI, does anyone know the fields in the database to query?

thanks in advance,

Best Regards,
Rui Dinis
HCL-PT

[Brahmaiah Addepalli]

Hello Rui,

Please use this query to list CIs in Maintenance

select * from CI where Offline = 1

Offline = 0 --> Production
Offline = 1 --> Maintenance

Thanks
Brahma

[Rui Miguel Goncalves Dinis]

Thanks Brahma.