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.
Please have a look on the below .
The document is useful, but unfortunately I don't see what I'm looking for.
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.
Are there any more questions in regards to this discussion?
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
Hi, UMP based maintenance mode does not change the field.
The field is changed when you use IM based maintenance mode.
You might see this how to check affected device members.
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.
How to run a query to show devices in maintenance - CA Knowledge
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
Retrieving data ...