securitysavy

Scheduled Report Automation Feature Request

Discussion created by securitysavy on Jun 22, 2011
Latest reply on Jun 24, 2011 by securitysavy

Community - please note your interest in this feature with a note if you like it.

 

ESE-467 - If you wish to request this as well from RSA support.

 

 

Due to the number of scheduled reports we have setup for our customers and the significant duplication of effort that happens for each one, we would like a feature to create a scheduled report via executable or scripts, similar to the other scripts that you have constructed for enVision.

 

This would greatly reduce the administrative burden for our company by reducing a process with 30 keyboard/mouse actions to around 10.  The exes/scripts should require all parameters on the command line to allow for automation, as opposed to prompting the user for information, as that does not simplify the process.  We also have need to create a Report Result Folder in a scripted fashion.  These scripts should not require a stop/start/restart of any object, outside of what the GUI features do today by necessity.

 

We feel this feature would enable other customers to improve ROI by reducing the administrative burden of reporting with enVision.  It is also a logical addition to your product as customers’ usages grow.  This design shown provides customer flexibility so that any customer may implement the feature as they require.

 

==============================================================================

Executables or Scripts could be designed like this:

 

CreateReportResultFolder <Report Result Folder Parent Path> <New Folder Name>

 

CreateScheduledReport <Task Name> [<Enabled>] <Report Name Path> [<Device groups>] <Report Result Folder Path> [-Relative <Relative Time Range> <Use Last Complete Time Range> | -Custom <Start Date/Time> <End Date/Time> ] [<Email Option>] [<Result Set Size>] [<Display In Web>] [<Create PDF>] [< Create CSV>] [<Directory Path>] [<Schedule Immediate>| <Schedule Recurring> <Start Time> [<Every Hour>] [<Days Of Week>|<Days Of Month>|<Every Day>] [<Months>| <Every Month>] [<Non-recurring>]]

 

These would automatically add the scheduled report to any database tables and enVision configurations necessary.  There would be no need to stop/start/restart anything.  The enVision web interface would instantly display the new Report and Report Result Folder.

 

==============================================================================

Scheduled Report Automation Process Version 1:

  1. Request comes in to create a new scheduled report.
  2. User logs into enVision and creates a Scheduled task using the CreateReportResultFolder exe/script on the A-srv.  All values are entered in.
  3. User logs into enVision and creates a Scheduled task using the CreateScheduledReport exe/script on the A-srv.  All values are entered in.

 

Scheduled Report Automation Process Version 2:

  1. Request comes in to create a new scheduled report.
  2. User logs into enVision and creates a Scheduled task using a custom script/application which requires certain information for the new report.  This may require as much as the customer desires, and may use hardcoded values to streamline the process.
  3. User enters the information needed and then this custom code executes the CreateReportResultFolder and CreateScheduledReport scripts/code based on customer needs.

 

Scheduled Report Automation Process Version 3:

  1. Request comes in to create a new scheduled report.
  2. User opens a custom script/application which requests certain information for the new report.  This may request as much as the customer desires, and may use hardcoded values to streamline the process.
  3. User enters the information needed and then this custom code executes the CreateReportResultFolder and CreateScheduledReport scripts/code based on customer needs.

Outcomes