Function
This command creates a scheduled report that has been registered using the Scheduled Report View. If this command is registered with a scheduler, the operation can be performed automatically.
Created reports can be viewed in the Scheduled Report View.
Privileges required for execution
The privileges of a user belonging to the "Administrators" group are required to execute this command.
Note
To execute this command under Windows Server 2008/Windows Vista and later, execute with the administrator privilege.
For Windows Server 2012/Windows 8
Right-click the Start menu (located at the bottom-left corner of the Desktop) and select Command Prompt (Admin). Run the command from the Command Prompt.
For Windows Server 2008/Windows 7/Windows Vista
From the Start menu, select All Programs - Accessories, then right-click Command Prompt, and select Run as administrator. Run the command from the Command Prompt.
To execute this command by registering it with Task Scheduler for the Windows Server 2008/Windows Vista and later, select the General tab of the Properties window for the task to be registered, and then select the Run with highest privileges checkbox.
Execution environment
This command can be executed on an operation management client
Syntax
<Installation directory>\ bin\sqcMakeReport.exe | -c console_define [-g system_group] [-t begin_time | -w begin_day | -d begin_date] daily|weekly|monthly |
<Installation directory>\ bin\sqcMakeReport.exe | -c console_define [-g system_group] [-s start_day -e end_day] daily|weekly|monthly |
From here onwards, the syntax is for linkage to ServerView Resource Orchestrator.
<installation directory>\bin\sqcMakeReport.exe | -a COMMON_REPORT [-t begin_time | -w begin_day | -d begin_date] daily|weekly|monthly |
<installation directory>\bin\sqcMakeReport.exe | -a COMMON_REPORT [-s start_day -e end_day] daily|weekly|monthly |
<installation directory>\bin\sqcMakeReport.exe | -r tenant_name [-t begin_time | -w begin_day | -d begin_date] daily|weekly|monthly |
<installation directory>\bin\sqcMakeReport.exe | -r tenant_name [-s start_day -e end_day] daily|weekly|monthly |
Options
Specifies the console definition name for the report to be created. If a report is being created by specifying the console definition name, this parameter cannot be omitted.
This option can not be specified simultaneously with -a and -r.
Specifies the system group name. Only registered scheduled reports whose conditions include the specified system group will be created. If this option is omitted, all scheduled reports that have been registered will be created.
Point
By registering the command with a scheduler with this option specified, report scheduling can be performed in system group units.
Specifies the time (0 to 23) in local time that a daily report will start. A daily report will be created from 24 hours of data that commences at the specified time. If this option is omitted, the starting time defaults to "0".
Specifies the day of the week (Su, Mo, Tu, We, Th, Fr, Sa) that a weekly report will start. A weekly report will be created from 7 days of data that commences on the specified day of the week. If this option is omitted, the starting day defaults to Sunday ("Su").
Specifies the date (1 to 28) that a monthly report will start. A monthly report will be created from one month of data that commences on the specified date. If this option is omitted, the starting date defaults to "1".
This option is used to set the term of the report when executing this command manually. It specifies the starting date of the report. The format of the starting date is as follows:
YYYYMMDD
This option is used to set the term of the report when executing this command manually. It specifies the ending date of the report. The format of the ending date is as follows:
YYYYMMDD
If linking to ServerView Resource Orchestrator, create the reports that have been registered as common reports in tenant units.
This option can not be specified simultaneously with -c and -r.
If linking to ServerView Resource Orchestrator, specify the tenant name or L-Platform name.
This option can not be specified simultaneously with -c and -a.
Operand
Specifies the report format (daily, weekly or monthly).
Return value
0: Normal termination
> 0: Abnormal termination
Note
If the console definition read fails, then the message below will be displayed:
The console definition name specified in the -c option might not be correct. Check the name and then try again.
Faild : Policy.xml download from Manager
Usage example 1
The following example shows how to generate a daily report that begins at 9:00 am. It generates only reports where Business System A is specified for the registration conditions for scheduled reports.
> sqcMakeReport -c DefaultConsole -g Business System A -t 9 daily |
Usage example 2
The following uses registered scheduled reports to generate a daily report for 01 September 2012.
> sqcMakeReport -c DefaultConsole -s 20120901 -e 20120901 daily |
Usage example 3
If linking to ServerView Resource Orchestrator, the following uses registered common reports to generate a daily report for 01 September 2012.
> sqcMakeReport -a COMMON_REPORT -s 20120901 -e 20120901 daily |
Usage example 4
The following uses reports registered in tenant A to generate a daily report for 01 September 2012.
> sqcMakeReport -r tenant A -s 20120901 -e 20120901 daily |
Note
When the Report Creation Command is executed, a number of pop-up messages such as the one shown below may open and then close on the Windows desktop momentarily.
These windows are displayed when data is extracted from a PDB. They do not indicate a problem.
Exception code: If the command terminates abnormally with exception code 0xe06d7363, the desktop heap may be insufficient. Increase the size of the desktop heap by referring to "How to increase the size of the desktop heap" of the User's Guide (Console Edition).
These pop-up windows can be prevented by specifying a different user from the usual login user in the "Run as:" option when registering the command with the scheduler.
After executing the Scheduled Report Creation Command, check the results in the Scheduled Report View, as explained in "Scheduled Report View" of the User's Guide (Console Edition).
