Reporting and cleanup of agents

We name nearly all agents for the hostname.

We have hosts get retired but the agent still shows in the console as offline. We currently have inexact and processes to check ServiceNow to see if it's retired, ,and then come back to see for those that aren't retired, see when they last contacted the Deploy Infrastructure. Then we make a judgement call, is a year long enough ago to think that they aren't needed?

I would like to be able to see last deployment activity for a host, as well as last contact, in a view that would let me select all later than a date, and delete them. (I assume that this is a report, but could just be a filtered view of the agent list under resources)

I currently have a PowerShell script that loops through a text file that I build, does an API call to delete the agents from the console, but it's a lot of work to determine what should be deleted.

Current prod is 7.3.2, we are working to upgrade, probably in a few months, to 8.1.1 or later.

--------------

Update: I have found how to get the last deployment activity for an agent from the database.
It's a fairly short bit of SQL, see attached file.
If this was something that could be a report that just delivers a CSV to me, that would help.
Here is a sample of the output. As you can see, we get a way to see all deployments, by application for a given agent. We did find that sometimes there will be more agents reflected in the console than the database, some checking shows that is only the case when the "extra" application has never been deployed to that agent.
agent_name application_name agent_version submitted_time_utc
A090ZOSAgent 1713-UIS-ZOS 7.2.1.0.1122954 2025-12-04 14:03:39.000
A090ZOSAgent 1723-SBR-ZOS 7.2.1.0.1122954 2025-07-03 15:23:43.000
as-riscbfmac02 007 - Charlie - Test App 7.3.2.2.1161080 2025-08-08 17:25:07.000
as-riscbfmac02 10637 - Pursuit of Life Mobile App 7.3.2.2.1161080 2025-11-18 15:33:22.000
as-riscbfmac02 10800 - Brazil Consumer Mobile App 7.3.2.2.1161080 2025-08-28 15:05:22.000
as-riscbfmac02 11450 - Chile Provida Mobile 7.3.2.2.1161080 2025-11-12 13:47:08.000
as-riscbfmac02 8898-US Consumer Mobile 7.3.2.2.1161080 2025-11-14 15:36:39.000
as-riscbfmac02 8943-GEBMobileApp 7.3.2.2.1161080 2025-08-28 16:47:41.000
as-riscpdwapp01 10984-AssetDataRepository 7.3.2.2.1161080 2023-07-13 22:18:47.000
as-siscpdwapp01 10984-AssetDataRepository 7.3.2.2.1161080 2023-07-13 22:21:43.000
av-riscvmatau10 1630-SBCWorkflow 7.3.2.2.1161080 2024-03-03 05:43:23.000
av-riscvmct004 1072-CBS 7.3.2.2.1161080 2025-07-19 01:05:58.000
AV-RISCVMCT073 1081-CDF-UI-Net-CDF 7.3.2.2.1161080 2024-01-19 04:41:16.000
AV-RISCVMCT073 1346-iLINK 7.3.2.2.1161080 2022-12-10 06:28:13.000