Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Help Filtering Out Reporting Data? (SWQL)

Hello,

Below is out of the box SWQL reporting for powered off virtual machines. I simply want to filter out 1 certain data center from my list. I assumed this would be fairly simple but does not appear to be. Anyone have any suggestions?

SELECT
vm.Name, vm.LastActivityDate, vm.GuestState, vm.TotalStorageSizeUsed, vm.PlatformID,
vm.Status, vm.DetailsUrl, vm.Host.HostName, vm.Host.Cluster.Name AS ClusterName
FROM
Orion.VIM.VirtualMachines vm
WHERE
SecondDiff(vm.LastActivityDate, getUtcDate()) > 2592000 AND
vm.PowerState IN('poweredOff', 'suspended', 'paused', 'saved')

Find more posts tagged with

Accepted answers

bobmarley

AND vm.Host.Cluster.Name LIKE '%yournamegoeshere%'

All comments

bobmarley

You could add a custom property DataCenterName and then add AND DataCenterName LIKE 'datacentereast' at the end of your Where statement

leftthematrix

Well, I used the wrong term in my original post. I actually want to filter out CLUSTER, not datacenter. Which is already defined. How could I filter out 1 cluster name from this already defined variable?

bobmarley

AND vm.Host.Cluster.Name LIKE '%yournamegoeshere%'