Logger Types Seeded Table
Standard logger types and their details are seeded in the AAI_DMT_WEBLOG_TYPES table. By default, the details for the Apache and Microsoft-IIS logs are pre-populated. You can add other logger methods to the table to make them visible in the UI.
The sample entries for the logger types are given in the following table:
Table 2-1 Logger Types Seed table
| V_LOG_TYPE | V_LOG_COLUMNS | V_LOG_COL_DATATYPE | V_LOG_REGEX |
|---|---|---|---|
| Apache Sample | IP,Identity,User,Time,URL,Status,Size,Referer,Agent,Bytes | string,string,string,string,string,string,string,string,string,string | ([^ ]*) ([^ ]*) ([^ ]*) (-|\[[^\]]*\]) ([^ \"]*|\"[^\"]*\") ([0-9]*) ([0-9]*) ([^ \"]*|\"[^\"]*\") ([^ \"]*|\"[^\"]*\") ([0-9]*) |
| Microsoft-IIS Sample | IP,User,Date,Time,Service,ServerName,ServerIP,TimeTaken,ClientBytesSent,ServerBytesSent,ServiceStatus,WindowsStatus,RequestType,TargetOperation,Parameters | string,string,string,string,string,string,string,string,string,string,string,string,string,string,string, | DELIMITED~, |
To add a new logger type, add a new entry in the AAI_DMT_WEBLOG_TYPES table as follows:
V_LOG_TYPE-Enter a name for the custom logger type. The values in this column are displayed as Logger Type drop-down list in the Preview pane of Source Model Generation window for WebLogs.V_LOG_COLUMNS-Enter appropriate column names separated by commas, which is displayed in the Data Model Preview pane as Column Names.V_LOG_COL_DATATYPE-Enter the data type for the corresponding column names entered in V_LOG_COLUMNS, separated by commas. The supported Data Types are String and Int. The values in this column are displayed as the Data Type for the corresponding Column Names. If you do not specify Data Type for a column, Integer is selected by default. You can change it to String if required from the Source Model Generation window.V_LOG_REGEX-Enter the Regular expression for each Column Name separated by a space. This is displayed as Input Regex in the Source Model Generation window.