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 in to 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.

---

Note 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 following tables:

acstacacsauthentication

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

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
PriviligeLevel	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	varchar(1024)
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)
PriviligeLevel	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)
PriviligeLevel	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)
PriviligeLevel	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

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	varchar(1000)
ResponseTime	integer
Started	smallint
Stopped	smallint

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	varchar(1000)
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
PriviligeLevel	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)
PriviligeLevel	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)
PriviligeLevel	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)
PriviligeLevel	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

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	varchar2(1000)
ResponseTime	integer
Started	integer
Stopped	integer

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	varchar2(1000)
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