Query Builder
You can perform the advanced search in the Query Builder in any of the following three ways:
Search Text: Enter a free-text search term in the Search Text field to retrieve the matching results, encompassing all data columns of the appliance list. You can refine or broaden the search by using certain special characters in combination with the search term.
Add Filters: Apply column filters as search parameters, such as Appliance Model, Version, SRS Score and so on. Use the Add Filter drop-down to add or remove filters for a more tailored search.
Any combination of filters can be applied at the same time. You can show or hide the filters by clicking on the Show / Hide Filters icon.
Combine the text search and the filters: Use the combination of the free-text search and column filters for even more accurate results.
Date filters > '' option:
'Date' type filters such as, Call Home Date, End Date, or Ship Date have the 'In Range' option for which an input is required to be provided in a specific format, such as <1y 2m 3w 4d> and so on. Note that the 'Hours' level filtering is supported only for the Call Home Date filter.
Example 1: For Call Home Date, the 'In Range (-1y 2m) to (0m)' will filter the appliances that have Called Home between the last 1 year 2 months (14 months) and the current (0) month. This can also be specified as 'In Range (14m) to (0m)'.
Example 2: For the Support End Date, the 'In Range (6m 8w) to (1y 6m)' will filter the appliances that have the support contract ending within the next 6 months 8 weeks, to next 1 year 6 months.
Capacity filter accepts the range values in GB or TB and filters the appliances that have the total storage capacity within the specified range.
Capacity Utilization is a percentage filter, in which you require to specify the minimum and maximum percentage range to view the appliances that are within the specified range of capacity utilized. Enter the range between 0 to 100.
Predicted Capacity Utilization is a percentage filter for the forecasted utilization value shown in the Appliance List. Enter values from 0 to 100. In Query Builder, MIN is treated as the lower bound (>=) and MAX is treated as the upper bound (<=). You can leave either MIN or MAX empty if you want an open-ended range.
For example, specifying only MIN as 80 returns appliances with a predicted capacity utilization of 80 percent or higher. Only records with a numeric predicted utilization value match this filter. Appliances for which forecast data is unavailable do not match.
Note:
If filtering returns no results, verify that the specified range is between 0 and 100, that MAX is not lower than MIN, and that the target appliances have forecast data available. Appliances with blank, dashed, or otherwise unavailable predicted values do not match the filter.
SRS Score filter accepts the minimum and maximum values between 0 to 100 and displays the appliances that have the SRS score within the specified range.
EOSL date has be updated based on appliance model in the entitlement card present on the Appliance Overview page.
EOSS date: End of standard Support for an appliance, usually Shipping date + 5 years.
Appliance family, Version and Model based on the configuration file.
MSDP Allocated and MSDP Used regarding storage allocated and used.
Note:
The UI Type filter allows you to view the appliances by their UID types which can be a - Serial Number, Cluster ID, HA Asset Tag, or Cluster Node Serial Number of an appliance. This filter is available only in the Advanced Search and the Saved Query, but not in the Account or Query Dashboards.
More Information