Software Developer's Guide for Cisco Secure Access Control System 5.4
Monitoring and Report Viewer Database Schema
Downloads: This chapterpdf (PDF - 473.0KB) The complete bookPDF (PDF - 3.4MB) | Feedback

Monitoring and Report Viewer Database Schema

Table Of Contents

Monitoring and Report Viewer Database Schema

Configuring a Remote Database in ACS

Understanding the Monitoring and Report Viewer Database Schema

Raw Tables

Aggregated Tables

Microsoft SQL Server Schema

Oracle Schema


Monitoring and Report Viewer Database Schema


ACS allows you to export data from the Viewer database to a Microsoft Active Directory (AD) or an Oracle System ID (SID) in a remote server. This feature allows you to create custom reporting applications that meet your specific needs.

For example, you can export the data from the Viewer database to your remote database on another server that contains your customized reporting application. To export data, you must first configure a remote database in ACS.

This appendix describes how to configure a remote database and the tables in the Monitoring and Report Viewer database. This appendix provides the Monitoring and Report Viewer database schema for both Microsoft SQL server and Oracle SID.

The following topics are included:

Configuring a Remote Database in ACS

Understanding the Monitoring and Report Viewer Database Schema

Microsoft SQL Server Schema

Oracle Schema

Configuring a Remote Database in ACS

You can configure a remote database to which ACS exports the Monitoring and Report Viewer data at specified intervals. You can schedule the export job to be run once every 1, 2, 4, 6, 8, 12, or 24 hours.

You can create custom reporting applications that interact with this remote database. ACS supports the following databases:

Oracle SQL Developer

Microsoft SQL Server 2005

To configure a remote database:


Step 1 Log into the ACS web interface.

Step 2 From the Monitoring and Report Viewer, choose Monitoring Configuration > System Configuration > Remote Database Settings.

The Remote Database Settings Page appears as described in Table A-1.

Table A-1 Remote Database Settings Page

Option
Description

Publish to Remote Database

Check the check box for ACS to export data to the remote database periodically. By default, ACS exports data to the remote database every 4 hours.

Server

Enter the DNS name or the IP address of the remote database.

Port

Enter the port number of the remote database.

Username

Enter the username for remote database access.

Password

Enter the password for remote database access.

Publish data every n hours

Choose a time interval from the drop-down list box for ACS to export data at the specified interval. Valid options are 1, 2, 4, 6, 8, 12, and 24 hours.

Database Type

The type of remote database that you want to configure:

Click the Microsoft Database radio button to configure a Microsoft database and enter the name of the remote database.

Click the Oracle SID radio button to configure an Oracle database and enter the system identifier for the Oracle database.


Step 3 Click Submit to configure the remote database.

To view the status of your export job in the Scheduler, from the Monitoring and Report Viewer, select Monitoring Configuration > System Operations > Scheduler.


Understanding the Monitoring and Report Viewer Database Schema

The Monitoring and Report Viewer collects data for:

Accounting

AAA Audit


Note The tables that contain AAA diagnostics, system diagnostics, and administrative audit data are not exported.


The Viewer database contains raw and aggregated tables. This section contains the following topics:

Raw Tables

Aggregated Tables

Microsoft SQL Server Schema

Oracle Schema

Raw Tables

The raw tables contain individual records. The Monitoring and Report Viewer aggregates the records in the raw tables and stores the aggregated data in aggregated tables. The passed and failed bit fields in the raw tables are not encoded and are represented as 1s and 0s.

Aggregated Tables

The aggregated tables contain a count of passed and failed authentications for various data combinations. For example, for a user User1, from identity group A, with NAD B, and access policy C, the Monitoring and Report Viewer computes the passed and failed counts on a daily basis and stores it in the monthly tables.

Monthly Tables

The daily count of passed and failed authentications for various data combinations are stored in the monthly tables.

Yearly Tables

At the end of every month, the Monitoring and Report Viewer computes the passed and failed counts for that month and stores them in the yearly tables.

You can choose to work with individual records from the raw tables or you can get the counts directly from these aggregated tables. In the aggregated tables, passed and failed counts are available for various data combinations.

The Passed, Failed, TotalResponseTime, and MaxResponseTime fields are not part of any data combination. The total response time is computed in milliseconds for both passed and failed authentications. The day field in the month tables is set to date only and does not include the time.

Table A-2 provides a list of tables, a brief description, and a list of aggregated tables.

Table A-2 Monitoring and Report Viewer Database Schema 

Purpose
Table
Description
Aggregated Tables
Accounting

TACACS Accounting (acstacacsaccounting)

TACACS Session—Start and stop, watchdog process, and rejected session information.

acstacacsaccountingmonth

acstacacsaccountingyear

RADIUS Accounting (acsradiusaccounting)

RADIUS Session—Start, stop, and update information.

acsradiusaccountingmonth

acsradiusaccountingyear

AAA Audit

TACACS Authentication (acstacacsauthentication)

TACACS—Passed authentications and failed attempts.

acstacacsauthenticationmonth

acstacacsauthenticationyear

TACACS Authorization (acstacacsauthorization)

TACACS device administration—Command and session authorization passed and failed attempts.

acstacacsauthorizationmonth

acstacacsauthorizationyear

RADIUS Authentication (acsradiusauthentication)

RADIUS—Passed authentications and failed attempts.

acsradiusauthenticationmonth

acsradiusauthenticationyear


Microsoft SQL Server Schema

The Monitoring and Report Viewer database in Microsoft SQL Server contains the acstacacsauthentication tables:

The acstacacsauthentication table contains the fields described in Table A-3.

acstacacsauthentication

Table A-3 acstacacsauthentication Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

ACSSessionID

varchar(500)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

IdentityStore

varchar(500)

AuthenticationMethod

varchar(500)

AuthenType

varchar(500)

NetworkDeviceName

varchar(500)

DeviceIPAddress

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

Response

text

PrivilegeLevel

varchar(10)

FailureReason

varchar(500)

ADDomain

varchar(500)

AuthenMethod

varchar(500)

GroupMappingPolicyMatchedR

varchar(500)

IdentityPolicyMatchedRule

varchar(500)

QueryIdentityStores

varchar(500)

RemoteAddress

varchar(500)

SelectedAuthenticationIdenti

varchar(500)

SelectedQueryIdentityStores

varchar(500)

Service

varchar(500)

AVPair

text

ExecutionSteps

text

OtherAttributes

text

SelectedShellProfile

varchar(500)

AuthorizationExceptionPolicyMa

varchar(500)

ResponseTime

integer

Passed

bit

Failed

bit


acstacacsauthenticationmonth

Table A-4 acstacacsauthenticationmonth Table 

Column
Data Type

ID

integer

Day

smalldatetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

UserName

varchar(500)

IdentityStore

varchar(500)

NetworkDeviceName

varchar(500)

DeviceIPAddress

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

FailureReason

varchar(500)

ADDomain

varchar(500)

UseCase

varchar(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acstacacsauthenticationyear

Table A-5 acstacacsauthenticationyear Table 

Column
Data Type

ID

integer

Month

varchar(10)

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

UserName

varchar(500)

IdentityStore

varchar(500)

NetworkDeviceName

varchar(500)

DeviceIPAddress

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

FailureReason

varchar(500)

ADDomain

varchar(500)

UseCase

varchar(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acsradiusauthentication

Table A-6 acsradiusauthentication Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

ACSSessionID

varchar(500)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

IdentityStore

varchar(500)

AuthenticationMethod

varchar(500)

NetworkDeviceName

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

Response

text

CallingStationID

varchar(500)

NASPort

varchar(500)

ServiceType

varchar(500)

AuditSessionID

varchar(500)

CTSSecurityGroup

varchar(500)

FailureReason

varchar(500)

UseCase

varchar(500)

ExecutionSteps

varchar(4000)

FramedIPAddress

varchar(500)

NASIdentifier

varchar(500)

NASIPAddress

varchar(500)

NASPortId

varchar(500)

CiscoAVPair

text

ADDomain

varchar(500)

RadiusResponse

text

ACSUserName

varchar(500)

RadiusUserName

varchar(500)

NACRole

varchar(500)

NACPolicyCompliance

varchar(500)

NACUsername

varchar(500)

NACPostureToken

varchar(500)

NACRadiusIsUserAuthenticated

varchar(10)

SelectedPostureServer

varchar(500)

SelectedIdentityStore

varchar(500)

AuthenticationIdentityStore

varchar(500)

AuthorizationExceptionPolicyMa

varchar(500)

ExternalPolicyServerMatchedRul

varchar(500)

GroupMappingPolicyMatchedRule

varchar(500)

IdentityPolicyMatchedRule

varchar(500)

NASPortType

varchar(500)

QueryIdentityStores

varchar(500)

SelectedAuthorizationProfiles

varchar(500)

SelectedExceptionAuthorization

varchar(500)

SelectedQueryIdentityStores

varchar(500)

EapAuthentication

varchar(500)

EapTunnel

varchar(500)

TunnelDetails

text

CiscoH323Attributes

text

CiscoSSGAttributes

text

OtherAttributes

text

ResponseTime

integer

NADFailure

bit

Passed

bit

Failed

bit


acsradiusauthenticationmonth

Table A-7 acsradiusauthenticationmonth Table 

Column
Data Type

ID

integer

Day

smalldatetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

IdentityStore

varchar(500)

NetworkDeviceName

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

CallingStationID

varchar(500)

FailureReason

varchar(500)

NASIdentifier

varchar(500)

NASIPAddress

varchar(500)

ADDomain

varchar(500)

UseCase

varchar(500)

SelectedAuthorizationProfiles

varchar(500)

CTSSecurityGroup

varchar(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer

constraint ASA1234 primary key (ID)

integer


acsradiusauthenticationyear

Table A-8 acsradiusauthenticationyear Table 

Column
Data Type

ID

integer

Month

varchar(10)

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

IdentityStore

varchar(500)

NetworkDeviceName

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

CallingStationID

varchar(500)

FailureReason

varchar(500)

NASIdentifier

varchar(500)

NASIPAddress

varchar(500)

ADDomain

varchar(500)

UseCase

varchar(500)

SelectedAuthorizationProfilesCTSSecurityGroup

varchar(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acstacacsauthorization

Table A-9 acstacacsauthorization Table 

Column
Data Type

ID

integer

ACSTIMESTAMP

datetime

ACSViewTIMESTAMP

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

ACSSessionID

varchar(500)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

Response

text

NetworkDeviceName

varchar(500)

DeviceIPAddress

varchar(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar(500)

MatchedCommandSet

varchar(500)

SelectedShellProfile

varchar(500)

SelectedCommandSet

varchar(500)

AuthorizationFailureReason

varchar(500)

FailedShellAttribute

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

AuthenMethod

varchar(500)

AuthorizationExceptionPolicyMa

varchar(500)

AuthorReplyStatus

varchar(500)

FailureReason

varchar(500)

GroupMappingPolicyMatchedRule

varchar(500)

IdentityPolicyMatchedRule

varchar(500)

QueryIdentityStores

varchar(500)

RemoteAddress

varchar(500)

SelectedAuthorizationProfiles

varchar(500)

SelectedExceptionAuthorization

varchar(500)

AVPair

text

ExecutionSteps

text

OtherAttributes

text

AuthenType

varchar(500)

IdentityStore

varchar(500)

ADDomain

varchar(500)

SelectedIdentityStore

varchar(500)

SelectedQueryIdentityStore

varchar(500)

ResponseTime

integer

Passed

bit

Failed

bit


acstacacsauthorizationmonth

Table A-10 acstacacsauthorizationmonth Table 

Column
Data Type

ID

integer

Day

smalldatetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

NetworkDeviceName

varchar(500)

DeviceIPAddress

varchar(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar(500)

MatchedCommandSet

varchar(500)

SelectedShellProfile

varchar(500)

SelectedCommandSet

varchar(500)

AuthorizationFailureReason

varchar(500)

FailedShellAttribute

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

TotalResponseTime

integer

Passed

integer

Failed

integer


acstacacsauthorizationyear

Table A-11 acstacacsauthorizationyear Table 

Column
Data Type

ID

integer

Month

varchar(10)

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

ServiceSelectionPolicy

varchar(500)

AuthorizationPolicy

text

UserName

varchar(500)

NetworkDeviceName

varchar(500)

DeviceIPAddress

varchar(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar(500)

MatchedCommandSet

varchar(500)

SelectedShellProfile

varchar(500)

SelectedCommandSet

varchar(500)

AuthorizationFailureReason

varchar(500)

FailedShellAttribute

varchar(500)

IdentityGroup

text

NetworkDeviceGroups

text

TotalResponseTime

integer

Passed

integer

Failed

integer


acstacacsaccounting

Table A-12 acstacacsaccounting Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

ACSSessionID

varchar(500)

AccessService

varchar(500)

UserName

varchar(500)

RemoteAddress

varchar(500)

AcctRequestFlags

varchar(10)

AuthenMethod

varchar(20)

ServiceType

varchar(20)

Service

varchar(500)

NetworkDeviceName

varchar(500)

Port

varchar(500)

NetworkDeviceGroups

text

DeviceIPAddress

varchar(500)

SourceIPAddress

varchar(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar(500)

ServerMsg

varchar(500)

ServiceArgument

varchar(500)

AVPair

text

AcctInputPackets

numeric(11)

AcctOutputPackets

numeric(11)

AcctTerminateCause

varchar(500)

AcctSessionTime

numeric(11)

AcctSessionId

varchar(500)

ExecutionSteps

text

Response

text

OtherAttributes

text

ResponseTime

integer

Started

smallint

Stopped

smallint

SessionKey

varchar(500)


acstacacsaccountingmonth

Table A-13 acstacacsaccountingmonth Table 

Column
Data Type

ID

integer

Day

smalldatetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

UserName

varchar(500)

RemoteAddress

varchar(500)

Service

varchar(500)

NetworkDeviceName

varchar(500)

NetworkDeviceGroups

text

DeviceIPAddress

varchar(500)

SourceIPAddress

varchar(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar(500)

Count

integer

TotalResponseTime

bigint

MaxResponseTime

numeric(11)

Active

integer

Throughput

bigint

TotalSessionTime

bigint

MaxSessionTime

numeric(11)

Started

integer

Stopped

integer


acstacacsaccountingyear

Table A-14 acstacacsaccountingyear Table 

Column
Data Type

ID

integer

Month

varchar(10)

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

UserName

varchar(500)

RemoteAddress

varchar(500)

Service

varchar(500)

NetworkDeviceName

varchar(500)

NetworkDeviceGroups

text

DeviceIPAddress

varchar(500)

SourceIPAddress

varchar(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar(500)

Count

integer

TotalResponseTime

bigint

MaxResponseTime

numeric(11)

Active

integer

Throughput

bigint

TotalSessionTime

bigint

MaxSessionTime

numeric(11)

Started

integer

Stopped

integer


acsradiusaccounting

Table A-15 acsradiusaccounting Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

ACSSessionID

varchar(500)

UserName

varchar(500)

CallingStationID

varchar(500)

AcctSessionId

varchar(500)

AcctStatusType

varchar(500)

AcctSessionTime

varchar(500)

ServiceType

varchar(20)

FramedProtocol

varchar(500)

AcctInputOctets

varchar(500)

AcctOutputOctets

varchar(500)

AcctInputPackets

varchar(500)

AcctOutputPackets

varchar(500)

FramedIPAddress

varchar(500)

NASPort

varchar(500)

NASIPAddress

varchar(500)

CiscoAVPair

text

Class

varchar(500)

AcctTerminateCause

varchar(500)

AccessService

varchar(500)

AuditSessionID

varchar(500)

AcctMultiSessionID

varchar(500)

AcctAuthentic

varchar(10)

TerminationAction

varchar(500)

SessionTimeout

varchar(500)

IdleTimeout

varchar(500)

AcctInterimInterval

varchar(500)

AcctDelayTime

varchar(500)

EventTimestamp

varchar(500)

NASIdentifier

varchar(500)

NASPortId

varchar(500)

AcctTunnelConnection

varchar(500)

AcctTunnelPacketLost

varchar(500)

NetworkDeviceName

varchar(500)

NetworkDeviceGroups

varchar(500)

ServiceSelectionPolicy

varchar(500)

IdentityStore

varchar(500)

ADDomain

varchar(500)

IdentityGroup

varchar(500)

AuthorizationPolicy

varchar(500)

FailureReason

varchar(500)

SecurityGroup

varchar(500)

TunnelDetails

text

CiscoH323SetupTime

datetime

CiscoH323ConnectTime

datetime

CiscoH323DisconnectTime

datetime

CiscoH323Attributes

text

CiscoSSGAttributes

text

ExecutionSteps

text

OtherAttributes

text

ResponseTime

integer

Started

smallint

Stopped

smallint

SessionKey

varchar(500)


acsradiusaccountingmonth

Table A-16 acsradiusaccountingmonth Table 

Column
Data Type

ID

integer

Day

smalldatetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

UserName

varchar(500)

CallingStationID

varchar(500)

AcctTerminateCause

varchar(500)

TerminationAction

varchar(500)

NASIdentifier

varchar(500)

NASIPAddress

varchar(500)

NetworkDeviceName

varchar(500)

NetworkDeviceGroups

varchar(500)

IdentityStore

varchar(500)

ADDomain

varchar(500)

IdentityGroup

varchar(500)

AuthorizationPolicy

varchar(500)

AcctStatusType

varchar(500)

FramedIPAddress

varchar(500)

Count

integer

TotalResponseTime

bigint

MaxResponseTime

numeric(11)

Active

integer

Throughput

bigint

TotalSessionTime

bigint

MaxSessionTime

numeric(11)

Started

integer

Stopped

integer


acsradiusaccountingyear

Table A-17 acsradiusaccountingyear Table 

Column
Data Type

ID

integer

Month

varchar(10)

ACSServer

varchar(500)

MessageCode

varchar(10)

AccessService

varchar(500)

UserName

varchar(500)

CallingStationID

varchar(255)

AcctTerminateCause

varchar(500)

TerminationAction

varchar(500)

NASIdentifier

varchar(500)

NASIPAddress

varchar(500)

NetworkDeviceName

varchar(500)

NetworkDeviceGroups

varchar(500)

IdentityStore

varchar(500)

ADDomain

varchar(500)

IdentityGroup

varchar(500)

AuthorizationPolicy

varchar(500)

AcctStatusType

varchar(500)

FramedIPAddress

varchar(500)

Count

integer

TotalResponseTime

bigint

MaxResponseTime

numeric(11)

Active

integer

Throughput

bigint

TotalSessionTime

bigint

MaxSessionTime

numeric(11)

Started

integer

Stopped

integer


acsaaadiagnostics

Table A-18 acsaaadiagnostics Table

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

MessageSeverity

varchar(10)

ACSSessionID

varchar(500)

Category

varchar(500)

DiagnosticInfo

text


acsadministratorlogin

Table A-19 acsadministratorlogin Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AdminName

varchar(500)

AdminIPAddress

varchar(100)

AdminSession

varchar(100)

AdminInterface

varchar(10)


acsconfigurationchanges

Table A-20 acsconfigurationchanges Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

AdminName

varchar(500)

AdminIPAddress

varchar(100)

AdminSession

varchar(100)

AdminInterface

varchar(10)

ObjectType

varchar(500)

ObjectName

varchar(500)

RequestedOperation

varchar(100)

OperationMessageText

varchar(1000)

ConfigChangeData

text

HostID

varchar(100)

RequestResponseType

varchar(10)

FailureFlag

varchar(10)

Details

varchar(1000)

OperatorName

varchar(500)

UserAdminFlag

varchar(10)

AccountName

varchar(500)

DeviceIP

varchar(15)

IdentityStoreName

varchar(500)

ChangePasswordMethod

varchar(10)

AuditPasswordType

varchar(10)

ObjectID

varchar(100)

AppliedToACSInstance

varchar(500)

LocalMode

bit


acslogcollectionfailures

Table A-21 acslogcollectionfailures Table 

Column
Data Type

ID

integer

ACSViewTimestamp

datetime

ACSServer

varchar(500)

ACSLoggingCategory

varchar(100)

Error

text


acsmessagecatalog

Table A-22 acsmessagecatalog Table

Column
Data Type

ID

integer

MESSAGECODE

integer

MESSAGECLASS

varchar(100)

MESSAGETEXT

text


acsprocessstatus

Table A-23 acsprocessstatus Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

NodeId

smallint

NodeName

varchar(500)

Role

varchar(100)

DatabaseProc

bit

Management

bit

Runtime

bit

Adclient

bit

ViewDatabase

bit

ViewCollector

bit

ViewJobManager

bit

ViewAlertManager

bit

ViewLogProcessor

bit


acssystemstatus

Table A-24 acssystemstatus Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

CPUUtilization

decimal(5,2)

NetworkUtilizationRcvd

integer

NetworkUtilizationSent

integer

MemoryUtilization

decimal(5,2)

DiskIOUtilization

decimal(5,2)

DiskSpaceUtilizationRoot

decimal(5,2)

DiskSpaceUtilizationAltRoot

decimal(5,2)

DiskSpaceUtilizationBoot

decimal(5,2)

DiskSpaceUtilizationHome

decimal(5,2)

DiskSpaceUtilizationLocaldisk

decimal(5,2)

DiskSpaceUtilizationOpt

decimal(5,2)

DiskSpaceUtilizationRecovery

decimal(5,2)

DiskSpaceUtilizationStoredconf

decimal(5,2)

DiskSpaceUtilizationStoreddata

decimal(5,2)

DiskSpaceUtilizationTmp

decimal(5,2)

DiskSpaceUtilizationRuntime

decimal(5,2)

AverageRadiusRequestLatency

integer

AverageTacacsRequestLatency

integer

DeltaRadiusRequestCount

integer

DeltaTacacsRequestCount

integer


acssystemdiagnostics

Table A-25 acssystemdiagnostics Table 

Column
Data Type

ID

integer

ACSTimestamp

datetime

ACSViewTimestamp

datetime

ACSServer

varchar(500)

MessageCode

varchar(10)

MessageSeverity

varchar(10)

Category

varchar(100)

DiagnosticInfo

text


acsviewnetflowaggregation

Table A-26 acsviewnetflowaggregation Table

Column
Data Type

ID

integer

ACSViewTimestamp

datetime

SourceUsername

varchar(500)

SourceAddress

varchar(15)

SourcePort

varchar(50)

DestinationUsername

varchar(500)

DestinationAddress

varchar(15)

DestinationPort

varchar(50)

SGTName

varchar(100)

SGTValue

integer

DGTName

varchar(100)

DGTValue

integer

NASIPAddress

varchar(15)

Protocol

varchar(50)

ACLDrops

integer


checkpointday

Table A-27 checkpointday Table 

Column
Data Type

ID

integer

Type

smallint

Timestamp

datetime

AuditSessionID

varchar(100)

ACSServer

varchar(100)

ACSSessionID

varchar(100)

NASIP

varchar(41)

EndpointMAC

varchar(100)

EndpointIP

varchar(41)

UserName

varchar(500)

VLAN

varchar(100)

dACL

varchar(100)

AuthenticationType

varchar(500)

InterfaceName

varchar(100)

Reason

varchar(500)


nadaaastatus

Table A-28 nadaaastatus Table

Column
Data Type

ID

integer

Timestamp

datetime

Alive

bit

ACSServer

varchar(100)

NASIP

varchar(100)

DeviceGroups

text


Oracle Schema

The Monitoring and Report Viewer database in AD contains the following tables:

acstacacsauthentication

Table A-29 acstacacsauthentication Table  

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

ACSSessionID

varchar2(500)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

IdentityStore

varchar2(500)

AuthenticationMethod

varchar2(500)

AuthenType

varchar2(500)

NetworkDeviceName

varchar2(500)

DeviceIPAddress

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

Response

clob

PrivilegeLevel

varchar2(500)

FailureReason

varchar2(500)

ADDomain

varchar2(500)

AuthenMethod

varchar2(500)

GroupMappingPolicyMatchedR

varchar2(500)

IdentityPolicyMatchedRule

varchar2(500)

QueryIdentityStores

varchar2(500)

RemoteAddress

varchar2(500)

SelectedAuthenticationIdenti

varchar2(500)

SelectedQueryIdentityStores

varchar2(500)

Service

varchar2(500)

AVPair

clob

ExecutionSteps

clob

OtherAttributes

clob

SelectedShellProfile

varchar2(500)

AuthorizationExceptionPolicyMa

varchar2(500)

ResponseTime

integer

Passed

smallint

Failed

smallint


acstacacsauthenticationmonth

Table A-30 acstacacsauthenticationmonth Table 

Column
Data Type

ID

integer

Day

date

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

UserName

varchar2(500)

IdentityStore

varchar2(500)

NetworkDeviceName

varchar2(500)

DeviceIPAddress

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

FailureReason

varchar2(500)

ADDomain

varchar2(500)

UseCase

varchar2(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acstacacsauthenticationyear

Table A-31 acstacacsauthenticationyear Table 

Column
Data Type

ID

integer

Month

varchar2(10)

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

UserName

varchar2(500)

IdentityStore

varchar2(500)

NetworkDeviceName

varchar2(500)

DeviceIPAddress

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

FailureReason

varchar2(500)

ADDomain

varchar2(500)

UseCase

varchar2(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acsradiusauthentication

Table A-32 acsradiusauthentication Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

ACSSessionID

varchar2(500)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

IdentityStore

varchar2(500)

AuthenticationMethod

varchar2(500)

NetworkDeviceName

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

Response

clob

CallingStationID

varchar2(500)

NASPort

varchar2(500)

ServiceType

varchar2(500)

AuditSessionID

varchar2(500)

CTSSecurityGroup

varchar2(500)

FailureReason

varchar2(500)

UseCase

varchar2(500)

ExecutionSteps

clob

FramedIPAddress

varchar2(500)

NASIdentifier

varchar2(500)

NASIPAddress

varchar2(500)

NASPortId

varchar2(500)

CiscoAVPair

clob

ADDomain

varchar2(500)

RadiusResponse

clob

ACSUserName

varchar2(500)

RadiusUserName

varchar2(500)

NACRole

varchar2(500)

NACPolicyCompliance

varchar2(500)

NACUsername

varchar2(500)

NACPostureToken

varchar2(500)

NACRadiusIsUserAuthenticated

varchar2(500)

SelectedPostureServer

varchar2(500)

SelectedIdentityStore

varchar2(500)

AuthenticationIdentityStore

varchar2(500)

AuthorizationExceptionPolicyMa

varchar2(500)

ExternalPolicyServerMatchedRul

varchar2(500)

GroupMappingPolicyMatchedRule

varchar2(500)

IdentityPolicyMatchedRule

varchar2(500)

NASPortType

varchar2(500)

QueryIdentityStores

varchar2(500)

SelectedAuthorizationProfiles

varchar2(500)

SelectedExceptionAuthorization

varchar2(500)

SelectedQueryIdentityStores

varchar2(500)

EapAuthentication

varchar2(500)

EapTunnel

varchar2(500)

TunnelDetails

clob

CiscoH323Attributes

clob

CiscoSSGAttributes

clob

OtherAttributes

clob

ResponseTime

integer

NADFailure

smallint

Passed

integer

Failed

integer


acsradiusauthenticationmonth

Table A-33 acsradiusauthenticationmonth Table 

Column
Data Type

ID

integer

Day

date

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

IdentityStore

varchar2(500)

NetworkDeviceName

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

CallingStationID

varchar2(500)

FailureReason

varchar2(500)

NASIdentifier

varchar2(500)

NASIPAddress

varchar2(500)

ADDomain

varchar2(500)

UseCase

varchar2(500)

SelectedAuthorizationProfiles

varchar2(500)

CTSSecurityGroup

varchar2(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acsradiusauthenticationyear

Table A-34 acsradiusauthenticationyear Table 

Column
Data Type

ID

integer

Month

varchar2(10)

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

IdentityStore

varchar2(500)

NetworkDeviceName

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

CallingStationID

varchar2(500)

FailureReason

varchar2(500)

NASIdentifier

varchar2(500)

NASIPAddress

varchar2(500)

ADDomain

varchar2(500)

UseCase

varchar2(500)

SelectedAuthorizationProfiles

varchar2(500)

CTSSecurityGroup

varchar2(500)

Passed

integer

Failed

integer

TotalResponseTime

integer

MaxResponseTime

integer


acstacacsauthorization

Table A-35 acstacacsauthorization Table 

Column
Data Type

ID

integer

ACSTIMESTAMP

timestamp

ACSViewTIMESTAMP

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

ACSSessionID

varchar2(500)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

Response

clob

NetworkDeviceName

varchar2(500)

DeviceIPAddress

varchar2(500)

PrivilegeLevel

varchar(10)

CmdSet

varchar2(500)

MatchedCommandSet

varchar2(500)

SelectedShellProfile

varchar2(500)

SelectedCommandSet

varchar2(500)

AuthorizationFailureReason

varchar2(500)

FailedShellAttribute

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

AuthenMethod

varchar2(500)

AuthorizationExceptionPolicyMa

varchar2(500)

AuthorReplyStatus

varchar2(500)

FailureReason

varchar2(500)

GroupMappingPolicyMatchedRule

varchar2(500)

IdentityPolicyMatchedRule

varchar2(500)

QueryIdentityStores

varchar2(500)

RemoteAddress

varchar2(500)

SelectedAuthorizationProfiles

varchar2(500)

SelectedExceptionAuthorization

varchar2(500)

AVPair

clob

ExecutionSteps

clob

OtherAttributes

clob

AuthenType

varchar2(500)

IdentityStore

varchar2(500)

ADDomain

varchar2(500)

SelectedIdentityStore

varchar2(500)

SelectedQueryIdentityStore

varchar2(500)

ResponseTime

integer

Passed

small int

Failed

smallint


acstacacsauthorizationmonth

Table A-36 acstacacsauthorizationmonth Table 

Column
Data Type

ID

integer

Day

date

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

NetworkDeviceName

varchar2(500)

DeviceIPAddress

varchar2(500)

PrivilegeLevel

varchar2(10)

CmdSet

varchar2(500)

MatchedCommandSet

varchar2(500)

SelectedShellProfile

varchar2(500)

SelectedCommandSet

varchar2(500)

AuthorizationFailureReason

varchar2(500)

FailedShellAttribute

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

TotalResponseTime

integer

Passed

integer

Failed

integer


acstacacsauthorizationyear

Table A-37 acstacacsauthorizationyear Table 

Column
Data Type

ID

integer

Month

varchar2(10)

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

AuthorizationPolicy

clob

UserName

varchar2(500)

NetworkDeviceName

varchar2(500)

DeviceIPAddress

varchar2(500)

PrivilegeLevel

varchar2(10)

CmdSet

varchar2(500)

MatchedCommandSet

varchar2(500)

SelectedShellProfile

varchar2(500)

SelectedCommandSet

varchar2(500)

AuthorizationFailureReason

varchar2(500)

FailedShellAttribute

varchar2(500)

IdentityGroup

clob

NetworkDeviceGroups

clob

TotalResponseTime

integer

Passed

integer

Failed

integer


acstacacsaccounting

Table A-38 acstacacsaccounting Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

ACSSessionID

varchar2(500)

AccessService

varchar2(500)

UserName

varchar2(500)

RemoteAddress

varchar2(500)

AcctRequestFlags

varchar2(10)

AuthenMethod

varchar2(20)

ServiceType

varchar2(20)

Service

varchar2(500)

NetworkDeviceName

varchar2(500)

Port

varchar2(500)

NetworkDeviceGroups

clob

DeviceIPAddress

varchar2(500)

SourceIPAddress

varchar2(500)

PrivilegeLevel

varchar2(10)

CmdSet

varchar2(500)

ServerMsg

varchar2(500)

ServiceArgument

varchar2(500)

AVPair

clob

AcctInputPackets

number(6)

AcctOutputPackets

number(6)

AcctTerminateCause

varchar2(500)

AcctSessionTime

number(6)

AcctSessionId

varchar2(500)

ExecutionSteps

clob

Response

clob

OtherAttributes

clob

ResponseTime

integer

Started

smallint

Stopped

smallint

SessionKey

varchar2(500)


acstacacsaccountingmonth

Table A-39 acstacacsaccountingmonth Table 

Column
Data Type

ID

integer

Day

date

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

UserName

varchar2(500)

RemoteAddress

varchar2(500)

Service

varchar2(500)

NetworkDeviceName

varchar2(500)

NetworkDeviceGroups

clob

DeviceIPAddress

varchar2(500)

SourceIPAddress

varchar2(500)

PrivilegeLevel

varchar2(10)

CmdSet

varchar2(500)

Count

integer

TotalResponseTime

number(20)

MaxResponseTime

number(6)

Active

integer

Throughput

number(20)

TotalSessionTime

number(20)

MaxSessionTime

number(6)

Started

integer

Stopped

integer


acstacacsaccountingyear

Table A-40 acstacacsaccountingyear Table 

Column
Data Type

ID

integer

Month

varchar2(10)

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

UserName

varchar2(500)

RemoteAddress

varchar2(500)

Service

varchar2(500)

NetworkDeviceName

varchar2(500)

NetworkDeviceGroups

clob

DeviceIPAddress

varchar2(500)

SourceIPAddress

varchar2(500)

PrivilegeLevel

varchar2(10)

CmdSet

varchar2(500)

Count

integer

TotalResponseTime

number(20)

MaxResponseTime

number(6)

Active

integer

Throughput

number(20)

TotalSessionTime

number(20)

MaxSessionTime

number(6)

Started

integer

Stopped

integer


acsradiusaccounting

Table A-41 acsradiusaccounting Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

ACSSessionID

varchar2(500)

UserName

varchar2(500)

CallingStationID

varchar2(500)

AcctSessionId

varchar2(500)

AcctStatusType

varchar2(500)

AcctSessionTime

varchar2(500)

ServiceType

varchar2(20)

FramedProtocol

varchar2(500)

AcctInputOctets

varchar2(500)

AcctOutputOctets

varchar2(500)

AcctInputPackets

varchar2(500)

AcctOutputPackets

varchar2(500)

FramedIPAddress

varchar2(500)

NASPort

varchar2(500)

NASIPAddress

varchar2(500)

CiscoAVPair

clob

Class

varchar2(500)

AcctTerminateCause

varchar2(500)

AccessService

varchar2(500)

AuditSessionID

varchar2(500)

AcctMultiSessionID

varchar2(500)

AcctAuthentic

varchar2(10)

TerminationAction

varchar2(500)

SessionTimeout

varchar2(500)

IdleTimeout

varchar2(500)

AcctInterimInterval

varchar2(500)

AcctDelayTime

varchar2(500)

EventTimestamp

varchar2(500)

NASIdentifier

varchar2(500)

NASPortId

varchar2(500)

AcctTunnelConnection

varchar2(500)

AcctTunnelPacketLost

varchar2(500)

NetworkDeviceName

varchar2(500)

NetworkDeviceGroups

varchar2(500)

ServiceSelectionPolicy

varchar2(500)

IdentityStore

varchar2(500)

ADDomain

varchar2(500)

IdentityGroup

varchar2(500)

AuthorizationPolicy

varchar2(500)

FailureReason

varchar2(500)

SecurityGroup

varchar2(500)

TunnelDetails

clob

CiscoH323SetupTime

timestamp

CiscoH323ConnectTime

timestamp

CiscoH323DisconnectTime

timestamp

CiscoH323Attributes

clob

CiscoSSGAttributes

clob

ExecutionSteps

clob

OtherAttributes

clob

ResponseTime

integer

Started

integer

Stopped

integer

SessionKey

varchar2(500)


acsradiusaccountingmonth

Table A-42 acsradiusaccountingmonth Table 

Column
Data Type

ID

integer

Day

date

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

UserName

varchar2(500)

CallingStationID

varchar2(500)

AcctTerminateCause

varchar2(500)

TerminationAction

varchar2(500)

NASIdentifier

varchar2(500)

NASIPAddress

varchar2(500)

NetworkDeviceName

varchar2(500)

NetworkDeviceGroups

varchar2(500)

IdentityStore

varchar2(500)

ADDomain

varchar2(500)

IdentityGroup

varchar2(500)

AuthorizationPolicy

varchar2(500)

AcctStatusType

varchar2(500)

FramedIPAddress

varchar2(500)

Count

integer

TotalResponseTime

number(20)

MaxResponseTime

number(6)

Active

integer

Throughput

number(20)

TotalSessionTime

number(20)

MaxSessionTime

number(6)

Started

integer

Stopped

integer


acsradiusaccountingyear

Table A-43 acsradiusaccountingyear Table 

Column
Data Type

ID

integer

Month

varchar2(10)

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AccessService

varchar2(500)

UserName

varchar2(500)

CallingStationID

varchar2(500)

AcctTerminateCause

varchar2(500)

TerminationAction

varchar2(500)

NASIdentifier

varchar2(500)

NASIPAddress

varchar2(500)

NetworkDeviceName

varchar2(500)

NetworkDeviceGroups

varchar2(500)

IdentityStore

varchar2(500)

ADDomain

varchar2(500)

IdentityGroup

varchar2(500)

AuthorizationPolicy

varchar2(500)

AcctStatusType

varchar2(500)

FramedIPAddress

varchar2(500)

Count

integer

TotalResponseTime

number(20)

MaxResponseTime

number(6)

Active

integer

Throughput

number(20)

TotalSessionTime

number(20)

MaxSessionTime

number(6)

Started

integer

Stopped

integer


acsaaadiagnostics

Table A-44 acsaaadiagnostics Table

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

MessageSeverity

varchar2(10)

ACSSessionID

varchar2(500)

Category

varchar2(500)

DiagnosticInfo

clob


acsadministratorlogin

Table A-45 acsadministratorlogin Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AdminName

varchar2(500)

AdminIPAddress

varchar2(100)

AdminSession

varchar2(100)

AdminInterface

varchar2(10)


acsconfigurationchanges

Table A-46 acsconfigurationchanges Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

AdminName

varchar2(500)

AdminIPAddress

varchar2(100)

AdminSession

varchar2(100)

AdminInterface

varchar2(10)

ObjectType

varchar2(500)

ObjectName

varchar2(500)

RequestedOperation

varchar2(100)

OperationMessageText

varchar2(1000)

ConfigChangeData

clob

HostID

varchar2(100)

RequestResponseType

varchar2(10)

FailureFlag

varchar2(10)

Details

varchar2(1000)

OperatorName

varchar2(500)

UserAdminFlag

varchar2(10)

AccountName

varchar2(500)

DeviceIP

varchar2(15)

IdentityStoreName

varchar2(500)

ChangePasswordMethod

varchar2(10)

AuditPasswordType

varchar2(10)

ObjectID

varchar2(100)

AppliedToACSInstance

varchar2(500)

LocalMode

smallint


acslogcollectionfailures

Table A-47 acslogcollectionfailures Table

Column
Data Type

ID

integer

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

ACSLoggingCategory

varchar2(100)

Error

clob


acsmessagecatalog

Table A-48 acsmessagecatalog Table 

Column
Data Type

ID

smallint

MESSAGECODE

integer

MESSAGECLASS

varchar2(100)

MESSAGETEXT

clob


acsprocessstatus

Table A-49 acsprocessstatus Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

NodeId

smallint

NodeName

varchar2(500)

Role

varchar2(100)

DatabaseProc

smallint

Management

smallint

Runtime

smallint

Adclient

smallint

ViewDatabase

smallint

ViewCollector

smallint

ViewJobManager

smallint

ViewAlertManager

smallint

ViewLogProcessor

smallintRuntimeRuntime


acssystemstatus

Table A-50 acssystemstatus Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

CPUUtilization

decimal(5,2)

NetworkUtilizationRcvd

integer

NetworkUtilizationSent

integer

MemoryUtilization

decimal(5,2)

DiskIOUtilization

decimal(5,2)

DiskSpaceUtilizationRoot

decimal(5,2)

DiskSpaceUtilizationAltRoot

decimal(5,2)

DiskSpaceUtilizationBoot

decimal(5,2)

DiskSpaceUtilizationHome

decimal(5,2)

DiskSpaceUtilizationLocaldisk

decimal(5,2)

DiskSpaceUtilizationOpt

decimal(5,2)

DiskSpaceUtilizationRecovery

decimal(5,2)

DiskSpaceUtilizationStoredconf

decimal(5,2)

DiskSpaceUtilizationStoreddata

decimal(5,2)

DiskSpaceUtilizationTmp

decimal(5,2)

DiskSpaceUtilizationRuntime

decimal(5,2)

AverageRadiusRequestLatency

integer

AverageTacacsRequestLatency

integer

DeltaRadiusRequestCount

integer

DeltaTacacsRequestCount

integer


acssystemdiagnostics

Table A-51 acssystemdiagnostics Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

ACSViewTimestamp

timestamp

ACSServer

varchar2(500)

MessageCode

varchar2(10)

MessageSeverity

varchar2(10)

Category

varchar2(100)

DiagnosticInfo

clob


acsviewnetflowaggregation

Table A-52 acsviewnetflowaggregation Table 

Column
Data Type

ID

integer

ACSTimestamp

timestamp

SourceUsername

varchar2(500)

SourceAddress

varchar2(15)

SourcePort

varchar2(50)

DestinationUsername

varchar2(500)

DestinationAddress

varchar2(15)

DestinationPort

varchar2(50)

SGTName

varchar2(100)

SGTValue

integer

DGTName

varchar2(100)

DGTValue

integer

NASIPAddress

varchar2(15)

Protocol

varchar2(50)

ACLDrops

integer


checkpointday

Table A-53 checkpointday Table 

Column
Data Type

ID

integer

Type

number(5)

Timestamp

timestamp

AuditSessionID

varchar2(100)

ACSServer

varchar2(100)

ACSSessionID

varchar2(100)

NASIP

varchar2(41)

EndpointMAC

varchar2(100)

EndpointIP

varchar2(41)

UserName

varchar2(500)

VLAN

varchar2(100)

dACL

varchar2(100)

AuthenticationType

varchar2(500)

InterfaceName

varchar2(100)

Reason

varchar2(500)


nadaaastatus

Table A-54 nadaaastatus Table

Column
Data Type

ID

integer

Timestamp

timestamp

Alive

smallint

ACSServer

varchar2(100)

NASIP

varchar2(100)

DeviceGroups

clob