One of the easiest ways is to add the VMs (objects) of interest to a list. i.e. select the Inactive VMs in the alert (ctrl, shift select should also work) and add them to a list with the "add to list" button.
Then if you go to your list tab, you should be able to select all of these VMs in your list and hit the "export" button to dump these out to excel.
Let me know if this helps.
I don't seem to be able to dump out to excel using this method without adding the attributes of the search query. Also i'll lose the detail of the alert such as the details of the "oldest VMDK" column of the alert screen. Is there a way to export this too?
It would be much easier to be able to export the alert list directly into excel.
We provide a number of "templates" (groups of properties) out of the box so that you don't have to select each property individually. (you can also save properties of interest as a template so that you can reuse them and don't have to enter them every time)
The "VM Inactivity Report Template" might be a good one to try based on your alert.