Loading...

Large Clients Report

The Large Clients Report provides a list of the largest clients based on the number of jobs that ran on each client. Aged jobs and active jobs can be included or excluded.

Running the Report

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    qoperation execscript -sn QS_LargestClients -si @LastDays='<number of days>' -si @TopN='<number of jobs>' –si @CountAgedJobs=’<include or excluded aged jobs>’ -format 'csv' –file '<output location and filename>'

    The report is saved in the location that you specified.

Example

To see the largest clients in the CommServe over the last 31 days, with aged jobs excluded, run the following command:

qoperation execscript -sn QS_LargestClients -si @LastDays='31' -si @TopN='20' –si @CountAgedJobs=’0’ -format 'csv' –file 'C:\Reports\sample.csv'

For more information about the execscript command, see Command Line Interface - CommServe - Qoperation Execscript.

Usage and Help

  1. Open the command prompt and navigate to the <software installation path>\Base> folder.
  2. Enter qlogin, and then enter your user name and password.
  3. Run the following command:

    qoperation execscript -sn QS_LargestClients -help

Parameters

The report script includes several parameters that you can set, according to your information needs. Parameters for the Large Clients Report include the following:

Parameter

Description

Default Setting

LastDays

Numeric value. Specifies the number of days over which the report gathers information.

1

TopN

Numeric value. Specifies the maximum number of jobs from each client to include in the report information.

10

CountAgedJobs

This switch includes or excludes aged jobs. Options include the following:

  • Include: 1
  • Exclude: 0

0

format

Text only. Specifies the file format in which the report saves. Options include the following:

  • CSV

N/A

file

Text only. Specifies the location and name of the saved report.

N/A

Last modified: 8/16/2018 6:50:36 PM