I am in need of cleaning up the storage, which I am backing up VMs to.
There are lots of VMs, that are no longer in backup jobs but used to be and, when removed from the jobs, the option "Remove VM and keep backup" was chosen so we could have the backup available for another 6 months in case anything went wrong. Now for many of these backups the 6 months (and much more) are over, but I can't find any view, that would show me all the backups, that are no longer in a backup job.
Do I really have to click on each and every (~200) VM to see when their last backup happened? Or is there a possibility to list all VMs with their latest backup?
The thing I found to be closest to what I need, is the "Overview Report" I can get from the "Create" drop-down menu. I would like that information but in a table/list and, if possible, additionally with the information, whether they are currently part of a configured backup job or not.
Many thanks in advance and happy holidays.