Part 8 - vROps 6.6 : Creating queries with Metrics & properties using Metric Groups

"Troubleshooting is an Art and not Science"

I remember this statement from the time I started my career as a desktop support engineer. Fast forward 14 years to today's date and we all know that the statement still holds water!

While no tool in the world will give you a 100% accurate root cause analysis, it is important that you have a tool which helps you with the rule of elimination in your troubleshooting process. If you have quick and easy things which you can check and move forward, this would definitely make the troubleshooting process faster and reduce the time required to drill down to the root cause.

Queries in vROps is one such way by which you can easily reach from the source to destination in the troubleshooting process.

With the release of vRealize Operations Manager 6.6, you can now create metric groups which not only use metrics, but can also consist of properties. Using the concept I created some new groups which work as queries. 

These queries can help answer simple questions through vROps metrics which can help an administrator significantly while they are in a fire fighting mode to quickly find and solve problems. Here are the custom queries which I have created in my environment, you can use the same and make your troubleshooting process quicker and simpler. For ease of use, I have created queries for all the key Object Types. You can see the Object Name, Queries and the Metrics which make that query:

Datacenter

Cluster

Hosts

Virtual Machines

These are just examples of what I created for myself. You being an application, database or OS experts, you can use any metrics collected by vROps and create meaningful queries.

Once you have the desired queries you can easily double click on them and look at the key metric and properties with a single click. Hopefully this will help you with your troubleshooting style and decrease the mean time to resolution.

Share & Spread the Knowledge!!