Working with Aggregate Data, 13-62 | Cisco Systems OL-24201-01

Chapter 13 Managing Reports

Organizing Report Data

Step 7 For the second argument, type the number of days to add. In this case, type 7.

Step 8 Validate the expression, then click Apply.

The new calculated column appears in the report. For every value in the Order Date column, the calculated column displays a date seven days later than the order date.

Subtracting Date Values in a Calculated Column

You can display the difference between two date values.

Step 1 Select a column.

In the report, the calculated column will appear to the right of the column you select.

Step 2 Select Add Calculation.

The Calculation dialog box appears.

Step 3 In Column Label, type a name for the calculated column.

For example, to subtract the actual shipping date from the date requested, type Shipping Delay.

Step 4 In Enter Expression, type the letter d.

A drop-down list appears, displaying functions that begin with d.

Step 5 Select DIFF_DAY(date1, date2).

Step 6 For the first argument, type a left opening bracket ( [ ) and select the first date column from the drop-down list.

For example, select Date Requested.

Step 7 For the second argument, type a left opening bracket ( [ ) and select the second date column from the drop-down list.

For example, select Actual Shipping Date.

Step 8 Validate the expression, then click Apply.

The new calculated column appears in the report, displaying the difference between the two dates.

Working with Aggregate Data

Aggregating data involves performing a calculation over a set of data rows. For example, in a report that has a column to calculate price*quantity, you can take the sum of all those calculations to obtain the total price of all items. You can create up to three aggregations for a calculated column.

When you aggregate data, you choose whether the aggregation appears in the table header or footer. If the column is a detail column in a data group, you can display the aggregate value in the group header or footer. Figure 13-39shows aggregate data in a group footer.

	User Guide for Cisco Secure Access Control System 5.3
13-62	OL-24201-01

Image 426

Cisco Systems OL-24201-01 manual Working with Aggregate Data, Subtracting Date Values in a Calculated Column, 13-62

Contents

User Guide for Cisco Secure Access Control System Americas HeadquartersPage N T E N T S Iii Rules-Based Service Selection Configuring an Authorization Policy for Host Lookup Requests My Account Exporting Network Devices and AAA Clients Vii Failover Viii Radius Identity Store in Identity Sequence Managing Access Policies Maximum User Session in Distributed Environment Creating and Editing Alarm Schedules Xii Exporting Report Data Xiii Adding Groups Xiv Filtering Chart Data Managing System Administrators Xvi Activating a Secondary Instance Xvii Configuring Logs Xviii Using Log Targets Xix PKI Usage EAP-MSCHAPv2 B-30 Xxi Xxii Audience Document ConventionsRevised April 17 Date Description Documentation UpdatesRelated Documentation Store Obtaining Documentation and Submitting a Service Request Preface User Guide for Cisco Secure Access Control System Introducing ACS Overview of ACS Related Topics ACS Distributed DeploymentACS 4.x and 5.3 Replication Related Topic ACS Licensing Model ACS Management InterfacesACS ACS Command Line Interface ACS Web-based Interface ACS Programmatic Interfaces ConfigHardware Models Supported by ACS ACS Web-based Interface, OL-24201-01 Migrating from ACS 4.x to ACS Supported Migration Versions Overview of the Migration ProcessMigration Requirements Migration Requirements, Supported Migration Versions, Downloading Migration Files Select System Administration Downloads Migration UtilityBefore You Begin Migrating from ACS 4.x to ACS Migrating from ACS 4.x to ACS Functionality Mapping from ACS 4.x to ACS Radius Radius VSA Common Scenarios in MigrationMigrating from ACS 4.2 on Csacs 1120 to ACS VSA Migrating from ACS 3.x to ACS Migrating Data from Other AAA Servers to ACS Migrating from ACS 4.x to ACS Common Scenarios in Migration OL-24201-01 ACS 5.x Policy Model Overview of the ACS 5.x Policy Model Information in ACS 5.3 Policy Element Policy Terminology Term Description Simple Policies Rule-Based PoliciesTypes of Policies, Types of Policies Access Services Policy Type Access Service Templates Access Service B Access Service C Access Service aFor Device Administration Hosts Wireless Devices Radius and TACACS+ Proxy Services Feature ACS Identity Policy Failure Options Authorization Policy for Device Administration Processing Rules with Multiple Command SetsGroup Mapping Policy Exception Authorization Policy Rules Service Selection PolicySimple Service Selection Simple Service Selection, Rules-Based Service Selection, Rules-Based Service Selection Access Services and Service Selection Scenarios First-Match Rule Tables Example Policy Rule Table Column Description Authorization Profiles for Network Access Policy ConditionsPolicy Results Processing Rules with Multiple Authorization Profiles Policies and Identity Attributes Policies and Network Device Groups Example of a Rule-Based Policy Flows for Configuring Services and Policies Prerequisites Step Action Drawer in Web Interface Editing Access Services,Customizing a Policy, Configuring Access Service Policies, Editing a Custom Session Condition, Related Topics OL-24201-01 Common Scenarios Using ACS Overview of Device Administration Session Administration Command Authorization Password-Based Network Access TACACS+ Custom Services and AttributesOverview of Password-Based Network Access RADIUS-PAP RADIUS-CHAP PEAP-GTCEAP-FAST-GTC EAP-MD5 Leap MAB Radius PAP Password-Based Network Access Configuration FlowProtocol Action Radius Chap Peap EAP-MSCHAPv2 or EAP-GTC or bothEAP-FAST Certificate-Based Network Access Overview of Certificate-Based Network Access Before you Begin Using Certificates in ACSCertificate-Based Network Access for EAP-TLS EAP-TLS User Guide for Cisco Secure Access Control System Agentless Network Access Overview of Agentless Network AccessValidating an Ldap Secure Authentication Connection Host Lookup Use Cases Attribute802.1x Authentication with Call Check PAP/EAP-MD5 Authentication Process Service-Type Call Check Agentless Network Access Flow For more information, see , Managing Policy Elements Previous Step Configuring an Ldap External Identity Store for Host LookupAdding a Host to an Internal Identity Store Next Step Previous Steps Creating an Access Service for Host LookupCreating an Access Service for Host Lookup, Managing Identity Attributes, Configuring an Identity Policy for Host Lookup Requests See Viewing Identity Policies, page 10-21, for detailsClick Save Changes VPN Remote Network Access See Customizing a Policy, page 10-4, for more informationSelect Host Lookup and click OK RADIUS/PAP RADIUS/CHAP Supported Authentication ProtocolsSupported Identity Stores LDAP-RADIUS/PAP Supported VPN Network Access Servers Configuring VPN Remote Access ServiceSupported VPN Clients ACS and Cisco Security Group Access Adding Devices for Security Group Access Creating Security Groups Configuring an Ndac Policy Creating SGACLs Configuring EAP-FAST Settings for Security Group Access Creating an Access Service for Security Group AccessSelect Network Access, and check Identity and Authorization Creating an Endpoint Admission Control Policy Creating an Egress Policy Creating a Default Policy Radius and TACACS+ Proxy Requests Supported Protocols Tacplusauthor TacplusauthenTacplusacct Connection to TACACS+ Server Supported Radius AttributesTACACS+ Body Encryption PAP Ascii Chap Configuring Proxy Service Welcome My Workspace WelcomeField Description Task Guides My Account Using the Web Interface Accessing the Web InterfaceLogging In, Logging Out, Logging Understanding the Web Interface Logging Out Web Interface Design Header, Navigation Pane, Content Area,Navigation Pane, Content Area, Header Navigation Pane Drawer Function Content Area Header, Content Area, Web Interface Location Deleted item Button or Field Description Filtering Sorting Secondary Windows Transfer Boxes Secondary Window Transfer Box Fields and Buttons Rule Table Pages Schedule Boxes Option Description See Displaying Hit Counts, page 10-10for more information Supported ACS Objects ACS 5.x Policy ModelSupported ACS Objects, Creating Import Files, Property Name Property Data Type Creating Import Files Uments Click File Operations Downloading the Template from the Web InterfaceUnderstanding the CSV Templates Click Download Add Template Creating the Import File Header Field Description Updating the Records in the ACS Internal Store Deleting Records from the ACS Internal Store Common Errors Concurrency Conflict Errors Deletion Errors Accessibility System Failure ErrorsDisplay and Readability Features Keyboard and Mouse Features Obtaining Additional Accessibility Information Configuring Minimal System Setup Step No Task Drawer Refer to Settings for Administrators Configuring Local ServerConfiguring Authentication Configuring Administrator Step No Task Drawer Refer to Configuring ACS to Manage Access Policies Task Drawer Refer to Understanding Alarm Configuring System AlarmSettings, Duplicating Alarm OL-24201-01 Managing Network Resources External Servers Network Device Groups Creating, Duplicating, and Editing Network Device GroupsChoose Network Resources Network Device Groups Deleting Network Device Groups Field Description Network Devices and AAA Clients Deleting Network Device Groups from a Hierarchy Viewing and Performing Bulk Operations for Network Devices Choose Network Resources Network Devices and AAA ClientsSee Displaying Network Device Properties, Exporting Network Devices and AAA Clients Network Device page appears Performing Bulk Operations for Network Resources and Users Managing Network Resources Network Devices and AAA Clients Exporting Network Resources and Users Creating, Duplicating, and Editing Network Devices Configuring Network Device and AAA Clients TACACS+ KEK SGT Displaying Network Device Properties TACACS+ Access Access Advanced SettingsSecurity Group Configuring a Default Network Device Deleting Network Devices About creating network device groups Working with External Proxy Servers Creating, Duplicating, and Editing External Proxy ServersChoose Network Resources External Proxy Servers Choose to create Radius proxy server Deleting External Proxy Servers OL-24201-01 Overview Internal Identity Stores External Identity Stores Ldap Certificate-Based Authentication Identity Stores with Two-Factor AuthenticationIdentity Groups Managing Internal Identity Stores Identity Sequences Authentication Information Creating Identity Groups Select Users and Identity Stores Identity GroupsClick File Operations to Managing Identity Attributes Deleting an Identity GroupStandard Attributes, User Attributes, Host Attributes, Standard Attributes User AttributesAttribute Description Configuring Authentication Settings for Users Choose System Administration Users Authentication SettingsHost Attributes Password History Options Description Creating Internal Users Defined under System Administration Users Authentication Resources and Users,Option Administration Users Authentication Settings Identity Stores Internal Identity Stores Users Deleting Users from Internal Identity Stores Mon dd hhmmss UTC YYYY, where Internal Users page appears without the deleted users Creating Hosts in Identity Stores Hhmmss UTC Yyyy , where Deleting Internal Hosts Management Hierarchy Configuring AAA Devices for Management HierarchyConfiguring Users or Hosts for Management Hierarchy Attributes of Management Hierarchy Configuring and Using UserIsInManagement Hierarchy Attribute Related Topics Managing External Identity Stores Ldap Overview Configuring Ldap Groups, Viewing Ldap Attributes, Directory ServiceAuthentication Using Ldap Multiple Ldap Instances Authenticating a User Using a Bind Connection FailoverLdap Connection Management Group Membership Information Retrieval Attributes Retrieval Certificate Retrieval Creating External Ldap Identity Stores Configuring an External Ldap Server Connection Ldap Server Connection Configuring External Ldap Directory Organization Schema If the tree containing subjects is the base DN, enter External identity store you created is saved Configuring Ldap Groups Deleting External Ldap Identity Stores Leveraging Cisco NAC Profiler as an External MAB Database Viewing Ldap Attributes Click Server Advanced Options Active Response Delay Ldap Interface Configuration in NAC Profiler Configuring Endpoint Profiles in NAC Profiler Click Save Profile Click the Server Connection tab Edit NAC Profiler Definition General Click Test Configuration Test Bind to Server Dialog Box Number of Subjects Number of Directory Groups Supported Authentication Protocols Microsoft AD User Guide for Cisco Secure Access Control System Machine Authentication Protocol Port number Certificate Retrieval for EAP-TLS Authentication Attribute Retrieval for AuthorizationGroup Retrieval for Authorization Concurrent Connection Management Machine Access Restrictions Machine Authentication AD Group Required ATZ profile Dial-in PermissionsCallback Options for Dial-in users Dial-in Support Attributes ACS Response Configuring an AD Identity Store Machine Authentication, page B-34Joining ACS to an AD Domain Click Selecting an AD Group, Configuring AD Attributes, Selecting an AD Group Configuring AD Attributes Available from the Attributes secondary window only Joining ACS to Domain Controllers Configuring RSA SecurID Agents RSA SecurID Server Creating and Editing RSA SecurID Token Servers PIN RSA Realm Settings Tab Configuring ACS Instance Settings Enable the RSA options file, Reset Agent Files, Enable the RSA options file Reset Agent Files Configuring Advanced Options Check the Enable identity caching check box Supported Authentication Protocols Radius Identity StoresRadius PAP TACACS+ ASCII/PAP Password Prompt User Group MappingGroups and Attributes Mapping Radius Identity Store in Identity Sequence Authentication Failure MessagesCause of Authentication Failure Failure Cases Username Special Format with Safeword Server User Attribute Cache Creating, Duplicating, and Editing Radius Identity ServersRadius PAP TACACS+ ASCII\PAP Configuring General Settings Server Connection Configuring Shell Prompts Configuring Directory Attributes Cisco-av-pair.some-avpair Configuring CA Certificates Configuring Shell Prompts, Configuring Advanced Options, Adding a Certificate Authority Select Users and Identity Stores Certificate Authorities Description of the certificate Deleting a Certificate Authority Configuring Certificate Authentication Profiles Exporting a Certificate Authority Certificate Authentication Profile page reappears Creating, Duplicating, and Editing Identity Store Sequences Configuring Identity Store SequencesAuthentication Sequence Attribute Retrieval Sequence 22 Identity Store Sequence Properties Deleting Identity Store Sequences OL-24201-01 OL-24201-01 Managing Policy Elements Managing Policy Conditions Managing Policy Elements Managing Policy Conditions Deleting a Session Condition, Managing Network Conditions, Select Policy Elements Session Conditions Date and Time Policy, Select Policy Elements Session Conditions Custom Deleting a Session Condition Managing Network Conditions Managing Policy Elements Managing Policy Conditions Importing Network Conditions Exporting Network Conditions Creating, Duplicating, and Editing End Station Filters Defining IP Address-Based End Station Filters Defining MAC Address-Based End Station Filters Defining CLI or DNIS-Based End Station Filters Creating, Duplicating, and Editing Device Filters Defining IP Address-Based Device Filters Defining Name-Based Device Filters Creating, Duplicating, and Editing Device Port Filters Defining NDG-Based Device Filters Defining IP Address-Based Device Port Filters Defining Name-Based Device Port Filters Managing Authorizations and Permissions Defining NDG-Based Device Port Filters Authorization Profiles Specifying Authorization Profiles Specifying Common Attributes in Authorization Profiles Vlan ID/Name Includes a Vlan assignment Specifying Radius Attributes in Authorization Profiles Attribute, its name, value, and type appear in the table. To Dictionary Creating and Editing Security Groups Creating Security Groups, Related Topics Defining General Shell Profile Properties Defining Common TasksDefining Common Tasks, Defining Custom Attributes, Privilege Level Shell Profile Common Tasks Defining Custom Attributes Replace OL-24201-01 Show Duplicated Creating, Duplicating, and Editing Downloadable ACLs Deleting an Authorizations and Permissions Policy Element Appears without the deleted object Configuring Security Group Access Control Lists OL-24201-01 Policy Creation Flow 10-1 Network Definition and Policy Goals Policy Creation Flow-Next Steps10-2 Network Definition and Policy Goals, Policy Elements in the Policy Creation FlowPolicy Creation Flow-Previous Step 10-3 Customizing a Policy Access Service Policy CreationService Selection Policy Creation 10-4 Configuring the Service Selection Policy Configuring a Policy-Next Steps10-5 Select Access Policies Service Selection Policy Configuring a Simple Service Selection PolicyService Selection Policy 10-6 See Displaying Hit Counts, 10-7 Creating, Duplicating, and Editing Service Selection Rules Select Access Policies Service Selection Policy. If you10-8 Conditions 10-9 Deleting Service Selection Rules Displaying Hit Counts10-10 Configuring Access Services Editing Default Access Services10-11 Creating, Duplicating, and Editing Access Services Select Access Policies Access Services10-12 Configuring General Access Service Properties 10-13 10-14 Configuring Access Service Allowed Protocols Select Access Policies Access Services, then click10-15 Server Certificates, page 18-14for more information 10-16 10-17 10-18 Configuring Access Services Templates 10-19 Type Protocols Policies Conditions Results Deleting an Access ServiceAccess Service 10-20 Configuring Access Service Policies Viewing Identity Policies10-21 10-22 Viewing Rules-Based Identity Policies 10-23 Configuring Identity Policy Rule Properties 10-24 10-25 Configuring a Group Mapping Policy 10-26 Displaying Hit Counts, 10-27 Configuring Group Mapping Policy Rule Properties 10-28 Select Access Policies Access Services service Authorization 10-29 10-30 Configuring Network Access Authorization Rule Properties 10-31 Configuring Device Administration Authorization Policies 10-32 10-33 Condition 10-34 Configuring Authorization Exception Policies 10-35 Condition Name 10-36 Creating Policy Rules 10-37 Duplicating a Rule Editing Policy Rules10-38 Deleting Policy Rules 10-39 Configuring Compound Conditions Compound Condition Building Blocks10-40 Atomic Condition Types of Compound ConditionsOperand1 Operand2 Example 10-41 Single Nested Compound Condition Multiple Nested Compound Condition10-42 Compound Expression with Dynamic value 10-43 Using the Compound Expression Builder 10-44 Policy Matrix, Security Group Access Control PagesEgress Policy Matrix Policy Page, Editing a Cell in the Egress Policy Matrix Defining a Default Policy for Egress PolicyCreating an Egress Policy, Creating a Default Policy, Creating an Egress Policy, Rule-Based Policy Ndac PolicySimple Policy 10-47 Configuring an Ndac Policy, Ndac Policy Properties Page, Ndac Policy Properties10-48 Configuring an Ndac Policy, Ndac Policy Page, 10-49 Network Device Access EAP-FAST Settings Maximum User Sessions10-50 Max Session User Settings Max Session Group Settings10-51 Max Session Global Setting Max User Session Global Settings10-52 Go to System Administration Users Purge User Sessions Purging User Sessions10-53 Maximum User Session in Distributed Environment Click Get Logged-in User List10-54 Maximum User Session in Proxy Scenario 10-55 10-56 Logging monitor informational Logging origin-id ip Epm logging11-1 Dashboard Pages Authentication Records and DetailsAuthentication Records and Details, 11-2 11-3 Working with Portlets 11-4 Working with Authentication Lookup Portlet 11-5 Dashboard Pages, Running Authentication Lookup Report, Configuring Tabs in the DashboardRunning Authentication Lookup Report Adding Tabs to the Dashboard Renaming Tabs in the Dashboard Adding Applications to Tabs11-7 Click Manage Pages Changing the Dashboard LayoutDeleting Tabs from the Dashboard 11-8 Threshold Alarms Understanding AlarmsThreshold Alarms, System Alarms, 12-1 Evaluating Alarm Thresholds, Notifying Users of Events, Evaluating Alarm ThresholdsSystem Alarms Evaluation Cycle1 Viewing and Editing Alarms in Your Inbox Notifying Users of Events12-3 Alarm Severity 12-4 12-5 12-6 12-7 Select Monitoring and Reports Alarms Inbox 12-8 Choose Monitoring and Reports Alarms Schedules Understanding Alarm SchedulesCreating and Editing Alarm Schedules 12-9 Assigning Alarm Schedules to Thresholds Choose Monitoring and Reports Alarms Thresholds12-10 Select Monitoring and Reports Alarms Thresholds Creating, Editing, and Duplicating Alarm ThresholdsDeleting Alarm Schedules 12-11 12-12 Configuring General Threshold Information 12-13 Passed Authentication Count Configuring Threshold CriteriaPassed Authentications ACS Instance 12-15 Device IP Failed AuthenticationsFailed Authentication Count 12-16 12-17 Authentication Inactivity 12-18 Tacacs Command Accounting 12-19 Tacacs Command Authorization 12-20 ACS Configuration Changes 12-21 ACS System Diagnostics 12-22 ACS Process Status 12-23 ACS System Health CPU12-24 ACS AAA Health 12-25 Radius Sessions 12-26 Count of Unknown NAD Authentication Records Unknown NAD12-27 External DB Unavailable 12-28 Rbacl Drops 12-29 Dstip NADDGT 12-30 NAD-Reported AAA Downtime Device IP Count of NAD-Reported AAA Down Events12-31 Configuring Threshold Notifications 12-32 Deleting Alarm Thresholds 12-33 Configuring System Alarm Settings 12-34 Understanding Alarm Syslog Targets Creating and Editing Alarm Syslog Targets12-35 Deleting Alarm Syslog Targets 12-36 Managing Reports 13-1 Catalog-Monitoring & Reports Reports Catalog reporttype 13-2 Click Add to Favorites Working with Favorite ReportsAdding Reports to Your Favorites 13-3 Choose Monitoring and Reports Reports Favorites Viewing Favorite-Report ParametersClick Add to Favorite 13-4 Select Monitoring & Reports Reports Favorites Editing Favorite ReportsRunning Favorite Reports 13-5 Click Launch Interactive Viewer for more options Sharing ReportsDeleting Reports from Favorites Reports Reports Catalog ACS Instance Report Name Description Logging Category Working with Catalog ReportsAvailable Reports in the Catalog 13-7 13-8 13-9 13-10 Running Catalog Reports 13-11 13-12 Deleting Catalog Reports Running Named Reports13-13 Reporttype Reportname 13-14 Understanding the ReportName 13-15 13-16 13-17 Enabling Radius CoA Options on a Device 13-18 13-19 Radius Active Session Report Click Launch Interactive Viewer Customizing ReportsRestoring Reports 13-20 About Interactive Viewer Viewing ReportsAbout Standard Viewer About Interactive Viewer’s Context Menus 13-22 Context Menu for Column Data in Interactive Viewer Using the Table of Contents Navigating Reports Exporting Report Data 13-24 13-25 12 The Export Data Dialog Box Printing Reports Saving Report Designs in Interactive Viewer13-26 Formatting Reports in Interactive Viewer Editing Labels13-27 Resizing Columns Formatting LabelsFormatting Data Select Change Text Formatting Data in Aggregate Rows Changing Column Data AlignmentFormatting Data in Columns Select Style Font Formatting Data Types Data type Option Description13-30 Formatting Numeric Data 13-31 Data in the data set Result of formatting Formatting Fixed or Scientific Numbers or PercentagesFormatting Custom Numeric Data 13-32 Formatting Custom String Data SymbolFormatting String Data 13-33 Formatting Date and Time Data in the data source Results of formatting13-34 Mmmm Formatting Custom Date and TimeFormat Result of formatting 13-35 Formatting Boolean Data Applying Conditional Formats13-36 Setting Conditional Formatting for Columns Select Style Conditional Formatting13-37 13-38 19 Comparison Value Field Deleting Conditional Formatting 13-39 Setting and Removing Page Breaks in Detail Columns Setting and Removing Page Breaks in a Group Column13-40 Organizing Report Data Displaying and Organizing Report Data13-41 Reordering Columns in Interactive Viewer Select Column Move to Group Header13-42 Removing Columns 13-43 Select Hide or Show Items Hiding or Displaying Report ItemsHiding Columns Select Column Hide Column Select Column Show Columns Displaying Hidden ColumnsMerging Columns 13-45 Selecting a Column from a Merged Column Select Column Merge Columns13-46 Sorting Multiple Columns Sorting DataSorting a Single Column Sorting a Single Column, Sorting Multiple Columns, Grouping Data 13-48 13-49 Adding Groups Grouping Data Based on Date or Time13-50 Removing an Inner Group Creating Report Calculations13-51 13-52 37 Calculated Column Understanding Supported Calculation Functions Function Description Example of use13-53 Count Countdistinct13-54 Isbottomnpercent 13-55 13-56 Movingaverage 13-57 Today 13-58 Weightedaverage 13-59 Operator Description Using Numbers and Dates in an ExpressionUnderstanding Supported Operators 13-60 Select Add Calculation Using Multiply Values in Calculated ColumnsAdding Days to an Existing Date Value 13-61 Working with Aggregate Data Subtracting Date Values in a Calculated Column13-62 Aggregate functions Description 13-63 Creating an Aggregate Data Row 13-64 Adding Additional Aggregate Rows Click Add aggregation13-65 Hiding or Displaying Column Data Hiding and Filtering Report DataDeleting Aggregate Rows 13-66 Displaying Repeated Values Hiding or Displaying Detail Rows in Groups or Sections13-67 Working with Filters Condition Description13-68 Types of Filter Conditions 13-69 Setting Filter Values 13-70 Creating Filters 13-71 Modifying or Clearing a Filter Creating a Filter with Multiple Conditions13-72 Click Advanced Filter Click Add Condition13-73 Filtering Highest or Lowest Values in Columns 13-74 Understanding Charts 13-75 Modifying Charts Filtering Chart Data13-76 Select Chart Subtype Changing Chart SubtypeChanging Chart Formatting 13-77 50 Chart Formatting Options 13-78 ACS Support Bundle Available Diagnostic and Troubleshooting ToolsConnectivity Tests 14-1 Expert Troubleshooter 14-2 See Comparing Sgacl Policy Between a Network Device and ACS Diagnostic Tool DescriptionPerforming Connectivity Tests ACS-Assigned SGT Records, page 14-14for more information Downloading ACS Support Bundles for Diagnostic Information 14-4 Working with Expert Troubleshooter 14-5 Troubleshooting Radius Authentications NAS IP14-6 14-7 Click Show Results Summary 14-8 Executing the Show Command on a Network Device 14-9 Evaluating the Configuration of a Network Device AAA14-10 Comparing Sgacl Policy Between a Network Device and ACS SGA14-11 Comparing the SXP-IP Mappings Between a Device and its Peers 14-12 Click the User Input Required button VRF14-13 14-14 Comparing Device SGT with ACS-Assigned Device SGT 14-15 14-16 15-1 15-2 Configuring Data Purging and Incremental Backup 15-3 15-4 15-5 Configuring NFS stagging 15-6 Viewing Log Collections Restoring Data from a BackupConfiguring Data Purging and Incremental Backup, 15-7 Log Collection Details Page, 15-8 Log Collection Details 15-9 15-10 Recovering Log Messages Viewing Scheduled Jobs15-11 15-12 Viewing Process Status 15-13 Editing Failure Reasons Viewing Data Upgrade StatusViewing Failure Reasons Failure Reasons Editor Email Settings Specifying E-Mail SettingsConfiguring Snmp Preferences 15-15 Understanding Collection Filters Creating and Editing Collection Filters15-16 Deleting Collection Filters Configuring Alarm Syslog TargetsConfiguring Remote Database Settings 15-17 15-18 Managing System Administrators 16-1 Understanding Administrator Roles and Accounts 16-2 Understanding Roles Configuring System Administrators and AccountsUnderstanding Authentication 16-3 Role Privileges PermissionsPredefined Roles 16-4 Changing Role Associations 16-5 Administrator Accounts and Role Association Choose System Administration Administrators Accounts16-6 16-7 Viewing Role Properties Choose System Administration Administrators RolesViewing Predefined Roles Button and click View Configuring Authentication Settings for Administrators 16-9 16-10 Choose System Administration Administrators Settings Access Configuring Session Idle TimeoutConfiguring Administrator Access Settings Allow All IP Addresses to Connect Resetting the Administrator Password Access-setting accept-all16-12 Choose My Workspace My Account Changing the Administrator PasswordChanging Your Own Administrator Password 16-13 Resetting Another Administrator’s Password 16-14 Configuring System Operations 17-1 Aaa-server radius-authport Service PortUnderstanding Distributed Deployment 17-2 Activating Secondary Servers, Activating Secondary ServersRemoving Secondary Servers 17-3 Understanding Distributed Deployment, Understanding Local ModePromoting a Secondary Server 17-4 Specifying a Hardware Replacement Understanding Full Replication17-5 Creating, Duplicating, and Editing Scheduled Backups, Scheduled BackupsCreating, Duplicating, and Editing Scheduled Backups Choose System Administration Operations Scheduled Backups Backing Up Primary and Secondary Instances Backing Up Primary and Secondary Instances,17-7 Editing Instances Viewing and Editing a Primary Instance17-8 Ddmmyyyy 17-9 GUI 17-10 17-11 Editing Instances, Viewing and Editing a Primary Instance, Viewing and Editing a Secondary InstanceDeleting a Secondary Instance 17-12 Click Activate Activating a Secondary InstanceRegistering a Secondary Instance to a Primary Instance 17-13 17-14 Click Register to Primary 17-15 Click Deregister Click Deregister from Primary17-16 17-17 Replicating a Secondary Instance from a Primary Instance 17-18 Click Full Replication 17-19 See Registering a Secondary Instance to a Primary Instance, 17-20 Failover 17-21 Click Request Local Mode 17-22 17-23 17-24 Manage licensing. See Licensing Overview, Configuring Global System OptionsConfiguring TACACS+ Settings 18-1 Configuring EAP-TLS Settings 18-2 Generating EAP-FAST PAC, Configuring Peap SettingsConfiguring EAP-FAST Settings 18-3 Click Generate PAC Configuring RSA SecurID PromptsGenerating EAP-FAST PAC Tokencode YOU Prepared to Accept a SYSTEM-GENERATED PIN? Managing DictionariesViewing Radius and TACACS+ Attributes Radius Ietf Radius VSAs, page A-6 18-6 Viewing Radius and TACACS+ Attributes, 18-7 18-8 Viewing Radius Vendor-Specific Subattributes 18-9 Configuring Identity Dictionaries 18-10 Configuring Internal Identity Attributes 18-11 Deleting an Internal User Identity Attribute Policy Elements Session Conditions Custom18-12 Deleting an Internal Host Identity Attribute 18-13 Configuring Local Server Certificates Adding Local Server Certificates18-14 Associating Certificates to Protocols, Signing Request,18-15 Select Generate Self Signed Certificate Next Generating Self-Signed CertificatesEAP 18-16 Select Generate Certificate Signing Request Next Generating a Certificate Signing RequestBinding CA Signed Certificates Click Finish Editing and Renewing Certificates Select Bind CA Signed Certificate Next18-18 Deleting Certificates 18-19 Exporting Certificates Viewing Outstanding Signing Requests18-20 Configuring Logs Configuring Remote Log Targets18-21 Deleting a Remote Log Target, Target ConfigurationGeneral 18-22 Deleting a Remote Log Target Configuring the Local LogConfiguring Remote Log Targets, Deleting Local Log Data Option Descriptions Configuring Logging CategoriesConfiguring Global Logging Categories 18-24 18-25 Category Log and Description 18-26 18-27 Show logging system 18-28 Configuring Per-Instance Logging Categories Configuring Per-Instance Security and Log Settings,18-29 Configuring Per-Instance Security and Log Settings 18-30 Click the Remote Syslog Target tab Configuring Per-Instance Remote Syslog TargetsConfigure Logged Attributes 18-31 Displaying Logging Categories 18-32 Configuring the Log Collector Viewing the Log Message Catalog18-33 License Description Licensing OverviewTypes of Licenses 18-34 Installing a License File 18-35 Viewing the Base License PAK18-36 Upgrading the Base Server License Upgrading the Base Server License,18-37 Viewing License Feature Options 18-38 Adding Deployment License Files 18-39 Click Delete to delete the license file Deleting Deployment License FilesAvailable Downloads 18-40 Downloading Sample Python Scripts Downloading UCP Web Service FilesDownloading Migration Utility Files 18-41 Downloading Rest Services Choose System Administration Downloads Rest Service18-42 About Logging About Logging, ACS 4.x Versus ACS 5.3 Logging,19-1 Using Log Targets Logging Categories19-2 19-3 Global and Per-Instance Logging Categories Log Message Severity Levels19-4 Local Store Target ACS Severity Syslog Severity Level Description19-5 19-6 Critical Log Target 19-7 Remote Syslog Server Target 19-8 19-9 Monitoring and Reports Server Target Viewing Log Messages19-10 Debug Logs 19-11 ACS 4.x Versus ACS 5.3 Logging CSV19-12 Use the System Configuration Logging Use the Reports and Activity pages19-13 19-14 Device Administration TACACS+ Typical Use Cases Command Authorization Requests Network Access Radius With and Without EAPSession Access Requests Device Administration TACACS+ PAP Chap PEAP/EAP-GTC RADIUS-Based Flow Without EAP AuthenticationRADIUS-Based Flows with EAP Authentication EAP-FAST/EAP-GTC Figure A-3shows a RADIUS-based authentication with EAP Access Protocols-TACACS+ and Radius Overview of TACACS+Point of Comparison Overview of Radius Radius VSAs ACS 5.3 as the AAA Server Radius Attribute Support in ACS Address IP Integer Time Authorization Radius Access RequestsAuthentication Accounting OL-24201-01 Authentication Considerations Authentication and User Databases PAP, page B-2 CHAP, page B-31 EAP-MSCHAPv2, page B-30 Radius PAP Authentication EAP Information see EAP-MSCHAPv2, page B-30 EAP message type EAP codeEAP Method Description EAP-GTC Host Lookup, Overview of Agentless Network Access, Overview of EAP-MD5EAP- MD5 Flow in ACS User Certificate Authentication Overview of EAP-TLS PKI Authentication PKI Credentials PKI Usage Acquiring Local Certificates Fixed Management CertificatesImporting Trust Certificates Importing the ACS Server Certificate Initial Self-Signed Certificate GenerationCertificate Generation Exporting Credentials Hardware Replacement and Certificates Credentials DistributionSecuring the Cryptographic Sensitive Material Private Keys and Passwords Backup EAP-TLS Flow in ACS PEAPv0/1 Overview of PEAP, page B-15 EAP-MSCHAPv2, page B-30 Supported Peap Features Overview of Peap Fast Reconnect Peap Flow in ACS Creating the TLS Tunnel Authenticating with MSCHAPv2 Overview of EAP-FAST EAP-FAST EAP-FAST in ACS EAP-FAST Benefits About Master-Keys About PACs Provisioning Modes Types of PACs Automatic In-Band PAC Provisioning ACS-Supported Features for PACs Machine PAC AuthenticationProactive PAC Update PAC Type Tunnel v1/v1a/SGA Machine Authorization Accept Peer on Authenticated ProvisioningPAC-Less Authentication PAC EAP-FAST Flow in ACS Master Key Generation and PAC TTLsEAP-FAST for Allow TLS Renegotiation EAP-FAST PAC Management Key Distribution Algorithm EAP-FAST PAC-Opaque Packing and UnpackingRevocation Method EAP Authentication with Radius Key Wrap PAC Migration from ACS EAP-MSCHAPv2 MSCHAPv2 for User AuthenticationMSCHAPv2 for Change Password Overview of EAP-MSCHAPv2 Windows Machine Authentication Against AD EAP- MSCHAPv2 Flow in ACS SAN Certificate AttributesCertificate Binary Comparison SAN-DNS Certificate Revocation Rules Relating to Textual Attributes Machine Authentication Identity Store Authentication Protocol and Identity Store CompatibilityMicrosoft AD, Managing External Identity Stores, MSCHAPv1/MSCHAPv2 EAP-TLS EAP-MSCHAPv2 License Issues OpenSSL/Open SSL ProjectOpenSSL License Original SSLeay License Appendix C Open Source License Acknowledgments OL-24201-01 O S S a R Y GL-1 Capability of ACS to record user sessions in a log file GL-2 Validity and conformance of the original information GL-3 GL-4 GL-5 GL-6 GL-7 GL-8 GL-9 FTP EAP-FAST PAC GL-10 GL-11 GL-12 Service providerISP GL-13 GL-14 Extension within certificate information GL-15 GL-16 GL-17 GL-18 GL-19 GL-20 Symbols IN-1 IN-2 Date expressions IN-3 Formatting symbols IN-4 Hide Detail command IN-5 IN-6 Or operator 13-60,13-74 IN-7 Summary values IN-8 Upper function IN-9 IN-10