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 in minutes or hours. 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 10g
■Microsoft SQL Server 2005
To configure a remote database:
1. Log into the ACS web interface.
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 1.
Table 1 Remote Database Settings Page
|
|
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 in minutes or 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. |
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 2 provides a list of tables, a brief description, and a list of aggregated tables.
Table 2 Monitoring and Report Viewer Database Schema
|
|
|
|
|
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 |
|
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 3.
acstacacsauthentication
Table 3 acstacacsauthentication Table
|
|
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 |
text |
SelectedShellProfile |
varchar(500) |
AuthorizationExceptionPolicyMa |
varchar(500) |
ResponseTime |
integer |
Passed |
bit |
Failed |
bit |
acstacacsauthenticationmonth
Table 4 acstacacsauthenticationmonth Table
|
|
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 5 acstacacsauthenticationyear Table
|
|
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 6 acsradiusauthentication Table
|
|
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 |
text |
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 |
text |
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 7 acsradiusauthenticationmonth Table
|
|
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) |
NASPortId |
varchar(500) |
ADDomain |
varchar(500) |
UseCase |
varchar(500) |
SelectedAuthorizationProfiles |
text |
CTSSecurityGroup |
varchar(500) |
Passed |
integer |
Failed |
integer |
TotalResponseTime |
integer |
MaxResponseTime |
integer |
acsradiusauthenticationyear
Table 8 acsradiusauthenticationyear Table
|
|
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) |
NASPortId |
varchar(500) |
ADDomain |
varchar(500) |
UseCase |
varchar(500) |
SelectedAuthorizationProfiles |
text |
CTSSecurityGroup |
varchar(500) |
Passed |
integer |
Failed |
integer |
TotalResponseTime |
integer |
MaxResponseTime |
integer |
acstacacsauthorization
Table 9 acstacacsauthorization Table
|
|
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 |
text |
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 |
text |
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 10 acstacacsauthorizationmonth Table
|
|
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 |
text |
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 11 acstacacsauthorizationyear Table
|
|
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 |
text |
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 12 acstacacsaccounting Table
|
|
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(500) |
AuthenMethod |
varchar(500) |
ServiceType |
varchar(500) |
Service |
varchar(500) |
NetworkDeviceName |
varchar(500) |
Port |
varchar(500) |
NetworkDeviceGroups |
text |
DeviceIPAddress |
varchar(500) |
SourceIPAddress |
varchar(500) |
PrivilegeLevel |
varchar(10) |
CmdSet |
text |
ServerMsg |
varchar(500) |
ServiceArgument |
varchar(500) |
AVPair |
text |
AcctInputPackets |
numeric(15) |
AcctOutputPackets |
numeric(15) |
AcctTerminateCause |
varchar(500) |
AcctSessionTime |
numeric(15) |
AcctSessionId |
varchar(500) |
ExecutionSteps |
text |
Response |
text |
OtherAttributes |
text |
ResponseTime |
integer |
Started |
smallint |
Stopped |
smallint |
SessionKey |
varchar(500) |
acstacacsaccountingmonth
Table 13 acstacacsaccountingmonth Table
|
|
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 |
text |
Count |
integer |
TotalResponseTime |
bigint |
MaxResponseTime |
numeric(15) |
Active |
integer |
Throughput |
bigint |
TotalSessionTime |
bigint |
MaxSessionTime |
numeric(15) |
Started |
integer |
Stopped |
integer |
acstacacsaccountingyear
Table 14 acstacacsaccountingyear Table
|
|
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 |
text |
Count |
integer |
TotalResponseTime |
bigint |
MaxResponseTime |
numeric(11) |
Active |
Integer |
Throughput |
bigint |
TotalSessionTime |
bigint |
MaxSessionTime |
numeric(15) |
Started |
integer |
Stopped |
integer |
acsradiusaccounting
Table 15 acsradiusaccounting Table
|
|
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(500) |
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(500) |
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 |
text |
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 16 acsradiusaccountingmonth Table
|
|
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(15) |
Active |
Integer |
Throughput |
bigint |
TotalSessionTime |
bigint |
MaxSessionTime |
numeric(15) |
Started |
integer |
Stopped |
integer |
acsradiusaccountingyear
Table 17 acsradiusaccountingyear Table
|
|
ID |
Integer |
Month |
varchar(10) |
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(15) |
Active |
integer |
Throughput |
bigint |
TotalSessionTime |
bigint |
MaxSessionTime |
numeric(15) |
Started |
integer |
Stopped |
integer |
acsaaadiagnostics
Table 18 acsaaadiagnostics Table
|
|
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 19 acsadministratorlogin Table
|
|
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 20 acsconfigurationchanges Table
|
|
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 21 acslogcollectionfailures Table
|
|
ID |
integer |
ACSViewTimestamp |
datetime |
ACSServer |
varchar(500) |
ACSLoggingCategory |
varchar(100) |
Error |
text |
acsmessagecatalog
Table 22 acsmessagecatalog Table
|
|
ID |
integer |
MESSAGECODE |
integer |
MESSAGECLASS |
varchar(100) |
MESSAGETEXT |
text |
acsprocessstatus
Table 23 acsprocessstatus Table
|
|
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 24 acssystemstatus Table
|
|
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 25 acssystemdiagnostics Table
|
|
ID |
integer |
ACSTimestamp |
datetime |
ACSViewTimestamp |
datetime |
ACSServer |
varchar(500) |
MessageCode |
varchar(10) |
MessageSeverity |
varchar(10) |
Category |
varchar(100) |
DiagnosticInfo |
text |
acsviewnetflowaggregation
Table 26 acsviewnetflowaggregation Table
|
|
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 27 checkpointday Table
|
|
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 28 nadaaastatus Table
|
|
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 29 acstacacsauthentication Table
|
|
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 30 acstacacsauthenticationmonth Table
|
|
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 31 acstacacsauthenticationyear Table
|
|
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 32 acsradiusauthentication Table
|
|
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 33 acsradiusauthenticationmonth Table
|
|
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 34 acsradiusauthenticationyear Table
|
|
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 35 acstacacsauthorization Table
|
|
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 36 acstacacsauthorizationmonth Table
|
|
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 37 acstacacsauthorizationyear Table
|
|
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 38 acstacacsaccounting Table
|
|
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 39 acstacacsaccountingmonth Table
|
|
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 40 acstacacsaccountingyear Table
|
|
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 41 acsradiusaccounting Table
|
|
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 42 acsradiusaccountingmonth Table
|
|
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 43 acsradiusaccountingyear Table
|
|
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 44 acsaaadiagnostics Table
|
|
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 45 acsadministratorlogin Table
|
|
ID |
integer |
ACSTimestamp |
datetime |
ACSViewTimestamp |
datetime |
ACSServer |
varchar(500) |
MessageCode |
varchar(10) |
AdminName |
varchar(500) |
AdminIPAddress |
varchar(100) |
AdminSession |
varchar(100) |
AdminInterface |
varchar(10) |
AuthenticationResult |
varchar(100) |
AuthenticationResultReason |
varchar(100) |
AdministratorClientIP |
varchar(100) |
AccessService |
varchar(100) |
IdentityStore |
varchar(100) |
AdminAuthorizationResult |
varchar(100) |
AdminRoles |
varchar(100) |
AuthenticationMethod |
varchar(100) |
ActiveDirectoryDomain |
varchar(100) |
IdentityPolicyMatchedRule |
varchar(100) |
SelectedIdentityStore |
varchar(100) |
AuthorizationPolicyMatchedRule |
varchar(100) |
StaticRoleAssignment |
varchar(100) |
IsRecovery_Account |
varchar(100) |
ACSSession_ID |
varchar(100) |
OtherAttributes |
text |
ExecutionSteps |
text |
Response |
text |
acsconfigurationchanges
Table 46 acsconfigurationchanges Table
|
|
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 |
text |
ConfigChangeData |
text |
HostID |
varchar(100) |
RequestResponseType |
varchar(10) |
FailureFlag |
varchar(10) |
Details |
text |
OperatorName |
varchar(500) |
UserAdminFlag |
varchar(10) |
AccountName |
varchar(500) |
DeviceIP |
varchar(15) |
IdentityStoreName |
varchar(500) |
ChangePasswordMethod |
varchar(50) |
AuditPasswordType |
varchar(10) |
ObjectID |
varchar(100) |
AppliedToACSInstance |
varchar(500) |
LocalMode |
bit |
acslogcollectionfailures
Table 47 acslogcollectionfailures Table
|
|
ID |
integer |
ACSViewTimestamp |
datetime |
ACSServer |
varchar(500) |
ACSLoggingCategory |
varchar(100) |
Error |
text |
acsmessagecatalog
Table 48 acsmessagecatalog Table
|
|
ID |
integer |
MESSAGECODE |
bigint |
MESSAGECLASS |
varchar(100) |
MESSAGETEXT |
text |
acsprocessstatus
Table 49 acsprocessstatus Table
|
|
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 |
ntpd |
bit |
acssystemstatus
Table 50 acssystemstatus Table
|
|
ID |
integer |
ACSTimestamp |
datetime |
ACSViewTimestamp |
datetime |
ACSServer |
varchar(500) |
MessageCode |
varchar(10) |
CPUUtilization |
decimal(5,2) |
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 |
NetworkUtilization |
text |
acssystemdiagnostics
Table 51 acssystemdiagnostics Table
|
|
ID |
integer |
ACSTimestamp |
datetime |
ACSViewTimestamp |
datetime |
ACSServer |
varchar(500) |
MessageCode |
varchar(10) |
MessageSeverity |
varchar(10) |
Category |
varchar(100) |
DiagnosticInfo |
text |
acsviewnetflowaggregation
Table 52 acsviewnetflowaggregation Table
|
|
ID |
integer |
ACSViewTimestamp |
datetime |
SourceUsername |
varchar(500) |
SourceAddress |
varchar(15) |
SourcePort |
varchar(15) |
DestinationUsername |
varchar(500) |
DestinationAddress |
varchar(15) |
DestinationPort |
varchar(50) |
SGTName |
varchar(15) |
SGTValue |
integer |
DGTName |
varchar(15) |
DGTValue |
integer |
NASIPAddress |
varchar(15) |
Protocol |
varchar(15) |
ACLDrops |
integer |
checkpointday
Table 53 checkpointday Table
|
|
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 54 nadaaastatus Table
|
|
ID |
integer |
Timestamp |
datetime |
Alive |
bit |
ACSServer |
varchar(100) |
NASIP |
varchar(100) |
DeviceGroups |
text |