DX Unified Infrastructure Management

Hi,

I would like to know details of columns such as 'managed', 'monitored' and 'Maintenance'.
Though the names are self explanatory but I would like to know details such as what values are stored, how they're generated etc.

Regards

Abhishek

Please have a look on the below .

https://search.ca.com/assets/SiteAssets/TEC000003224_External/NISDatabaseBestPracticesGuidev11.pdf 

The document is useful, but unfortunately I don't see what I'm looking for.

Abhishek,

Don't think they are used any more. Think managed is a left over from the early nimsoft days, monitored can't remember, maintenance was moved to the maintenance_* tables. Think there values are always 0, 4, 0.

A db schema has not been made available.

https://comm.support.ca.com/kb/could-you-please-provide-us-the-db-schema-for-ca-uim/kb000017191

Abhishek,

Are there any more questions in regards to this discussion?

Hi David,

Sure, I have this query but it doesn't return any results.  I have put a robot into maintenance mode in the UMP but the query still doesn't return any results:

select * from cm_computer_system where maintenance = 1

Sam, would have been better to start your own thread on this. Your query is useless since as noted above maintenance is one of the columns no longer used and the functionality was moved to the maintenance tables.

Use this:

How to run a query to show devices in maintenance - CA Knowledge 

Thanks David,

Yes, I've just found that

This query is working perfectly:

SELECT distinct cmcs.name, ms.schedule_name, mw.start_time, mw.end_time from MAINTENANCE_WINDOW mw INNER JOIN CM_DEVICE cmd on mw.dev_id = cmd.dev_id INNER JOIN CM_COMPUTER_SYSTEM cmcs on cmcs.cs_id = cmd.cs_id INNER JOIN MAINTENANCE_SCHEDULE ms on mw.schedule_id = ms.schedule_id where mw.end_time > GETDATE();

Just trying to get a LUA script together to print the output so I can alert on it