Server Management Suite

Hi to All,

My name is Paolo from Itlay. We have started to use the Symantec Management Console. We would like to know if it's possible create a report to find Computers retired?

Could you please help me?

Thanks for your help

Best regards

Paolo

There are some pre-existing reports that include asset status.  For example, one that has several pickers is Reports > Service and Asset Management > Picker Reports > All Assets

Does this answer your question?

Hello Paolo,

You could also create a report based off of the following SQL query:

select distinct

asset.name

from VRM_ASSET_ITEM asset

join vAsset as status

on status._ResourceGuid = asset.guid

where status.Status <> 'Active'

and

(status.[Asset Type] Like 'Virtual Machine'

or status.[Asset Type] like 'Computer')

You can do the SQL report as scott.hall said. If the reason you are doing this is to be able to delete the machines from the Console you should be able to set the agent settings to remove entries that haven't connected in a specific time fram that you have set. For my eviroment i have it set to 15 days and ots been working great.