Data Infrastructure Management Software Discussions

Highlighted

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

18 REPLIES 18
Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Highlighted

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

Hi Adai,

How about I do something like this

dfm report view -F xls srm-files-least-recent-access object > "/tmp/`date`-asi.xls"

and run it using crontab. Is it equivalent? Any gotchas?

Appreciate your patience.

Regrads,

Babar

Highlighted

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

It is equivalent and you should get the same result as with the report schedule. The report schedule adds some conveniences, like automatically emailing it (not that that can't be achieved with crontab), but essentially all it does is run a report at specific times. Bear in mind that because of the nature of your report, you will get the same files listed every time unless some of the least recently accessed files are deleted between runs.

Highlighted

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

Hi Hiyer,

Thanks for the wonderful explaination.

Regards,

Babar

Highlighted

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

Hi Babar,

I am just curious of what makes you go for crontab, when a better, functionality can be achieved in OM ?

In the report schedule itself you can specify the format of the report like Perl, xls etc.

In fact the reports generated by scheduled reports are stored in the report archive dir.

If you would like to make this available in a web location you can change the report archive dir location you using the dfm option for the same.

Regards

adai

Highlighted

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

Hi Adai,

We are going to have more then 300 reports in one directory on a monthly basis. I want the file names to be meaningful so that customers can login and pickup relevant reports.

Regards,

Babar

Highlighted

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

I came across this dated post looking for a possible way to create a schedule for the last day of the month in DFM.

In finding this reply, am I correct in thinking that this "Last day of the month" schedule would actually never run in February due to it not having a 30th day?

*** DISREGARD ***

I answered my own question.  From the CLI, the help on 'dfm schedule create' notes the following:

"The range of the value is [1-31] where a value above the number of days in the month will be considered as the last day of that month."

Message was edited by: Barry Snyder

Check out the KB!
Knowledge Base
All Community Forums