Hello,
We're looking to exclude a single datastore (Nimble_datastore1) from reporting, I tried to modify the query but it is not working. Can someone provide assistance?
INNER JOIN (SELECT disk.DataStoreID, Sum(disk.Size) as sums FROM Orion.VIM.DiskFiles disk WHERE disk.Type = 'LogFile' GROUP BY disk.DataStoreID) d on ((Datastores.DataStoreID = d.DataStoreID)and(DataStoreID NOT LIKE 'Nimble_datastore1')) and d.sums > 15000000000 WITH NOLOCK
Thank you!
