Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 8 Auditing Accesses : Initiating a Reporting Session

Initiating a Reporting Session
If you want to run, edit, or delete reports, you can initiate a reporting session from the Audit Log screen.
Steps to Initiate a Reporting Session
To initiate a reporting session, complete the following steps:
1.
From the List of known filters screen, type R in the line command field of the filter that you want to use.
2.
This displays a screen similar to the one below.
List of Known Reports Screen

 
List of known reports for current user
Command ==> Scroll P
NAME TYPE SUMMARY*
---------------- -------- ------------------------------------------------
_ @ACCESS_BY_DATE DEFAULT Accesslog report broken down by date
_ @ACCESS_BY_OBJCT DEFAULT Accesslog report broken down by object name
_ @ACCESS_BY_USER DEFAULT Accesslog report broken down by user
_ @ACCESS_BY_USER2 DEFAULT Accesslog report broken down by user
_ @ACCESS_OBJ_DATE DEFAULT Accesslog report broken down by object name and
_ @ACCESS_OBJ_SUM DEFAULT Accesslog report broken down by object name with
_ @ACCESS_USER_SUM DEFAULT Accesslog report broken down by user with failur
_ @ACCESS_USR_DATE DEFAULT Accesslog report broken down by user and date
D-Delete E-Edit R-Run
PFKEYS: 12=EXIT 13=PRINT 3=END 5=FIND NEXT 9=RECALL

 
Running a Report
To run a report, complete the following steps:
1.
From the List of known reports screen, type R in the line command field of the report that you want to use.
2.
This displays a screen similar to the one below.
Audit Log Report Screen

 
------------------------------------------------------------------------------
Audit Log Report
Report: @ACCESS_BY_OBJCT - Accesslog report broken down by object nam
Report Criteria: OBJECT_ACCESS - Accesses on all object types
------------------------------------------------------------------------------
Report Dates from: 20000302 to: 20000318
Report Destination:
X Printer
Message Log
File:
PFKEYS: 1=HELP 3=END 2=LOG BROWSE 12=END ENTER=RUN REPORT

 
From this screen you can change the date range used for the report and send your report to a printer, the message log, or an external file. By default, the destination for the report is the printer defined for your session.
Modifying the Date Range
To modify the range of dates used for the data, enter new date ranges in the date range fields, using the format yyyymmdd. You can also specify an asterisk (*) as a wildcard character to represent an entire date:
An asterisk in the Report Dates from field means the earliest date in the access log.
An asterisk in the Report Dates to field means today’s date.
Viewing the Report in the Message Log
If you want to view the report in the message log, complete the following steps:
1.
Delete the X to the left of the Printer field.
2.
Type X to the left of the Message Log field.
3.
4.
If the report is too large to view in the Message Log, send the report to your printer or to an external file.
Sending the Report to an External File
To send your report to an external file, complete the following steps:
1.
The file can be sequential or partitioned and must have Record Format FB, and LRECL of 120 or larger.
This step is not required for the Open Systems platforms.
2.
Delete the X to the left of the Printer field.
3.
If the file is a partitioned data set put the member name in brackets, for example, FILE: SEC00.AUDIT.REPORT(PERMISSIONS)
If the file is a Windows or Solaris file, enter only the filename. The path is determined from your Open/Import/Export session option.
4.
Editing a User Defined Report Definition
If you require a different set of criteria for a report or you want to create a new report, initiate an editing session from the screen listing the reports. You cannot modify a default report. To save editing changes that are made to a default report, rename the report before you save it.
To edit a report definition, complete the following steps:
1.
Type E in the line command field of the report that you want to use.
2.
This invokes the Report Definer with a definition of the selected report displayed, as shown below (first 80 columns shown).
Report Definer Screen

 
DEFINE REPORT: @ACCESS_BY_OBJCT Unit: NEWSEC
Command ===>
Page Length: 60 Page Width : 132 Fill Missing Data :
REPORTTABLES: Origin Max Max Title Blank Title Heading Title Final
Name Row Col Occ Acr Only Overlap Rows Rows Cols Cols
---------------- --- --- ---- ---- - - -- -- --- ---
_ @ACCESS_BY_OBJCT 2 1 * 0 N 2 3 0 0
_ @ACCESSLOG_FILTR 1 1 1 0 Y 1 0 0 0
_ @ACCESSLOG_DATES -2 50 1 0 Y 2 0 0 0
_
_
CONTROL BREAKS: Max Repeat Title Body Control
Name Acr Head Rows Reporttable Break Field
---------------- ---- - -- ---------------- ---------------
_ 0 @ACCESS_BY_OBJCT OBJECT
_ 0 @ACCESS_BY_OBJCT
_ 0
PFKEYS: 3=SAVE 12=CANCEL 2=DOC 22=DELETE 6=PAINT 13=PRT 21=DISPLAY 16=LITERAL

 
Deleting a User Defined Report
You can delete reports that you define but not default reports. To delete a report, complete the following steps:
1.
Type D in the line command field of the report that you want to delete.
2.
You are prompted to confirm the deletion.
See Also
TIBCO Object Service Broker Defining Reports about defining reports.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved