1. Hosts offline:
I was thinking to write a report of all offline devices so that I sent it to team as a reminder to them to remove those assets from OCI. I referred inventory DM. Just for the testing purpose I pulled host name and fc port's "is active". But result is only showing all online hosts even when I have some hosts which are offline and I can see them in OCI java UI. May be the reason is Inventory DM have latest data. Then which DM can provide me the data I am looking for?
2. Audit Report
I can see the audit page from web UI and see time, user, role, ip, action and details of each activity. I need similar thing from schedule report. I almost explored all DBs in DWH server but not able to find revelent DB or table to provide that info.