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
Original Message:
Sent: 07-15-2019 09:11 AM
From: Rui Miguel Goncalves Dinis
Subject: SOI - Query all CIs in maintenance mode from the database
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