Sample reports

This appendix contains samples of most of the report types available in RA. The various sequences available for each report are shown: the values for /report and /sequence for the DCL command used to create the report are shown. Additional qualifiers needed for the report are shown as well, [square brackets] indicate optional..

Sample Reports

(A sample command to generate the report is shown)

/report=

/sequence=

other sequences & useful qualifiers

DETAIL (invoice)**

1-3 page itemized summary

USER

GROUP [/user=username]

ACCOUNT [/group=group]

PROJECT [/account=account]

	[/project=project]

	$ ra /input=node_month.sav /report=detail /user=kit_build

	ACCOUNT

	none

	none

	$ ra /input=node_month.sav /report=account

	FIXED**

	none

	none [/user=username]

	$ ra /input=node_month.sav /report=fixed /user=kit_build

RESOURCE

	none

	none

	$ ra /input=node_month.sav /report=resource

	REVENUE

	none

	none

	$ ra /input=node_month.sav /report=resource

SUMMARY or

EXPORT*

ACCOUNT

USER [/specification=spec_file]

GROUP
UIC
UIC_GROUP

PROJECT

$ ra /input=node_month.sav /report=summary /sequence=account -

/specification=default_summary.spc

IMAGE

USER

	IMAGE [/user=username]

	$ ra /input=node_month.sav /report=image /user=* /sequence=user

	COST_DETAIL

	ACCOUNT

GROUP /chargeable=dollars

	UIC_GROUP [/include=revenue_type]

$ define ra_acc_width 1

$ ra /input=node_month.sav /report=cost_detail /sequence=account -

/chargeable=10000 /include=revenue

COST_SUMMARY

UIC_GROUP

	ACCOUNT same as cost_detail

$ ra /input=node_month.sav /report=cost_summary /sequence=uic_group -

/chargeable=10000 /include=both

COST_USER

ACCOUNT

	GROUP same as cost_detail

$ ra /input=node_month.sav /report=cost_user /sequence=account -

/chargeable=10000 /include=revenue

TRACE

none

	none /user=username

	$ ra /input=node_month.sav /report=trace /user=kit_build

* the summary or export reports use specification files to control their format. The default files are default_summary.spc and default_export.spc; in the examples the user_widesummary.spc was used for both – the contents of this specification file are shown on page .

** this report can be generated for specific users by adding the /user=username qualifier. The qualifiers /account=account, /group=group and /project=project can also be used with the detail report.

Detail report sample

                      Saiga Systems Software Inc.
       Itemized Summary of Services from 3_JAN_2000 to 17_JAN_2000
To:                                        For:
                                                         Same




Username: KIT_BUILD           Account: MANAGER         UIC: [   100,     1]

                                  PRIME Time

Description of Charge         Quantity           Rate               Charge
_____________________________________________________________________________
Printer pages:                     1 pages    @ 0.0500/page     $      0.05
                                                              _____________
                                                              $        0.05
Interactive (    28 Logins)

Connect time at 2400 baud    22.764 hours    @ 10.0000/hour     $    227.64
CPU time: Class 1            17.790 seconds @ 0.1800/cpu sec. $      3.20
CPU time: Class 2           188.890 seconds @ 0.1600/cpu sec. $     30.22
CPU time: Class 3           345.320 seconds @ 0.1400/cpu sec. $     48.34
DIO I/O operations:           37.928 thousand @ 0.6000/thousand $     22.76
BIO I/O operations:           85.584 thousand @ 0.6000/thousand $     51.35
Chargeable images:          1461.000 activations                 $    227.65
                                                              _____________
                                                              $      611.16
Batch       (     7 Logins) Batch Discount Rate   0.50

CPU time: Class 3           201.220 seconds @ 0.0700/cpu sec. $     14.09
DIO I/O operations:           71.351 thousand @ 0.3000/thousand $     21.41
BIO I/O operations:           33.147 thousand @ 0.3000/thousand $      9.94
                                                              _____________
                                                              $       45.44

                           PRIME total before discount        $      656.65

PRIME total before discount                                           656.65
Avg. Daily Disk Storage:      249572 blocks   @ 0.0100/blocks   $   2495.73
                                                              _____________
Total before discounts                                               3152.38
Less discount for disk storage                                       _968.32
Less dollar volume discount                                           _68.41
                                                              _____________
Total Discounts                                                     _1036.73
Fixed charge                                                          110.00
                                                              _____________
                                                              $     2225.65
                                                              =============

Fixed Billing Report Sample

DATE: 11_JAN_2000             FIXED BILLING REPORT                  PAGE:     1
                                    for
                                 KIT_BUILD

Date                   Description                                     Charge
________________________________________________________________________________
01/10/2000 10:57:25    Rebuild kits for product RA version 70            10.00
01/10/2000 11:04:14    COMPARE COMMON                                     5.00
01/10/2000 11:05:14    COMPARE FERRET                                     5.00
01/10/2000 11:07:23    COMPARE HITMAN                                     5.00
01/10/2000 11:11:34    COMPARE RA                                         5.00
01/10/2000 11:17:33    COMPARE SWAP                                       5.00
01/10/2000 11:18:49    COMPARE TRACE                                      5.00
01/10/2000 11:19:53    COMPARE VDM_new                                    5.00
01/10/2000 11:25:33    COMPARE WATCH                                      5.00
01/10/2000 11:27:11    RA fixed monthly charge                           40.00
                                                                 ============
                                                    Total:              90.00

Specification file sample

! This is the default specification file. These files are used in

!    conjunction with the summary and export reports. Within these files you
!    specify which fields you want displayed, the format to display them,
!    and finally a scaling factor.
!
!    LINE FORMAT
!    Each line can contain a comment symbol ("!") and once this is encountered
!    the rest of the line is ignored. You must have all 3 parameters specified
!    on each line in the correct order. The parameters are:
!
!        1) FIELD NAME
!        2) FORMAT
!        3) FACTOR
!
!    FIELD NAME
!    The field names are described in the manual. All the possible values for
!    field names are included in this file, but some are commented out. If you
!    decide that you would like to include this field in your report, you
!    just uncomment the line.
!
!    FORMAT
!    The format parameter allows you to specify the format of the field's
!    value. The basic format is "a.b". "a" is required as it specifies the
!    field's width. ".b" is optional as it specifies the number of decimal
!    places to display. For example, you may want to display whole values
!    for the number of printer pages so you would specify "8" if
!    you wanted the field eight characters wide with no decimal places.
!    For the print charges you probably would want to display down to
!    the nearest cent so you would specify "8.2", which would indicate
!    that the field is eight characters wide which includes two decimal places.
!
!    FACTOR
!    Three factors are allowed:
!        1 _ values are left as collected
!        K _ values are divided by 1,000 before being displayed
!        M _ values are divided by 1,000,000 before being displayed
!
!
!GROUP_COUNT,4,1        ! number of users in a group, account, etc

CONNECT_USAGE,7.1,1 ! number of connect hours

CPU_USAGE,7,1        ! number of cpu seconds
!BIO_USAGE,8,1        ! number of buffer io
!DIO_USAGE,8,1        ! number of direct io

IO_USAGE,5,K ! combination of bio's and dio's

IMAGE_uSAGE,4,1 ! number of chargeable image activations
TAPE_USAGE,4,1 ! number of tape mounts

PRINTER_USAGE,4,1 ! number of pages printed

DISK_USAGE,6.1,K ! number of disk blocks

CONNECT_CHARGE,6,1 ! charge for the connect_usage

CPU_CHARGE,6,1 ! charge for the cpu_usage

!BIO_CHARGE,6.2,1 ! charge for the bio_usage

!DIO_CHARGE,6.2,1 ! charge for the dio_usage

IO_CHARGE,6,1 ! charge for combined io_usage

IMAGE_CHARGE,5,1 ! charge for the image_usage

TAPE_CHARGE,4,1 ! charge for the tape_usage

PRINTER_CHARGE,4,1 ! charge for the printer_usage

!PROCESSING_CHARGE,8.2,1 ! combination of all charges except disk

DISK_CHARGE,8.2,1 ! charge for the disk_usage

FIXED_CHARGE,7.2,1 ! any fixed charges that apply

!DISK_DISCOUNT,7.1,1    ! discount based on disk usage
!VOLUME_DISCOUNT,7.1,1    ! discount based on dollar values
TOTAL_DISCOUNTS,8.2,1    ! combination of disk and volume discounts

TOTAL_CHARGE,10.2,1 ! total charge after any discounts

Account Report Sample

     Date: 11_JAN_2000      Saiga Systems Software Inc.               Page:     1
                        Total charges by ACCOUNT           Created on: ROC
                     from 3_JAN_2000 to 10_JAN_2000

The processing column reflects all non_disk charges minus any discounts
* _ No record in CLIENT file for this user, Default charge rates used.

Account   Username            UIC          Processing       Disk      Total
_______   ________            ___          __________       ____      _____
                                     $            $            $
ADMIN    SYSTEM       [     1,     4]      2162.20         0.00       2162.20
                                     ____________ ____________ _____________
                                          2162.20         0.00       2162.20
                                     ____________ ____________ _____________

DECNET   DECNET       [   376,   376]         2.81         0.19          3.00
        FAL$SERVER   [   376,   373]         2.81         0.19          3.00
        MAIL$SERVER [   376,   374]         2.61         0.39          3.00
        MIRRO$SERVER [   376,   367]         2.88         0.12          3.00
        NML$SERVER   [   376,   371]         2.88         0.12          3.00
        PCFS$ACCOUNT [   360,     1]      _641.81      3141.81       2500.00
        PDFS$ACCOUNT [   360,     1]         3.00         0.00          3.00
        PHONE$SERVER [   376,   372]         2.81         0.19          3.00
        PWRK$DEFAULT [   360,     1]         3.00         0.00          3.00
        PWRK$GUEST   [   360,     2]         2.93         0.07          3.00
        SCA$DEFAULT [   371,   345]         3.00         0.00          3.00
        SCA$SERVER   [   370,   355]         2.96         0.04          3.00
        VPM$SERVER   [   376,   370]         2.88         0.12          3.00
                                     ____________ ____________ _____________
                                          _607.24      3143.24       2536.00
                                     ____________ ____________ _____________

DEV      BASIC_USER   [   200,    22]        25.00         0.08         25.08
        FTEST        [   200,    14]        25.00        72.86         97.86
        F_PRIV_TEST [   200,   200]        25.00         0.00         25.00
        GILBERTS     [   200,    12]        25.00       712.38        737.38
        GILBERTS_021 [   200,    21]        25.00         0.00         25.00
        HTEST        [   200,    16]        25.00       221.10        246.10
        NORMA        [   200,    20]        25.00        12.59         37.59
        NORMA_NEW    [   200,    50]         0.00         7.76          7.76
        PRIVTEST     [   700,   700]        25.00         0.15         25.15
        PROGRAMMER   [   200,    13]        25.00         1.35         26.35
        RASMUSSONA   [   200,     1]     _2754.05      5254.05       2500.00
        SIM          [   200,    23]        25.00         0.17         25.17
        TEST         [   500,     1]        25.00        63.15         88.15
        TRACE_TEST   [   200,    20]        25.00         0.00         25.00
        VTEST        [   200,    15]        25.00       123.08        148.08
                                     ____________ ____________ _____________
                                         _2429.05      6468.72       4039.67
                                     ____________ ____________ _____________

. . . portion of report deleted here . . .

_19209.62 32941.83 13732.21
============ ============ =============

Image Report Sample

Date: 11_JAN_2000                                Saiga Systems Software Inc.                                         Page:     1
                                                    IMAGE REPORT by USER                                       Created on: ROC
                                               from 3_JAN_2000 to 10_JAN_2000

       Image Name                              Charge    |_________ Activations __________||___________ Charges _________________|
                                                Flag         Prime           Non_Prime          Prime         Nonprime       Total
                                                         Inter    Batch    Inter    Batch   Inter   Batch   Inter   Batch

User: KIT_BUILD    Account: MANAGER      Group:
       DIFF                                       U       1451        0        0        0 217.65    0.00    0.00    0.00   217.65
       RTPAD                                      A          3        0        0        0    3.00    0.00    0.00    0.00     3.00
                                                      ________ ________ ________ ________ _______ _______ _______ _______ ________
                                                          1454        0        0        0 220.65    0.00    0.00    0.00   220.65

User: SYSTEM       Account: ADMIN        Group: OVERHEAD
       DIFF                                       U          2        0        0        0    0.30    0.00    0.00    0.00     0.30
       RTPAD                                      U          2        0        0        0    0.50    0.00    0.00    0.00     0.50
                                                      ________ ________ ________ ________ _______ _______ _______ _______ ________
                                                             4        0        0        0    0.80    0.00    0.00    0.00     0.80

                                                      ======== ======== ======== ======== ======= ======= ======= ======= ========
                                                          1458        0        0        0 221.45    0.00    0.00    0.00   221.45

Summary Report Sample

Date: 11_JAN_2000                                Saiga Systems Software Inc.                                    Page:     1
                                                     SUMMARY by Account                                        Created on: ROC
                                               from 3_JAN_2000 to 10_JAN_2000

Resource usage for BATCH & NON BATCH PRIME and NON_PRIME time
Any charges are DISCOUNTED
* _ No record in CLIENT file for this user. Default charge rates used.

         Connect   CPU    IO   Imag Tape Prin Disk Connec CPU     IO   Image Tape Prin   Disk    Fixed   Total     Total
Account   Hours   Sec.   Count Act Mnts Page Blocks Charge Charge Charge Charg Char Char Charge Charge Discount   Charge
                           K                    K      $      $      $      $    $    $      $        $       $         $
________ _______ _______ _____ ____ ____ ____ ______ ______ ______ ______ _____ ____ ____ ________ _______ ________ __________
             0.0       0     0    0    0    0 664.5      0      0      0     0    0    0 6645.33    0.00 2874.95    2659.93
1{}|*        0.0       0     0    0    0    0    0.0      0      0      0     0    0    0     0.00    0.00     0.00       3.00
ADMIN      186.1    3986   739    4    3    0    0.0   1643    330    257     1    6    0     0.00    0.00    73.59    2162.20
DECNET       0.0       0     0    0    0    0 518.8      0      0      0     0    0    0 5187.83    0.00 2215.88    2536.00
DEV          0.0       0     0    0    0    0 1049.6      0      0      0     0    0    0 10496.20 350.00 4591.03    4039.67
DSNLINK      0.0       0     0    0    0    0    0.0      0      0      0     0    0    0     0.24    0.00     0.00       3.00
MANAGER      4.5     483   201 1454    0    0 248.7     45     58     87   221    0    0 2486.98   90.00 1004.74    1982.64
OPER         0.0       0     0    0    0    0 3616.3      0      0      0     0    0    0 36162.60    0.00 19035.30    2725.30
OVER         0.0       0     0    0    0    0    3.9      0      0      0     0    0    0    39.15    0.00     1.27     280.40
OVERHD       0.0       0     0    0    0    0    0.0      0      0      0     0    0    0     0.00    0.00     0.00       3.00
VENDOR       0.0       0     0    0    0    0    0.0      0      0      0     0    0    0     0.00    0.00     0.00       3.00
________ _______ _______ _____ ____ ____ ____ ______ ______ ______ ______ _____ ____ ____ ________ _______ ________ __________
           190.6    4470   939 1458    3    0 6101.8   1687    387    344   221    6    0 61018.33 440.00 29796.76   16398.14

Export Report Sample

        |    0.0|      0|    0|   0|   0|   0| 664.5|     0|     0|     0|    0|   0|   0| 6645.33|   0.00| 2874.95|   2659.93
1{}|*   |    0.0|      0|    0|   0|   0|   0|   0.0|     0|     0|     0|    0|   0|   0|    0.00|   0.00|    0.00|      3.00
ADMIN   | 186.1|   3986| 739|   4|   3|   0|   0.0| 1643|   330|   257|    1|   6|   0|    0.00|   0.00|   73.59|   2162.20
DECNET |    0.0|      0|    0|   0|   0|   0| 518.8|     0|     0|     0|    0|   0|   0| 5187.83|   0.00| 2215.88|   2536.00
DEV     |    0.0|      0|    0|   0|   0|   0|1049.6|     0|     0|     0|    0|   0|   0|10496.20| 350.00| 4591.03|   4039.67
DSNLINK |    0.0|      0|    0|   0|   0|   0|   0.0|     0|     0|     0|    0|   0|   0|    0.24|   0.00|    0.00|      3.00
MANAGER |    4.5|    483| 201|1454|   0|   0| 248.7|    45|    58|    87| 221|   0|   0| 2486.98| 90.00| 1004.74|   1982.64
OPER    |    0.0|      0|    0|   0|   0|   0|3616.3|     0|     0|     0|    0|   0|   0|36162.60|   0.00|19035.30|   2725.30
OVER    |    0.0|      0|    0|   0|   0|   0|   3.9|     0|     0|     0|    0|   0|   0|   39.15|   0.00|    1.27|    280.40
OVERHD |    0.0|      0|    0|   0|   0|   0|   0.0|     0|     0|     0|    0|   0|   0|    0.00|   0.00|    0.00|      3.00
VENDOR |    0.0|      0|    0|   0|   0|   0|   0.0|     0|     0|     0|    0|   0|   0|    0.00|   0.00|    0.00|      3.00

Resource Report Sample

Date: 11_JAN_2000      Saiga Systems Software Inc.               Page:     1
                            Resource Summary               Created on: ROC
                     from 3_JAN_2000 to 10_JAN_2000

                                Job Summary
Interactive     Batch      Sub_process   Printer     Login Fails   Startup

       29           25           42            0           5            1

                          System Resource Usage
  Resource            Prime time         Non_prime time            Total
Disk blocks:                                                           0.
Printer pages:                                                          0
Tape mounts:                                                            3
Logins:                    25                    4                     29
Connect
@ 2400:                146.86                43.77                 190.63
@ 4800:                  0.00                 0.00                   0.00
@ 9600:                  0.00                 0.00                   0.00
@ 19200:                  0.00                 0.00                   0.00
CPU seconds:
  Class1:                  0.00                 0.00                   0.00
  Class2:                  0.00                 0.00                   0.00
  Class3:               3123.64              1346.04                4469.68
  Class4:                  0.00                 0.00                   0.00
  Class5:                  0.00                 0.00                   0.00
  Class6:                  0.00                 0.00                   0.00
  Class7:                  0.00                 0.00                   0.00
  Class8:                  0.00                 0.00                   0.00
  Class9:                  0.00                 0.00                   0.00
DIO thousands:            357.59               195.44                 553.03
BIO thousands:            335.88               133.64                 469.52

                         Revenue Resource Usage
  Resource      Chargeable         Overhead               Total
            Value    Revenue     Value    Expense     Value    Revenue

Disk block       0.         0.00        0.         0.00        0.         0.00
Printer           0         0.00         0         0.00         0         0.00
Tape mount        0         0.00         3         6.00         3         6.00
Logins            5         0.00        24         0.00        29         0.00
Connect          4.5       44.90      186.1     1642.55      190.6     1687.45
CPU            483.4       57.59     3986.3      329.87     4469.7      387.46
DIO             82.5       34.20      470.6      136.00      553.0      170.20
BIO            100.3       53.06      369.3      120.55      469.5      173.61
                   ____________           ____________           ____________
                         189.75                2234.97                2424.72

Date: 11_JAN_2000      Saiga Systems Software Inc.               Page:     2
                            Resource Summary               Created on: ROC
                     from 3_JAN_2000 to 10_JAN_2000

                                 Disk Usage
                           Blocks          Blocks         Blocks        Blocks
Disk   Users   Files        Used          Allocated        Free          Total
DKA100:    98 16272. 1825308. 85.5% 1901183. 89.1%   233122. 10.9% 2134305.
DKA300:    13   1971.   203559. 85.7%   208629. 87.8%    28959. 12.2%   237588.
DKB200:    11 20613. 2500317.128.0% 2572170.131.6% _618120._31.6% 1954050.
DKA200:     8 11044.   758062. 91.1%   791636. 95.1%    40891. 4.9%   832527.
DKA300:    11   3656.   617309. 74.1%   628215. 75.5%   204312. 24.5%   832527.
______ _____ _______ _________ _____ _________ _____ _________ _____ _________
Total     141 53558. 5904554.6 98.6% 6101833.0101.9% _110836.0 _1.9% 5990997.0

Revenue Report Sample

Date: 11_JAN_2000      Saiga Systems Software Inc.               Page:     1
                        Revenue totals by ACCOUNT          Created on: ROC
                     from 3_JAN_2000 to 10_JAN_2000

* _ No record in CLIENT file for this user, Default charge rates used.

Account   Username            UIC           Charges      Revenue Non_revenue
_______   ________            ___           _______      _______ ___________
                                     $            $            $

1{}|*     TEST1        [   500,     2]        3.00         3.00         0.00

ADMIN     SYSTEM       [     1,     4]     2162.20         0.00      2162.20

DECNET    DECNET       [   376,   376]        3.00         0.00      2536.00
         FAL$SERVER   [   376,   373]        3.00
         MAIL$SERVER [   376,   374]        3.00
         MIRRO$SERVER [   376,   367]        3.00
         NML$SERVER   [   376,   371]        3.00
         PCFS$ACCOUNT [   360,     1]     2500.00
         PDFS$ACCOUNT [   360,     1]        3.00
         PHONE$SERVER [   376,   372]        3.00
         PWRK$DEFAULT [   360,     1]        3.00
         PWRK$GUEST   [   360,     2]        3.00
         SCA$DEFAULT [   371,   345]        3.00
         SCA$SERVER   [   370,   355]        3.00
         VPM$SERVER   [   376,   370]        3.00

DEV       BASIC_USER   [   200,    22]       25.08      4039.67         0.00
         FTEST        [   200,    14]       97.86
         F_PRIV_TEST [   200,   200]       25.00
         GILBERTS     [   200,    12]      737.38
         GILBERTS_021 [   200,    21]       25.00
         HTEST        [   200,    16]      246.10
         NORMA        [   200,    20]       37.59
         NORMA_NEW    [   200,    50]        7.76
         PRIVTEST     [   700,   700]       25.15
         PROGRAMMER   [   200,    13]       26.35
         RASMUSSONA   [   200,     1]     2500.00
         SIM          [   200,    23]       25.17
         TEST         [   500,     1]       88.15
         TRACE_TEST   [   200,    20]       25.00
         VTEST        [   200,    15]      148.08

. . portion of report removed here . . .

                                                  ____________ ____________
                                                       8759.61      4975.60
                                                  ============ ============

Detailed Cost Report Sample

Date: 14_JAN_2000             Saiga Systems Software Inc.                Page:     1
                            Detailed Cost Report _ ACCOUNT           Created on: ROC
                           from 3_JAN_2000 to 13_JAN_2000

INCLUDE REVENUE ACCOUNTS ONLY

          LOGINS
INTERACTIVE      BATCH               PRINTED PAGES               TOTAL_ACCOUNTS
___________   ___________            _____________               ______________
       108            65                        0                          133

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

RESOURCE CHARGES DISTRIBUTION BY ACCOUNTS

   &nb