Customizing the Qtree Capacity and Utilization report to display qtrees that have breached the file soft limit
You can customize the Qtree Capacity and Utilization report to display qtrees that have breached the file soft limit. You can filter and sort by file used, file hard limit, and file soft limit.
About this task
You can also perform this task by going to the Reports page and clicking Run Report for the appropriate report.
Steps
-
To remove the grouping by SVM, cluster or volume, perform the following steps:
-
Click in the columns that need to be ungrouped.
-
Click the icon.
-
Select Group > Delete Inner Group.
-
-
To filter qtrees that do not have an unlimited file hard limit, click in the File Hard Limit column and open the Filter dialog box by clicking the icon.
-
From the Condition drop-down list, select Not Equal To.
-
Click Select Values and select Unlimited.
-
Click Ok.
-
-
To filter qtrees that do not have an unlimited file soft limit, click in the File Soft Limit column and open the Filter dialog box by clicking the icon.
-
From the Condition drop-down list, select Not Equal To.
-
Click Select Values and select Unlimited.
-
Click Ok.
-
-
To add a column for qtrees that have breached the file soft limit, perform the following steps:
-
Click in the File Soft Limit column, click the icon, and select Column > New Computed Column
-
In the New Computed Column dialog box, type
Breached File Soft Limit Capacity
in the Column Label field. -
From the Select Category list, select Text.
-
From the Select Function drop-down list, select Advanced.
-
In the Enter Expression field, type
IF(([qtreeFileUsedPercent]*[fileLimit]/100 > [softFileLimit]), "Yes", "No")
. -
Click OK.
-
-
To filter qtrees that have breached the soft file limit, click in the Breached File Soft Limit Capacity column and open the Filter dialog box by clicking the icon.
-
From the Condition drop-down list, select Equal To.
-
Click Select Values and select Yes.
-
Click Ok.
-