Subscribe

How to schedule the report to run monthly with 1 month data in DFM

Hi,

I am trying to use the scheduler to run a monthly report for "system performance summary" for one month. There is "1d,1w,1m,3m,1y" in the display ouput which you can manually selected. However, there is no selection in the report creation menu , as well as the scheduler in DFM.

Any idea?

Regards,

Terrence

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi Terrance,

     In cli there is an options to do this.

The option is -P but some how this got missed in the cli help and man pages.

This is fixed in one of the upcoming release(cli help and man pages)

But still the option works in 3.7 and 3.8 releases of DFM.

Below is the option name and its possible values.

-P time frame signifies the period to fetch performance data.
           Valid values are 'last, 1d, 1w, 1m, 3m and 1y'. This option
           is valid only in conjunction with performance reports.

Below is the help of the fixed cli.

[root@lnx ~]# dfm report view help

NAME
    view -- Generate one of several reports

SYNOPSIS
    dfm report view [ <options> ] <report-name> [ <report-arguments> ... ]

DESCRIPTION
    The report command runs one of several pre-defined searches
    and presents the results.

    Use 'dfm report list' to get the list of reports.
    Use 'dfm report view <report-name> help' to see
    the description of a report.

    The options are
        -g <group-id or group-name>
        -F <output-format>
        -l <lines>
        -q (quiet)
        -s <sortby-field>
        -x (show all fields; only in perl output format)
        -N <repeat-for>
        -i <repeat-interval>
        -t <timeout> (in seconds; for streaming reports)
        -H show deleted objects
        -P time frame signifies the period to fetch performance data.
           Valid values are 'last, 1d, 1w, 1m, 3m and 1y'. This option
           is valid only in conjunction with performance reports.

[root@lnx ~]#

Regards

adai

Regards

adai

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi Terrence,

You can create schedules for both Canned & Custom reports. It can be done via both UI and CLI.

In UI, it is available at Control Center -> Reports -> Schedule

In CLI, it is "dfm report schedule"

C:\>dfm report schedule help

NAME

schedule -- create and manage report schedules

SYNOPSIS

dfm report schedule add -s <schedule-name-or-id> -R <report-name>

[ -x all ]

[ -H include ] <report-schedule-name>

dfm report schedule modify

[ -x all ]

[ -H include ]

<report-schedule-name-or-id>

dfm report schedule list -t { enabled

dfm report schedule delete { all | report-schedule-name-or-id ...}

dfm report schedule enable { all | report-schedule-name-or-id ...}

dfm report schedule disable { all | report-schedule-name-or-id ...}

dfm report schedule detail <report-schedule-name-or-id>

dfm report schedule run <report-schedule-name-or-id> ...

DESCRIPTION

The schedule command is used to create and manage report schedules in the DataFabric Manager server.

C:\>

Regards,

Saravanan

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi Adai,

Thanks for the info. But this is only to list/view the report. Is the -P (time frame) option also available for the report create? It's because I cannot run the schedule with the 'report list' or 'report view'.

Regards,

Terrence Lee

NetApp Global Services

NetApp

852.3605.7700 Main

852.9181.8824 Mobile Phone

terrence.lee@netapp.com

Learn how: netapp.com/guarantee

Re: How to schedule the report to run monthly with 1 month data in DFM

Yes I do agree.

I will file a Burt.

Mean time let me explore if there are some workaround to get away with this problem.

Regards

adai

Re: How to schedule the report to run monthly with 1 month data in DFM

Thanks Adai.

Regards,

Terrence Lee

NetApp Global Services

NetApp

852.3605.7700 Main

852.9181.8824 Mobile Phone

terrence.lee@netapp.com

Learn how: netapp.com/guarantee

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi all,

IHAC customer who is using SFRM. We have a added a path to be walked by the dfm. It is scheduled to run every weekend.

Now is the part that I am confused about. The cusomter wants to generate a xls report (srm-files-least-recent-access) automatically at the end of the month for all the paths. I can manually generate the report using the command line given below. It can be done via crontab as well but was just wondering if there is a better way of implementing this using report schedules. I have read the documentation but am still confused.


  dfm report view -F xls srm-files-least-recent-access dsmsrvp1b:/gptsd/asi > asi.xls

Any help/hint would be highly appreciated.

Regards,

Babar Haq

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi Babar,

     You can use the report schedule feature, to schedule the reports and email in any of the supported formats to one or more ppl.

The navigation for the same is Control Center-> Reports-> Schedule.

The FSRM data is not aggregate ones rather point in time unlike the dfm history for volumes and performance data.

Below is the example of a report schedule on a monthly basis.

# dfm report schedule list
ID     Name                 Report                     Schedule             Enabled
------ -------------------- -------------------------- -------------------- --------
  1191 Monthly Aggr         disks-aggr                 Last day of the month Yes
# dfm schedule list
ID     Schedule Name                       Schedule Description
------ ----------------------------------- ---------------------------------------
  1190 Last day of the month               Monthly on day 30 at 0 hours 0 minutes.
#

Regards

adai

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi adai

Thank you for your reply.

The file names of the reports created using schedule command are somenumber+datestamp (where somenumber is reportid i guess). Can it be configured to be a more meaningull name plus date stamp?

Regards,

Babar

Re: How to schedule the report to run monthly with 1 month data in DFM

Hi Babar,

No, the output file names can’t be configured.

The format is _datestamp.

Regards

adai