Sun Microsystems
Products & Services
 
Support & Training
 
 

Previous Previous     Contents     Index     Next Next
Chapter 5

Accounting and Reporting

This chapter covers the following topics:

Starting the Accounting and Reporting Console

The 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.

ProcedureHow to Start the Accounting and Reporting Console

Steps
  1. Start a web browser.

  2. Connect to the Sun Web Console by accessing the following URL in your browser:

    In the following example, hostname is the host on which the accounting and reporting software has been installed.

    https://hostname:6789

  3. Log in with your UNIX account, and then select N1 Grid Engine 6 ARCo.

    login screen
  4. 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.

    overview page


    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.

    result page

Creating and Running Simple Queries

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.

ProcedureHow to Create a Simple Query

Steps
  1. 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.

    Query List screen showing list of queries. Shows New Simple Query
and New Advanced Query buttons. Shows Run, Edit, and Delete buttons.

    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.

  2. Select a table from the table list.

    simple select table
  3. 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.

  4. (Optional) Define Filters.

    You must specify at least one field before you can define filters.

    Part of the Simple Query screen showing AND/OR list, Field Name
list, Condition list, Requirement field, late_binding check box, and Inactive check
box.
    • 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.

  5. (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.

    Part of the Simple Query screen showing the Limit Query to First
check box and the limit field.
  6. Click Save to save the query.

    Query List screen showing the Save button.

    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.

    Save This Query As screen showing the Query Name field and other
fields. Shows Ok and Cancel buttons.

    After you save your query, you return to a modified version of the Simple Query screen.

Previous Previous     Contents     Index     Next Next