I want to run a query which would show me all agent deployments by machine the agent was deployed to. In other words, I'm trying to find all instances where an agent was deployed more than once to a machine. However, I haven't been able to suss out a way to do this.
In the dashboard you could modify the Product deployment in the last 24 hours query to assist you with finding out this information. The query uses Event Id 2411, 2412 for successful or failed installs. You can add the value from the left for product code. Now specify the epoagent3000 product type. In my testing I also changed the date range to be for 1 week.
Hope this helps,