Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Virtualization Manager (VMAN) > VMAN 8.0 Administrator Guide > References > Search query examples

Search query examples

Created by Caroline Juszczak, last modified by MindTouch on Jun 23, 2016

Views: 87 Votes: 0 Revisions: 4

The examples listed are search queries for virtual machines, but the search language is the same for other entity types.

search query

results

*

A list of all virtual machines in the SolarWinds Virtualization Manager data repository.

vm.name:rcarecords-2-test

Returns all VMs named rcarecords-2-test.

rca*

Returns all VMs with any data containing a word starting with rca.

rcarecords-x-test

Returns VMs name rcarecords-X-test where X can be any character.

rcarecords~

Returns VMs with any data containing strings similar to rcarecords.

vm.environmentFor.diskVolume.freeSpace:[0 TO 10000000]

All VMs whose disk volumes have 0 to 1 000 000 bytes free space, not including 0 or 1 000 000.

"Microsoft Windows"^4 "Server 2003"

All VMs with Microsoft Windows and Server 2003 in the OS details, where Microsoft Windows is four times as relevant as Server 2003.

Server OR Workstation

Any VMs with any data containing the string Server or Workstation.

Server AND Mail

Any VMs with any data containing the string Server and Mail.

+Mail Server

Any VMs with any data that must contain the string Mail and may also contain the string Server.

Mail NOT Server

Any VMs with any data that may contain the string Mail and may not contain the string Server.

-Mail Server

Any VMs with any data that must not contain the string Mail but may contain the string Server.

(Mail OR Web) AND Server

Any VMs with any data that may contain the string Mail or Web in combination with the string Server.

Examples of complex search queries

These search queries address specific issues and questions.

Operating system

issue search query
Number of Windows X machines guestFullName:"Microsoft Windows Server 2003, Enterprise Edition (32-bit)"
Number of licensed VMs/Windows VMs guestFamily:windowsGuest

VI3 topology

issue search query
Number of VMs managed by X managementServer/hostname:west-vc.hyper9.com
Number of VMs on host X hostServer/hostname:california.hyper9.com
Number of X of Y (Dell 2950s) model:2950 AND manufacturer: Dell, Inc.
All 3.0.x VMs hostServer/deviceProperties/value:3.0.*
All 3.5.x VMs hostServer/deviceProperties/value:3.5.*

VM issues

issue search query
Number of VMs with tools version toolsVersion:64607
VMs with mismatched tools toolsVersion:64607 NOT hostServer/deviceProperties/value:*Build-64607*
VMs that have been suspended NOT suspendInterval:0
VMs with less than 10 MB disk space environmentFor/diskVolume/freeSpace:[0 TO 10000000]
VMs on virtual network X virtualNIC/virtualNetworkName:Lake-Net
VMs with image files on X virtualDisk/location:*Storage*
Number of Virtual Disks is 1 $/virtualMachine/virtualDisk/colSize:1
Number of Disk Volumes is 1 $/virtualMachine/environmentFor/diskVolume/colSize:1

VMotion

issue search query
VMs with media attached NOT $/virtualMachine/media/colSize:0
VMs with media attached virtualMediaDevice/connected:true
NICs down

NOT environmentFor/networkAdapters/status:Connected

Cloning issues

issue search query
MAC address conflict on X environmentFor/networkAdapters/macAddress: 75:34:44:0b:48:19 AND NOT virtualNIC/macAddress: 75:34:44:0b:48:19
Time zone mismatch NOT environmentFor/runningOS/currentTimeZone:-300
VMs in time zone X environmentFor/runningOS/currentTimeZone:-300
Daylight Savings Time not enabled environmentFor/runningOS/daylightInEffect:false

Snapshots

issue search query
VMs with snapshots NOT $/virtualMachine/snapshotSummary/colSize:0
Non-quiesced snapshots snapshotSummary/quiesced:false

Guest OS issues

issue search query
OS version is X.Y environmentFor/runningOS/versionInfo/version:5.1.*
OS build is X environmentFor/runningOS/versionInfo/buildNumber:2600
Guest OS MAC different than vNIC MAC environmentFor/networkAdapters/macAddress: 75:34:44:0b:48:19 AND NOT virtualNIC/macAddress: 75:34:44:0b:48:19

Services and applications

issue search query
VMs with service running environmentFor/runningOS/services/displayName:Alerter
VMs with application installed

environmentFor/runningOS/installedApplications/displayableName:VMware*

Hotfixes and updates

issue search query
Patches installed in the last X environmentFor/runningOS/componentUpdates/installDate:[20150901 TO 20150930]
VMs with Hotfix environmentFor/runningOS/componentUpdates/displayName:KB*
VMs with patch conflict environmentFor/runningOS/componentUpdates/displayName:KB111111 AND environmentFor/runningOS/componentUpdates/displayName:KB222222

 
Last modified
04:20, 23 Jun 2016

Tags

Classifications

Public