Advanced Query
System Health Insights provides a structured query language style interface in form of the Advanced Query, for advanced users looking for flexibility in creating or modifying their search parameters. The Advanced Query can also convert the search query created in the Query Builder, in Veritas Query Language (VQL) format.
On the Advanced Search page, select the option and provide a search query in VQL format.
The VQL leverages standard Boolean operations such as AND, OR, NOT, IS NOT, IN, NOT IN, =, >, < etc. Adding additional parameters via VQL is simplified by the autosuggestion functionality. Add a Boolean operator, select a field from the list, and provide a value to form a query, then click the search icon.
For example, the following advanced query will fetch the list of appliances that have called home at any time during the past 1 year and have the capacity utilization ranging between 60 and 90 percent.
(call_home_date >= "-1y" AND call_home_date <= "0y") AND call_home_status = "All" AND (capacity_utilization >= 60 AND capacity_utilization <= 90)
You can also use the predicted utilization field in manual queries. Use the field name predicted_capacity_utilization with numeric comparison operators such as >= and <=.
For example, the following query returns appliances whose predicted capacity utilization is between 80 and 95 percent:
(predicted_capacity_utilization >= 80 AND predicted_capacity_utilization <= 95)
If you are unsure of the field name or the comparison syntax, first create the filter in Query Builder and verify that the required result is returned before using Advanced Query.
More Information