Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Storage Manager (STM) > SRM Profiler Administrator Guide > Using reports and schedules > Example report

Example report

Table of contents
No headers

Updated: June 16, 2017

When you build a custom report, you are simply selecting the fields you want to see, in the order you want to see them, and adding filters to narrow the results.

When the report is run you can narrow the results by selecting a particular set of devices, time period, and other variables.

For example, assume you wanted to find all the servers in your environment where the C:\ drive was greater than 90% full, and you want to understand how fast they are growing.

There is a template "Volume Usage Forecast" you can use as a starting point.

  1. Go to Reports > My Reports and click New Report.
  2. Select the template you want to use.
  3. Select Enterprise > Storage > Volume Usage Forecast, and then click Continue:
    File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/02000069_446x449.jpg
  4. Select the columns you want in the report and the order of those columns.
  5. Each template has defaults for the columns selected, the column order and the sort order.
  6. Remove the Eighty and Ninety percent columns by highlighting them and clicking the left arrow.

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/0200006A_478x194.jpg

  1. Select the sorts and filters for the report, allowing you to narrow the output to exactly what you want.
  • Enter the name of the report "C Drives Over 90 Percent" and in this case, you will leave the default sort (server, volume) in place. If you wanted to change the sort order, you can remove current sorts by highlighting them in the text box and clicking Delete Sort, and add new sorts by selecting the Sort By field and order by clicking "Add Sort".

The order of the fields in text box is the order the sort are applied to the report.

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/0200006B_415x136.jpg

  1. Select the filters. In general, you can filter by any column in the report, and the options of the filter will match the data type:
  • Text Fields: like, not like, <, >, =, <=, >=, <>, in, not in
  • Numeric Fields: like, not like, <, >, =, <=, >=, <>, in, not in
  • Date Fields: <, >, =, <=, >=, <>, before, within

The basic query you will build is "Volume Name like C: AND % Used > 90". So for the first part select "Volume Name" and "like" and enter "%C:%" and then click "Add Filter" - you should see the filter appear in the text box. For "like" filters, make sure you add the "%" before and after the text.

Since this is the first filter, you can ignore AND/OR drop down.

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/0200006C_458x110.jpg

  1. For the second filer, choose "AND", "% Used", " > " and enter "90" and click Add Filter.

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/0200006D_462x118.jpg

  1. Select the following items:
  • Time Zone: The default time zone of the report, which can be changed at run time.
  • Row per Page: The default rows per page.
  • Permissions: What users can see this report: Myself, Group (All users in my groups), All (everyone).
  1. Save the report and your page should look like the following:

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/02000069_395x399.jpg

Available actions:

  • Save Report - saves the report and returns to My Reports.
  • Save and Run - saves the report and takes you to the Run Report page
  • Cancel - abort changes to the report and return to the My Reports list.

For this report, if you select Save and Run, and then run the report, the output looks like this (assuming you have some C:\ drives over 90%).

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/0200006E_475x159.jpg

You have the ability to group filters, so you can do "Find all (C: OR D:) drives that are over 90%".

File:Success_Center/Reusable_content_-_InfoDev/SRM_Profiler/Example_report/0200006F_409x147.jpg

Here are some ways users can leverage the reporter functionality:

  • Identify problem areas before they become "problems" - busiest LUNs, fullest drives, busiest VM or ESX, etc.
  • Chargeback - charge users, departments, customers, etc. for the storage, backups or servers they are using.
  • Backup Compliance - identify full backups that have not been successful for more than 7 days.
  • User Quotas - identify users exceeding their storage quota
 
Last modified
11:18, 26 Jun 2017

Tags

Classifications

Public