I created a custom SWQL report for VM Snapshots. In SWQL studio the query returns 29 results - which is correct. I put this in a Solarwinds site and it returns 29 results.
I put this in EOC and filter the same Solarwinds site and it returns duplicates - 58 results. If I filter a different SW site it returns the same 58. If I target all 3 sites, it returns 58. If I clear all target sites, it returns 58. I expected 0 results when not targeting a site. Any preview when editing the report is the accurate 29. It is only when displaying or scheduling the report that I get duplicates.
The SWQL is pretty simple:
select A.VirtualMachineID, B.Name, A.Name as SnapName, A.datecreated, A.Description , B.SnapshotStorageSize ,B.TotalStorageSize , DAYDIFF( A.datecreated, getUtcDate()) as Age, A.SnapshotIdentifier
FROM [Orion].[VIM.Snapshots] A
Inner Join Orion.VIM.VirtualMachines B on B.VirtualMachineID = A.VirtualMachineID
Where A.Name not like 'VE%'
and B.SnapshotSummaryCount > 0
order by A.datecreated asc
So I guess there is really 2 questions:
1) why the duplicates
2) why the EOC Site Filter is not working
I am on EOC 2023.3 and one of the sites is also 2023.3 - this is the site with current VM snaps. The other 2 sites are 2023.2
This one is frustrating me.
Thanks - Kevin
