CA Performance Management Tech Series: OpenAPI QueryBuilder
Agreed, great stuff. Looking forward to the future presentations!
Just wanted to say thanks to everyone that attended this session yesterday or watched the session recording.
I wanted to follow-up with some additional example queries that I showed during the session. We have quite a few examples called out in our on-line Documentation that are very helpful. Two of the ones I want to call out here take advantage of a very powerful new aspect of the OpenAPI - group based aggregation.
Query to get list of devices and their supported Metric Families and Vendor Certifictions
Requires: CAPM 3.1 (additional metric relationships and access to user friendly names and descriptions)
Query to generate TopN view of Interfaces with largest 95th Percentile Utilization within a specified group
Requires: CAPM 3.1 (group association to metric families)
Query to generate a list of Devices and their max Bad Poll % over a given time-range and group
Requires CAPM 3.0
Great session with some new insights for me. Please share your example queries whenever possible - many thanks!