We have Virtualization Manager 8.1 in Orion. No separate appliance. There doesn't appear to be a way to search for a VM on the Summary page. If I don't know what host a VM is on it can be a long process to find. Is there someway to do this?
We have Virtualization Manager 8.1 in Orion. No separate appliance. There doesn't appear to be a way to search for a VM on the Summary page. If I don't know what host a VM is on it can be a long process to find. Is there someway to do this?
This was one of the very first SWQL queries i taught myself because it was such an obvious gap.
Add a custom query resource to your view, edit it and paste this code in. Then check the box for search and paste the same thing into that, but remove the comment marks from the last line.
select vm.displayname AS vSphereName, vm.detailsurl as [_LinkFor_vSphereName], vm.ipaddress AS IP, vm.detailsurl as [_LinkFor_IP], h.hostname as ESXiHost, h.detailsurl as [_LinkFor_ESXiHost], vm.processorcount AS CPUCount, vm.memoryconfigured / 1048576 as Memory_MB ,vm.powerstate as PowerState
,case
when vm.powerstate = 'poweredon' then '/orion/vim/images/statusicons/small-VMware-vm-up.gif'
when vm.powerstate = 'poweredoff' then '/orion/vim/images/statusicons/small-VMware-vm-shutdown.png'
end as [_iconfor_PowerState]
from orion.vim.virtualmachines vm
join orion.vim.hosts h on h.hostid=vm.hostid
--where vSphereName like '%${SEARCH_STRING}%' or IP like '%${SEARCH_STRING}%' or ESXiHost like '%${SEARCH_STRING}%' or vm.guestdnsname like '%${SEARCH_STRING}%'
Hello,
there is search bar in the main menu:
but unfortunately it's searching only in nodes, not Virtualization entities.
Searching also in Virtualization entities is in VIM workmap, but I cannot guarantee when it will be released.
Best way how to make it works is to use custom resource mentioned by mesverrum one post above.
I did a custom query resource, and the VM's and table display correctly. When searching I receive an error "There was an error processing the request." no matter what I search for. Does anyone know the default location for logs to further troubleshoot?
You need to put the entire query into that second box, its really running two completely separate things. I sometimes write custom queries with high level info on the initial screen and then if you search any of the values it gives you a different, more detailed set of data based on the search filter.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.