How to create a list of the deleted computers?

Reporting
1

(imported topic written by peterd91)

Hello,

I need to create a report, which will list all the computers, which were deleted from the console. I would like the report to also contain the below information for each listed computer:

  • the computer name
  • time the computer first reported
  • time when the computer was deleted
  • a link to display all the actions that had been run on it (including any deleted action)

I want the report to contain only the deleted computers.

I have the below details how to extract information about deleted computers using sql query, but not sure how to use it in web reports.

  • the initial install time for a computer:

select ComputerID, min( FirstBecameRelevant ) from FIXLETRESULTS group by ComputerID

  • to retrieve the last report time from computers that are deleted:

select ComputerID, IsDeleted, LastReportTime from COMPUTERS

That would be great if someone has done this already and can share it with me. Any other help will be highly appreciated as well.

Thanks,

Peter

2

(imported comment written by BenKus)

Hi Peter,

Unfortunately, you can’t put arbitrary SQL queries into web reports because it can only report on things that are loaded into the web reports “session” and deleted systems are not loaded into web reports.

You will need to run your SQL queries through another tool to get this data.

Ben