Runing ZCM 10.3.1 on Windows 2003 server, database in SQL 2005 cluster I have 3 questions:

1. Deleted machines from the inventory still appear in reports when trying to run reports for compliance. - How do I delete/purge these machines forever and exclude from reports.

2. Retired devices are appearing in reports even though is is specified in the report definition "device retired = no" as one of the criteria.

3. While the reporting is fairly flexible in what you can extract I am wondering if you can run a report which will let you extract information from ANY field in the database as the software reports allows me to extract certain information ( i can't exclude retired devices) and the Hardware reports doesn't allow me to extract product serial numbers for the OS.

I know it's a bit of a long shot's hoping