![]() |
|||
![]() |
![]() ![]() |
![]() |
![]() ![]() |
![]() |
![]() ![]() |
![]() |
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Chapter 5Accounting and ReportingThis chapter covers the following topics: Starting the Accounting and Reporting ConsoleThe accounting and reporting console is installed separately from the N1 Grid Engine 6 software. For details on the installation process, see Chapter 8, "Installing the Accounting and Reporting Console," in N1 Grid Engine 6 Installation Guide. In addition, you must enable your grid engine system to collect reporting information. For details on how to enable the collection of reporting data, see "Report Statistics (ARCo)" in N1 Grid Engine 6 Administration Guide.
|
https://hostname:6789 |
Log in with your UNIX account, and then select N1 Grid Engine 6 ARCo.
After successful login, select the N1 Grid Engine 6 ARCo application. You are redirected to the Overview page, that shows you a list of predefined ARCo queries.
Note - The direct link to the ARCo application is https://hostname:6789/console/login/Login?redirect_url=%22/reporting/arcomodule/Index%22)
If you press the tab labeled Result List, you see any stored Query Results. Clicking on Query List brings you back to the Query List overview.
The query defines the data set that you want to retrieve. You can create simple queries, and the system formulates the SQL query string for you. Or if you know SQL and you want to write the query yourself, you can create advanced queries.
Go to Query List and press the New Simple button.
The following screen appears with three tabs showing common information like the query category and description. This information is optional. The Simple Query tab is the place where you define the query and the View tab where you define the configuration how to display the results of the query.
Clicking on the Simple Query tab displays the Query definition page. The page is divided into:
a Table/View dropdown menu you use to choose a database table or view to predefine your query
the Field List where all the fields that you are interested in are listed as a row
a Filter List for defining filter conditions for your query
the Row Limit textbox to restrict the number of result entries for your query.
The single steps how to construct a simple query are outlined as follows.
Select a table from the table list.
Define the fields you want to see.
The Field Function describes the functionality used for the field. The following table lists the supported values of Field Function.
Function | Description |
---|---|
VALUE | Use the current value of the field |
SUM | Accumulate the values of the field |
COUNT | Count the number of values of the field |
MIN | Get the minimum value of the field |
MAX | Get the maximum value of the field |
AVG | Get the average value of the field |
The Field Name is a field in the selected table.
The User Defined Name allows the results to display a more meaningful name.
Sort allows to define the sorting order for every field if needed.
(Optional) Define Filters.
You must specify at least one field before you can define filters.
AND/OR is needed for any filter except the first. This is the logical connection to the previous filter condition.
The Field Name is the name of the field to be filtered. If a field has a user-defined name, it is shown in the selection list. Otherwise a generated name is shown.
The Condition field specifies the operators that are used to filter the values from the database. The following table lists the supported operators.
Filter | Symbol | Description | Number of Requirements |
---|---|---|---|
Equal | = | The value must equal the Requirement | 1 |
Not Equal | <>, != | The value must not equal the Requirement | 1 |
Less Than | < | The value must be less than the Requirement | 1 |
Less Than or Equal | <=, <= | The value must be less or equal the Requirement | 1 |
Greater Than | > | The value must be greater than the Requirement | 1 |
Greater Than or Equal | >=, >= | The value must be greater or equal the Requirement | 1 |
Null | The value must be null | 0 | |
Not Null | The value must not be null | 0 | |
Between | The value must be in a specified interval | 2 | |
In | The value must be equal to an element of a specified list | 1 or more | |
Like | The value must contain the given Requirement | 1 |
The Requirement field contains a value that is used for filtering the values returned by the query. The following list contains some examples of things that might go into the Requirement field.
1 AND 100 | For a between condition. |
d% | For a like condition. |
%d% | For a like condition. |
%d%e% | For a like condition. |
Wert-1', Wert-2', ... , 'Wert-n | For an in condition. |
(Optional) Limit the number of data sets.
If you want to limit the number of data sets, select the Limit Query To First check box. Then enter the number of data sets you want returned.
Click Save to save the query.
The following figure displays the Save this Query As screen. Use the Query Name field to give your query a name, and then click Ok.
After you save your query, you return to a modified version of the Simple Query screen.
![]() ![]() |