How to save scheduled reports to a folder instead of sending it via email? (74181)

How to save scheduled reports to a folder instead of sending it via email?

Is it possible to get Foglight to save a PDF or Excel report to a folder (like a UNC), instead of mailing it to a SMTP address?

To implement this functionality, please follow the procedure below, to create one of the following custom rules.

SaveReportToLocalDrive (updated version),  SaveReportToLocalDrive_2 (alternate version), and  SOL74181_SaveReportToLocalDrive_0

These are "Event Driven" rule to save a report to a local drive. Attached to the solution is a XML file which can be import to the FMS using fglcmd command.

1. Copy the xml file to "$FMS_HOME/bin" folder.
2. Open command prompt and navigate to bin folder.
3. Type command: fglcmd -usr foglight -pwd -cmd util:configimport -f SaveReportToLocalDrive.xml

NOTE:  In our testing, this would ONLY write to a local drive.  Designating a Windows shared drive will not produce results.

The details of the implementation are as follows:

Import the file using command above and the new rule “Save Reports to Local Drive” will be created.

It is a simple rule, which is "Event Driven". It will be triggered on "ReportGeneratedEvent" events.
The rule contains two Rule Variables:

•  path:  Edit for the path on the FMS hosts file system the reports should be saved to (Ensure the path does not have quotes surrounding it)
•  filename:  The file name of the report should have.  The default auto-generates per the actual report name.

Defaults name is "Name of Report_Date and Time Run.file type", for example: Test 5 minute performance report_2010-Jul-29_1207.PDF
The severity level variable are:
a. saveReport: runs some very simple groovy to save the contents of the report to the path and file name specified.

Currently it puts all reports in the same directory. To put different reports in different directories, make new copies of the rule.
In each copy of the rule, edit the "path" rule variable and the condition to run only on the report name that should go into that directory; for example: edit the rule condition

from:

       true;

to:

         reportObj = @event.get("report");
         reportName= reportObj.get("name");
         reportId= reportObj.get("reportId");

to copy only reports called "xxx" to the given directory.  Alternative we can do partial report name match by changing the if condition ".equals" to ".contains" as follow:

          if (reportName.contains("xxxx"))

to copy all reports which name contains string xxxx as part of the name. Useful for multiple reports sharing partial name and are required to move to same folder.

The file name can be configured in the "filename" rule variable if the name should have a different format.

The usage of the "updated" version of the rule is described above. The usage of the alternate version of the rule is described in the Additional Information section.   

SaveReportToLocalDrive (updated version) - Can be used on a specific report you must define in the rule.

SaveReportToLocalDrive_2 (alternate version)  - Can be used to have ALL scheduled reports saved to local drive.

NOTE: This is a custom rule and is not supported by Quest. The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, For assistance with this customization please contact our Professional Services Organization.

SaveReportToLocalDrive (updated version)
SaveReportToLocalDrive_2 (alternate version)
SOL74181_SaveReportToLocalDrive_0

The rule in the SaveReportToLocalDrive2.zip file can be used instead if the rule in the SaveReportToLocalDrive.zip file does not save scheduled reports as expected. The rule in the SaveReportToLocalDrive2.zip file also allows the scheduled reports that are saved to be filtered. There are 2 variables ("filterList" and "exclude") in the rule condition to control which reports should be exported. When "exclude" is set to true, the reports configured in "filterLilst" will be ignored. When "exclude" is set to false only reports in "filterList" will be exported. The default value is true.