Active IQ Unified Manager Discussions

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

tatlee
53,807 Views

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

adaikkap
53,732 Views

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

tatlee
53,732 Views

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

adaikkap
53,732 Views

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

tatlee
53,732 Views

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

msaravan
53,732 Views

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

babar
53,732 Views

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

adaikkap
53,732 Views

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

babar
53,732 Views

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

adaikkap
53,732 Views

Hi Babar,

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

The format is _datestamp.

Regards

adai

babar
52,954 Views

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

hiyer
52,954 Views

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.

babar
52,954 Views

Hi Hiyer,

Thanks for the wonderful explaination.

Regards,

Babar

adaikkap
52,954 Views

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

babar
52,954 Views

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

bsnyder27
52,954 Views

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

adaikkap
51,885 Views

Hi Barry,

     Are you talking about the schedules in Protection Manager or in Operations Manager. In case of PM you should be able to handle this. But since in case of Ops Mgr its just based on the date of the month. So if you select 30 then you will not get a report for February.

Regards

adai

aflores
51,885 Views

Hi Adai,

While DFM clie help indicate that you can set a schedule for the 'last day of the month', It has never work in my case and the setting always refers to the actual day that the given report will be run. This is really disappointing since other part of the application can retrieve the last day of the month without issue.

dfm schedule create help

 

NAME

    create -- create a schedule

 

SYNOPSIS

    dfm schedule create { -H mm | -D hh:mm | -W "day hh:mm" | -M dd:hh:mm } <schedule-name>

 

DESCRIPTION

    -H specifies hourly schedule.

    -D specifies daily schedule.

    -W specifies weekly schedule.

    -M specifies monthly schedule.

    hh specifies the hours.

    hh:mm specifies the hours and minutes.

 

    day specifies the day of the week for weekly schedule.

 

    dd specifies the day of the month for monthly schedule.

    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.

adaikkap
51,885 Views

Can you clarify what you are trying to schedule ? Is it a report or a Backup ?

Regards

adai

Public