How to query the list of device that has been discovered by CA UIM on the Database

Document ID : KB000122882
Last Modified Date : 11/12/2018
Show Technical Document Details
Introduction:
How to query the list of device that has been discovered by UIM on the Database?
Like Firewall, Switch and Any of device that been discovered by SNMPcollector? 
Instructions:
Run the following query:
select dev_name, dev_ip, time_created, probe_name from CM_DEVICE order by probe_name