topic Re: DFM : export data CLI custom view in Active IQ Unified Manager Discussions

topic Re: DFM : export data CLI custom view in Active IQ Unified Manager Discussions https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70784#M14728 <HTML><HEAD></HEAD><BODY><P>There are performance OnCommand APIs as well that allows you to collect counter information.  Check out:</P><P><A _jive_internal="true" href="https://community.netapp.com/docs/DOC-1044" target="_blank">https://communities.netapp.com/docs/DOC-1044</A></P><P></P><P>   - Rick -</P></BODY></HTML> Thu, 19 Jul 2012 14:46:39 GMT rle 2012-07-19T14:46:39Z DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70760#M14723 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I use ManagmentConsole and i created some custom views in "Manage Performance=> Set up => Custom Views".</P><P>One of this is "pa_avg_disk_busy" for all my aggregate.</P><P></P><P>I would like export (using CLI) this informations.</P><P>I tried this but doesn't work :</P><P><STRONG>C:\Users\sys-foncia.RESSOURCES>dfm perf export counter add -v "COPIL_aggr-avg-disk-busy" aggregate:pa_avg_disk_busy</STRONG></P><P><STRONG>Error: View 'COPIL_aggr-avg-disk-busy' is not a legacy view. Only legacy views can be specified.</STRONG></P><P></P><P>It's working if i use graphical interface : File => Export => Select Counters</P><P></P><P>See my view available in dfm cli (i want use bold views) :</P><P></P><P>C:\Users\sys-foncia.RESSOURCES>dfm perf view list</P><P>View Name</P><P>--------------------</P><P>Aggregate Summary View</P><P>Dataset Summary View</P><P>Disk Summary View</P><P>Group - Top Objects</P><P>Group - Top vFilers</P><P>Group Summary View</P><P>Lun Alignment View</P><P>Lun Summary View</P><P>Network Interface Summary View</P><P>Processor Summary View</P><P>Qtree Summary View</P><P>Resource Pool Summary View</P><P>Storage System - Disk Throughput</P><P>Storage System - Network Throughput</P><P>Storage System - Per Protocol Latencies</P><P>Storage System - Per Protocol Ops</P><P>Storage System - Per Protocol Sizes</P><P>Storage System - Top Logical Objects</P><P>Storage System - Top Physical Objects</P><P>Storage System - Top vFilers</P><P>Storage System Summary View</P><P>Target Basic</P><P>Top Aggregates</P><P>Top CPUs</P><P>Top LUNs</P><P>Top Network Interfaces</P><P>Top Volumes</P><P>vFiler Basic</P><P>vFiler Summary View</P><P>Volume IOPs View</P><P>Volume Latency View</P><P>Volume Summary View</P><P><STRONG>COPIL_aggr-avg-disk-busy</STRONG></P><P><STRONG>COPIL_cifs-ops-latency</STRONG></P><P><STRONG>COPIL_commun-ops-latency</STRONG></P><P><STRONG>COPIL_cpu3</STRONG></P><P><STRONG>COPIL_fcp-ops-latency</STRONG></P><P><STRONG>COPIL_network</STRONG></P><P><STRONG>COPIL_nfs-ops-latency</STRONG></P><P></P><P>And see the describe of the "COPIL_aggr-avg-disk-busy" :</P><P>C:\Users\sys-foncia.RESSOURCES>dfm perf view describe "COPIL_aggr-avg-disk-busy"</P><P>View Name: COPIL_aggr-avg-disk-busy</P><P>Applies To: Instances</P><P></P><P>Chart Details:</P><P></P><P>Chart Name: aggr-avg-disk</P><P>Chart Type: simple chart</P><P>Counters in this Chart:</P><P></P><P>Object: SANA:aggrFC</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SANB:aggrFC</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SANB:aggrSATA</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SDD110P001SAN:aggrSATA</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SDD110P001SAN:aggrFC</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SDD110P002SAN:aggrFC</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SDD110P002SAN:aggrSATA</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Object: SANA:aggrSATA</P><P>Counter: aggregate:pa_avg_disk_busy</P><P></P><P>Someone can help me ?</P><P></P><P>Thank you.<BR />Regards,</P></BODY></HTML> Fri, 06 Jul 2012 13:55:01 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70760#M14723 maillon133 2012-07-06T13:55:01Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70763#M14724 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>     Pls use the </P><P>dfm perf data retrieve cli to get the data for the view using cli.</P><P></P><P>NAME</P><P>    retrieve -- This command allows you to extract the counter data</P><P>                    with supported statistical calculations on them.</P><P></P><P></P><P>SYNOPSIS</P><P>    dfm perf data retrieve { [ -o object-name-or-id ... ] [ -C perf-counter ... ] </P><P>                              [ -V view-name ] } </P><P>                    [ -d duration ] [ -b start-time ] [ -e end-time ]</P><P>                    [ -M month ... ] [ -D weekday ... ] [ -T time-range ... ]</P><P>                    [ -m statistical-method [ -P percentile-value ]</P><P>                              [ -S data-advance-method ] ]</P><P>                    [ -s sample-rate ] [ -x output-format ] [ -R ]</P><P></P><P></P><P>DESCRIPTION</P><P>    This command retrieves performance data for the specified counters and</P><P>    object instances. These counters and instances can be specified explicitly</P><P>    using the -C and -o options or implicitly by specifying the view-name</P><P>    using -V option.</P><P></P><P></P><P>    When the view specified is associated with object types, the object</P><P>    instance has to be explicitly specified using the -o option. When the view</P><P>    specified is associated with object instances, this option is not</P><P>    mandatory. If -o option is specified in this case, the specified object</P><P>    instances are considered, ignoring the instances in the view. If</P><P>    counters are explicitly specified along with the view, the counters</P><P>    in the view are ignored and the explicitly specified counters are</P><P>    considered instead.</P><P></P><P></P><P>    For finer control on the time, a filter with months, days and time</P><P>    range with in a day can be specified. Only those time stamps that</P><P>    satisfy the filter will be shown in the output. On the resulting output of</P><P>    counter data, statistical computations like minimum, maximum, mean,</P><P>    and value_at_percentile can be computed.</P><P></P><P></P><P>    Description of options:</P><P>    -o Object instance for which data is to be retrieved. Multiple object</P><P>              instances can be specified. Specifying a parent will retrieve data</P><P>              for all its children.</P><P></P><P></P><P>    -C A counter of the form object-name:counter-name (ex. system:cpu_busy).</P><P>              Multiple counters can be specified.</P><P></P><P></P><P>    -V View Name. A view name can be specified, instead of specifying the</P><P>              counters and instances explicitly.</P><P></P><P></P><P>    -b Start time. Format: "yyyy-mm-dd hh:mm:ss". If this option is not</P><P>              specified, the start time will be the time of the oldest record.</P><P></P><P></P><P>    -e End time. Format: "yyyy-mm-dd hh:mm:ss". If this option is not</P><P>              specified, the end time will be the time of the newest record.</P><P></P><P></P><P>    -d Duration for which data is to be retrieved (in seconds). The time is</P><P>              calculated going backwards from the current time. When this option</P><P>              is specified, start-time and or end-time are ignored.</P><P></P><P></P><P>    -s Sample rate (in seconds). This interval will be used to consolidate</P><P>              the output data. The available data will be split into regions as</P><P>              specified by the sample rate and the last sample in each of those</P><P>              regions will be displayed. Also used for window calculation for metrics.</P><P></P><P></P><P>    -x Specifies the format to display the output. Possible values are</P><P>              Legacy and TimeIndexed. Default value is Legacy.</P><P></P><P></P><P>    -R If specified, data is rolled-up to the nearest minute. Applicable</P><P>              only when the output format is TimeIndexed.</P><P></P><P></P><P>    -M Filter based on month. Examples: Jan, Feb, etc. Comma separated multiple values</P><P>              can be specified.</P><P></P><P></P><P>    -D Filter based on day of week. Examples: Mon, Tue, etc. Comma separated multiple</P><P>              values can be specified.</P><P></P><P></P><P>    -T Filter based on time range in a day. Example: 16.00-21.55. Comma separated multiple</P><P>              values can be specified.</P><P></P><P></P><P>    -m The statistical computation. Valid values are min, max, mean and</P><P>              value_at_percentile.</P><P></P><P></P><P>    -P For value_at_percentile type of calculation, this contains the</P><P>              percentile value.</P><P></P><P></P><P>    -S For computing on fixed size data, this defines the method to advance</P><P>              the chunks of data. Valid values are simple, step and rolling. Default</P><P>              value is simple. Valid only when a statistical-method is specified.</P><P>              Simple and step methods are available for all statistical methods.</P><P>              Rolling is valid only for mean statistical method.</P><P></P><P></P><P></P><P>Regards</P><P>adai </P></BODY></HTML> Thu, 19 Jul 2012 08:50:59 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70763#M14724 adaikkap 2012-07-19T08:50:59Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70768#M14725 <HTML><HEAD></HEAD><BODY><P>Thank you very much Adai</P><P></P><P>But i have a question about results.</P><P>See the describe about COPIL_cpu3. There is only processor3 which match.</P><P></P><P>C:\Users\Administrator>dfm perf view describe COPIL_cpu3</P><P>View Name: COPIL_cpu3</P><P>Applies To: Instances</P><P></P><P>Chart Details:</P><P></P><P>Chart Name: cpu3</P><P>Chart Type: simple chart</P><P>Counters in this Chart:</P><P></P><P>Host: SDD110P002SAN</P><P>Instance: processor3</P><P>Counter: processor:processor_busy</P><P></P><P>Host: SDD110P001SAN</P><P>Instance: processor3</P><P>Counter: processor:processor_busy</P><P></P><P>Host: SANB</P><P>Instance: processor3</P><P>Counter: processor:processor_busy</P><P></P><P>Host: SANA</P><P>Instance: processor3</P><P>Counter: processor:processor_busy</P><P></P><P></P><P>But when i execute this command, i have all CPU :</P><P></P><P>C:\Users\Administrator> dfm perf data retrieve -V COPIL_cpu3 -b "2012-06-01 00:00:00" -e "2012-06-01 00:30:00"</P><P></P><P>Timestamp       SANA:processor3:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:25:24     54.518</P><P></P><P>Timestamp       SANA:processor1:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:25:24     34.633</P><P></P><P>Timestamp       SANA:processor2:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:25:24     37.503</P><P></P><P>Timestamp       SANA:processor0:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:25:24     35.041</P><P></P><P>Timestamp       SANB:processor3:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:22:09     36.890</P><P></P><P>Timestamp       SANB:processor1:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:22:09     28.245</P><P></P><P>Timestamp       SANB:processor2:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:22:09     29.929</P><P></P><P>Timestamp       SANB:processor0:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:22:09     28.797</P><P></P><P>Timestamp       SDD110P001SAN:processor3:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:27:48     57.141</P><P></P><P>Timestamp       SDD110P001SAN:processor1:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:27:48     25.192</P><P></P><P>Timestamp       SDD110P001SAN:processor2:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:27:48     27.737</P><P></P><P>Timestamp       SDD110P001SAN:processor0:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:27:48     23.046</P><P></P><P>Timestamp       SDD110P002SAN:processor3:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:23:14     29.655</P><P></P><P>Timestamp       SDD110P002SAN:processor1:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:23:14     25.942</P><P></P><P>Timestamp       SDD110P002SAN:processor2:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:23:14     27.228</P><P></P><P>Timestamp       SDD110P002SAN:processor0:processor_busy</P><P>-------------------------------------------------------------------------------</P><P>2012-06-01 00:23:14     24.841</P><P></P><P>Have you any idea about this ?</P><P></P><P>Thank you.<BR />Regards,</P></BODY></HTML> Thu, 19 Jul 2012 10:05:22 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70768#M14725 maillon133 2012-07-19T10:05:22Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70774#M14726 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>     Let me clarify what you want to do. Are you looking for the NMC way of exporting individual counters ? As you stated ?</P><P><SPAN style="color: #454545; font-family: Arial, Helvetica, Verdana, sans-serif; background-color: #ffffff;">It's working if i use graphical interface : File => Export => Select Counters</SPAN></P><P></P><P>dfm perf data retrieve is to retrieve data from a performance view and doesn't  allow individual counters.</P><P></P><P>The <STRONG style="font-family: Arial, Helvetica, Verdana, sans-serif; color: #454545; background-color: #ffffff;">dfm perf export counter add</STRONG> is to export the list of counters for a defined period to third party tools or database.</P><P>You can find the TR named <A class="jive-link-external-small" href="http://media.netapp.com/documents/tr-3690.pdf" style="font-family: Arial, Helvetica, Verdana, sans-serif; color: #0067c5; text-decoration: underline; background-color: #ffffff;" target="_blank">Access to DataFabric Manager and Performance Advisor Data Using Database Access and Data Export</A> </P><P>and other TR related to dfm in this link.</P><H1 style="font-size: 26px; font-family: Arial, Helvetica, Verdana, sans-serif; color: #454545; background-color: #ffffff;"><A _jive_internal="true" href="https://community.netapp.com/message/58484#58484" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #009fda;" target="_blank">OnCommand(DFM) and its related Technical Reports</A></H1><P></P><P>Regards</P><P>adai</P></BODY></HTML> Thu, 19 Jul 2012 14:12:51 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70774#M14726 adaikkap 2012-07-19T14:12:51Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70779#M14727 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Yes it's possible if i use graphical interface but i would like "script it" (automated). I already use graphical interface but it's very long if i have lot of "custom counters".</P><P></P><P>Thank you.<BR />Regards,</P></BODY></HTML> Thu, 19 Jul 2012 14:45:34 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70779#M14727 maillon133 2012-07-19T14:45:34Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70784#M14728 <HTML><HEAD></HEAD><BODY><P>There are performance OnCommand APIs as well that allows you to collect counter information.  Check out:</P><P><A _jive_internal="true" href="https://community.netapp.com/docs/DOC-1044" target="_blank">https://communities.netapp.com/docs/DOC-1044</A></P><P></P><P>   - Rick -</P></BODY></HTML> Thu, 19 Jul 2012 14:46:39 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70784#M14728 rle 2012-07-19T14:46:39Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70787#M14729 <HTML><HEAD></HEAD><BODY><P>Thank you very much Rick and Adai</P><P></P><P>Regards,</P></BODY></HTML> Thu, 02 Aug 2012 07:29:54 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/70787#M14729 maillon133 2012-08-02T07:29:54Z Re: DFM : export data CLI custom view https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/119660#M21397 <P>Could somone help me to find the command to grab the underutilized thick volumes list from DFM via cli ?</P> Thu, 26 May 2016 22:15:36 GMT https://community.netapp.com/t5/Active-IQ-Unified-Manager-Discussions/DFM-export-data-CLI-custom-view/m-p/119660#M21397 VarunRaveendran 2016-05-26T22:15:36Z