QJRN/400
AccueilGroovy ?SolutionsNewsPartenairesContact
 

QJRN/400 - A Comprehensive Auditing Platform for the System i


QJRN/400 runs the audit trail provided by database and system journaling. It includes a query manager that enables precise selections, customizable reports and processing methods (in real time or scheduled mode).

STANDARD FEATURES

  • Virtually unlimited scalability to allow companies to audit all vulnerable points      
  • Multiple Reporting Formats
  • Unique event extraction process ensures absolute data integrity       
  • Ability to isolate "critical" events minimizes the size and complexity of reports
  • Real time alarms allow management to quickly react to critical events
  • Report Builder allows non-IT staff to easily create independent reports for auditors and management
  • Platform includes both Database and system Audit modules
  • Ability to create a centralized audit scheme and quickly distribute to remote sites
  • Standard Audit templates to facilitate easy deployment

APPLICATION AUDIT

Control of the integrity of audit parameters

All monitoring scheme must be guaranteed that no modification will be made to the administration rules because they may have an influence when generating traces (e.g.: stopping and restarting file journaling or deleting a receiver without having analyzed it).

Operations carried out outside the information system

You may detect precisely all operations carried out by programs not recognized as a standard part of the application. These could include DFU, SQL, upload Client Access, or "makeshift" programs known to be risky. You will then be given the proper solution to take action.

Operations carried out outside business hours

If you wish to fight fraud, measuring activity outside business hours is an excellent indicator.

Control of the user fields and date of last modification

You may detect the transactions, which don’t correctly update these fields or unusual "makeshift" transactions.

Control of pricing conditions

It is very easy and of little or no risk to change the pricing conditions of a "friend" customer, to create their invoice, then recreate the initial conditions. Standard controls of average prices are not enough to detect this kind of fraud.

Control of sensitive data

Certain information is extremely sensitive and it is sometimes difficult to find the origin of any modification. E.g.: details of bank accounts, elements related to salary, credit limits, credit cards, accounts (text, invoice, due date).

Monitoring of sensitive profiles (remote maintenance, service providers)

Certain profiles need an extended access at application and system levels. So they have to be closely monitored. Having access to confidential information can be quite tempting. It can also be useful to know what took place during the remote maintenance connection time.

Traceability on what was opened

If the application authorizations cannot deny access to certain information, you could keep track of all access and then audit them later.

Operations on dormant bank accounts

Audit operations carried out on an account that has remained unchanged for X years.

Operations on badly managed bank accounts

Audit operations carried out on company accounts whose approximate management is well known.

Search for malfunctions

Understanding the context of anomalies is a very important phase and always time consuming in application maintenance.

Disputes, audit track for a pedagogic use

You may ensure the origin of a particular situation without ambiguity when a dispute appears between editor, service provider or operator. You may also solve the problem when the litigious situation implies several applications sharing and updating common information. You may check procedures and parameter table updates. The result is very instructive because it explains the consequences of an error due to someone who forgot, took the wrong initiative or to a bug.

Factual complements

You can alert a certain group of users or run a specific action when a field X increases more than x% (discount rate), a record has not been modified for over x months, a record has been created according to certain conditions (stock entry, employee creation).

Traceability complementary to the application

You may keep track of all movements related to a file number all its life and you can ask for a quick, easy and complete log.

File downloads

You can monitor the use of Client Access and FTP transfer functions.

Background data surfacing

QJRN/400 can be installed in background mode on secondary machines, traces are filtered by the automatic queries and the results are stored in the files. They are then inserted into the monthly backup procedure to be sent to headquarters. Each file is analyzed by a series of queries highlighting anomalies and potential fraudulent behavior.


SYSTEM AUDIT

Control of the integrity of audit parameters

All monitoring scheme must be guaranteed that no modification will be made to the administration rules because they may have an influence when generating traces (e.g.: the modification of system values, audit attributes at user and object levels, deletion of a receiver without having analyzed it).

Explanations about the production

You may keep track of harmful operations (running several batch jobs on the same program, priority changes in OUTQ).

Adopted authority

You may filter the running of programs which allow too much authorizations, without taking into account programs already known.

Access control to production data

While auditing, profiles which are not part of the production group may access production data (e.g.: development).

Security monitoring

Interventions on profiles, system values, network attributes, authority on sensitive objects, attempts to open unauthorized sessions or access to unauthorized resources.

Control of transfers to production

Check that the creation of new objects in production respects a pre-defined procedure.

Monitoring of sensitive profiles at command level

Log of commands run by certain profiles according to different filters possible.

Delete and display spool files

These actions may be audited according to the spool file and/or the sensitivity of the owner user.


ARCHITECTURE

- A suite for the journaling administration.

All the journals can be declared and monitored by QJRN/400. The already existing ones are easily recovered. QJRN/400 also deals with the creation and running of journaling environments. QJRN/400 can run perfectly well with other high availability software.

Each environment has a repository that describes the fields in the fully journaled database. This repository is automatically generated and has numerous possibilities of customization. It focuses on all databases and it is preloaded for system journals.

A configurable query manager

Thanks to an original and unique design of the query system, the content of receivers is presented in a clear, pleasant and precise way. There are various selection possibilities. Finally, the different restitution modes (OS/400 messages, email, display, prints, files) combined with all types of execution (continuous, automatic or scheduled mode) contribute to the implementation of detailed and automated audit schemes.


MORE RESOURCES

Download the solution brief

Read: Cilasoft Announces Version 5.0 of System i Security Suite

Contact us for:

  • Full detailled PowerPoint presentation
  • Free trial

QJRN/400 is a Cilasoft product.