box.as400

Introduction

The tags beginning with box.as400 identify events generated by IBM i (formerly known as AS/400)

Valid tags and data tables

The full tag must have 4 levels. The first two are fixed as box.as400. The third level identifies the type of events sent, and the fourth level indicates the event subtype.

Technology	Brand	Type	Subtype
box	as400	audit	type2

These are the valid tags and corresponding data tables that will receive the parsers' data:

Tag	Data table
box.as400.audit.type2	box.as400.audit.type2

How is the data sent to Devo?

Logs generated by IBM i are forwarded to Devo using a dedicated collector. Contact us if you need to forward these events to your Devo domain so we can guide you through the process.

Log samples

The following are sample logs sent to each of the box.as400 data tables. Also, find how the information will be parsed in your data table under each sample log.

Extra columns

Fields marked as Extra in the table below are not shown by default in data tables and need to be explicitly requested in the query. You can find them marked as Extra when you perform a query so they can be easily identified. Learn more about this in Selecting unrevealed columns.

box.as400.audit.type2

2020-12-08 19:46:51.986 localhost=127.0.0.1 box.as400.audit.type2: 060130068382803TCA250520000501JYU2CSEC SCAJYID 660997RBT637 000000000000000000000QSECOFR iulyd 00 
2020-12-08 19:46:51.986 localhost=127.0.0.1 box.as400.audit.type2: 060130068382804TCA250520000501JYS2CSEC WMSTINTOP 660998RBT637 000000000000000000000QSECOFR iulyd 00
2020-12-08 19:46:51.986 localhost=127.0.0.1 box.as400.audit.type2: 066060068383085TOM250520000503JYU2IPMON WMUTINTOP 630943IPSBMJ02 000000000000000000000WMUTINTOP iulyd 00

And this is how the log would be parsed:

Field	Value	Type	Extra field
eventdate	`date('2020-12-08 19:46:51.986')`	`timestamp`
hostchain	`localhost=127.0.0.1`	`str`	✓
hostname	`localhost`	`str`
tag	`box.as400.audit.type2`	`str`	✓
Entry_Length	`06013`	`str`
Sequence_Number	`0068382803`	`str`
Journal_Code	`T`	`str`
Entry_Type	`CA`	`str`
Date_Stamp	`250520`	`str`
Time_Stamp	`000501`	`str`
Job_Name	`JYU2CSEC`	`str`
User_Name	`SCAJYID`	`str`
Job_Number	`660997`	`str`
Program_Name	`RBT637`	`str`
Object_Name	`null`	`str`
Library_Name	`null`	`str`
Member_Name	`null`	`str`
Count_Rel_Rec_Num	`0000000000`	`str`
Indicator_Flag	`0`	`str`
Commit_Cycle_Identifier	`0000000000`	`str`
User_Profile	`QSECOFR`	`str`
System_Name	`iulyd`	`str`
Incomplete_Data	`0`	`str`
Minimized_Entry_Specific_Data	`0`	`str`
Reserved_Field	`null`	`str`
rawMessage	`060130068382803TCA250520000501JYU2CSEC SCAJYID 660997RBT637 000000000000000000000QSECOFR iulyd 00`	`str`	✓