is there a way to extract the list of decommissioned servers?
maybe i read somewhere that a decommissioned server is still somewhere on the db.
this is for revoking licenses: having a list of servers to delete from the licensing section of the support site
in the bladelogic db run:
select name,ip_address from device where device_state_id = 100 or is_deleted = 1
device_state_id = 100 is decomissioned servers, is_deleted = 1 are servers that are deleted (though those should be the same)