DX Infrastructure Manager

Expand all | Collapse all

Details of Columns in CM_COMPUTER_SYSTEM table

  • 1.  Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 06-21-2018 04:58 AM

    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



  • 2.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 06-21-2018 05:24 AM


  • 3.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 06-21-2018 05:47 AM

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



  • 4.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 06-22-2018 08:59 AM

    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

     



  • 5.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 07-03-2018 12:38 PM

    Abhishek,

    Are there any more questions in regards to this discussion?



  • 6.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 11-19-2018 07:12 AM

    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



  • 7.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 11-19-2018 07:22 AM

    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.

    https://communities.ca.com/docs/DOC-231180390-tech-tip-maintenancemode-probe-behavior

     



  • 8.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 11-19-2018 08:21 AM

    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 



  • 9.  Re: Details of Columns in CM_COMPUTER_SYSTEM table

    Posted 11-19-2018 08:51 AM

    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