How to determine what devices have recently been added to UIM

Document ID : KB000100496
Last Modified Date : 07/06/2018
Show Technical Document Details
Introduction:
Customer request to find a way of determining what devices/servers have recently been added to UIM.
Background:
Customer reporting requirements.
Environment:
- UIM v7.x or higher
Instructions:
To to determine what devices have recently been added you can use a query like this in the SLM portlet or database tool of your choice, e.g., MS SQL Server studio.:

select cs_id, cs_key, cs_type, da_id, create_time, change_time, alive_time, dedicated, state, name, domain, origin, ip, dns_name, mac, os_type, os_version, os_description, monitored from cm_computer_system where create_time > '2018-03-07 00:00:00' order by create_time ASC

The create_time can be adjusted based on requirements.