DX Unified Infrastructure Management

Hi everyone.

I need to know what is the table that contains devices in CAUIM because the customer needs know how many devices are active and which devices in maintenance.

I think obtaining this number with query to CA UIM db, but I do not know what is the table and how to discriminate what are they activate and what they are in maintenance

My DB are in MSSQL 2014

Best Regards

M.E

M.E. -

The CM_COMPUTER_SYSTEM table contains all of the discovered devices that are active.  If you are using the Monitoring tab to put devices into maintenance, then you following Knowledge Document will give you queries to identify the set of devices in maintenance:

KB000033948 : How to run a query to show devices in maintenance mode

Hope this helps.

Thank you vey much Kathryn. Other question:

The devices that are in maintenance, should appear in CM_COMPUTER_SYSTEM table?

M.E

M.E -

Yes the devices in maintenance should also be found in the CM_COMPUTER_SYSTEM table as well.  There is no indication in this table that they are in maintenance though.