Table Of Contents

Symbols - A - B - C - D - E - F - G - H - I - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y -

Index

Symbols

! formatting symbol 13-37

% operator 13-64

& formatting symbol 13-37

& operator 13-64

* operator 13-64

+ operator 13-64

/ operator 13-64

<= operator 13-64

<> operator 13-64

< formatting symbol 13-37

< operator 13-64

= operator 13-64

>= operator 13-64

> formatting symbol 13-37

> operator 13-64

@ formatting symbol 13-37

- operator 13-64

A

ABS function 13-56

absolute values 13-56

accessing

data 13-70

Interactive Viewer 13-24

table of contents entries 13-27

ACS distributed deployment 17-2

ADD_DAY function 13-56

ADD_HOUR function 13-56

ADD_MINUTE function 13-56

ADD_MONTH function 13-56

ADD_QUARTER function 13-56

ADD_SECOND function 13-56

ADD_WEEK function 13-56

ADD_YEAR function 13-56

Add Group command 13-53, 13-54

adding

aggregate rows 13-68, 13-69

data filters 13-72, 13-74, 13-75, 13-76

data groups 13-52, 13-53

formatting rules 13-40, 13-41

page breaks 13-44

addition operator 13-64

administrator access setting 16-14

administrator password policy 16-11

administrator password reset 16-23

administrator roles 16-2

Advanced Filter dialog 13-76, 13-77, 13-78

Advanced Sort command 13-50

aggregate functions 13-67, 13-68

aggregate rows

creating 13-68, 13-69

formatting data in 13-33

aggregate values 13-45

Aggregation dialog 13-68

alarms 12-1

syslog targets 12-35

system alarms 12-34

alarm schedules 12-9

aligning data 13-32

alignment options 13-32

AND operator 13-64, 13-78

Any Of condition 13-72

arguments 13-55

Arrange Columns dialog 13-45

ascending sort order 13-50

AVERAGE function 13-57

Average function 13-67

averages 13-57, 13-60, 13-63, 13-67

B

background colors 13-42

Between condition 13-72, 13-77

BETWEEN function 13-57

Between operator 13-41

blank characters 13-62

Boolean values 13-58, 13-62, 13-73

Bottom N condition 13-73

Bottom Percent condition 13-73

C

calculated columns

aggregating data and 13-66, 13-68, 13-69

creating 13-55, 13-64

placing values in 13-58

Calculation dialog 13-55, 13-65, 13-66

calculations 13-45

case conversions 13-37

case-insensitive searches 13-62

case-sensitive searches 13-58

category series 13-79

cautions

description ii-xxiv

CEILING function 13-57

changing

aggregate values 13-33

chart subtypes 13-81

column headers 13-27, 13-31

conditional formats 13-41

data filters 13-76

default formats 13-32

labels 13-31

reports 13-24

character patterns 13-62, 13-74

character placeholder 13-37

charts

overview 13-79

Chart Subtype command 13-81

Cisco CAT 6K 4-23

clearing data filters 13-76

closing Standard Viewer 13-24

collapsing data groups 13-53, 13-71, 13-72

colors 13-42

column headers 13-27

column names 13-75

Column Properties dialog 13-32

columns

aligning data in 13-32

changing order of 13-45

counting rows in 13-67

deleting 13-47

determining first value in 13-58, 13-67

determining last value in 13-59, 13-67

determining type 13-35

displaying data in 13-33

formatting data in 13-40, 13-41

grouping date and time values in 13-53

resizing 13-28, 13-32

sorting data in 13-50, 13-78

Column Width command 13-32

comma-separated values files. See CSV files

comparison filters 13-74

comparison operators 13-41, 13-74

comparisons 13-40, 13-41, 13-58

concatenation operator 13-64

Conditional Formatting dialog 13-40, 13-41, 13-43

conditional formatting rules 13-40, 13-41

conditions

filtering data and 13-72, 13-73, 13-76

formatting data and 13-40

context menus 13-25

conversions 13-37

COUNT_DISTINCT function 13-57

COUNT function 13-57

Count function 13-67

Count Value function 13-67

creating

aggregate rows 13-68, 13-69

calculated columns 13-55, 13-64

data filters 13-72, 13-74, 13-75, 13-76

data groups 13-52, 13-53

formatting rules 13-40, 13-41

crud operations 7-6

CSV files 13-27, 13-29

currency 13-35

Currency format option 13-34

currency formatting options 13-35

currency symbols 13-35

Custom format option 13-34

customizing

formats 13-36

D

data

accessing 13-70

aligning 13-32

displaying 13-33, 13-45, 13-70

hiding 13-47

plotting relationships for 13-79

data filters 13-72, 13-74, 13-75, 13-76

data points 13-79

data rows 13-70, 13-71

data sections 13-71, 13-72

data sets 13-45, 13-67, 13-70, 13-79

data sources 13-29, 13-35, 13-50, 13-70

data types 13-35

Date and Time Format dialog 13-38

date calculations 13-66

date data types 13-34

date expressions 13-64, 13-66

date formats 13-34, 13-38

Date or Time Column Format dialog 13-39

date values 13-38, 13-53, 13-57

DAY function 13-57

decimal values 13-35

default formats 13-32

default network device 7-18

deleting

columns 13-47

conditional formats 13-43

data filters 13-76

filter conditions 13-78

page breaks 13-44

delimited text files 13-27, 13-29

descending sort order 13-50

designs

hiding data in 13-70

organizing data in 13-45

saving 13-30

DIFF_DAY function 13-57

DIFF_HOUR function 13-57

DIFF_MINUTE function 13-57

DIFF_MONTH function 13-57

DIFF_QUARTER function 13-57

DIFF_SECOND function 13-57

DIFF_WEEK function 13-57

DIFF_YEAR function 13-57

displaying

data 13-33, 13-45, 13-70

detail rows 13-71

reports 13-24

specific report pages 13-26, 13-27

table of contents 13-26

distinct values 13-57, 13-67

division 13-60, 13-64

division operator 13-64

downloads 18-44

duplicate values 13-70, 13-71

E

EAP-FAST

enabling B-27

identity protection B-21

logging B-20

master keys

definition B-22

PAC

automatic provisioning B-24

definition B-22

manual provisioning B-25

refresh B-27

phases B-20

EAP-FAST settings

configuring 18-4

EAP-TLS settings

configuring 18-2

equality 13-64, 13-77

equality operator 13-64

Equal to condition 13-73

Excel spreadsheets 13-27

expanding sections or groups 13-71

expanding table of contents entries 13-27

Export Data dialog 13-28

expressions

calculating data and 13-64

filtering data and 13-72, 13-73, 13-74, 13-76, 13-78

external identity server

RSA SecurID 8-65

external identity servers

RADIUS identity stores 8-71

external identity stores 8-3

LDAP 8-23

Microsoft AD 8-45

F

false function 13-58

fields 13-31

filter conditions 13-72, 13-73, 13-76, 13-78

Filter dialog 13-75, 13-76

Filter drop-down list 13-79

filters 13-72, 13-74, 13-75, 13-76

FIND function 13-58

finding text values 13-58, 13-62

FIRST function 13-58

First function 13-67

Fixed format option 13-34

fixed numeric values 13-35

Font dialog box 13-42

fonts 13-42, 13-81

footers 13-66

Format Chart page 13-81

Format command 13-81

format patterns 13-36, 13-37

formats

changing 13-32, 13-41

customizing 13-36

data types and 13-33

deleting conditional 13-43

exporting data and 13-27

previewing conditional 13-42

selecting 13-35

formatting

column headers 13-31

labels 13-31

string data 13-36

formatting options 13-35, 13-36, 13-38

formatting rules 13-40, 13-41

formatting symbols 13-36, 13-37

functions 13-55, 13-56, 13-67, 13-68

G

General Date format option 13-34

General Number format option 13-34

Go to page pick list 13-26

Greater Than condition 13-73

greater than operator 13-64

Greater Than or Equal to condition 13-73

greater than or equal to operator 13-64

Group Detail dialog 13-54

grouping

filter conditions 13-78

grouping intervals 13-53

groups

adding 13-52, 13-53

aggregating data and 13-66

collapsing 13-53, 13-71, 13-72

counting rows for 13-57

displaying data and 13-45, 13-70

setting page breaks for 13-44

sorting data and 13-51

H

headers 13-27, 13-66

hidden items 13-48

Hide Column command 13-48

Hide Detail command 13-72

Hide or Show Items dialog 13-47

hiding

detail rows 13-71

duplicate values 13-70, 13-71

report items 13-47

HTML files 13-29

HTTP Proxy Settings for CRL Requests

configuring 18-3

I

identity store sequences 8-86

If...Then...Else statement 13-58

IF function 13-58

import and export

creating import files 5-21

supported objects 5-18

information objects 13-33

IN function 13-58

Interactive Viewer 13-24, 13-25

internal identity stores 8-1

ISBOTTOMN function 13-59

ISBOTTOMNPERCENT function 13-59

Is False condition 13-73

Is False operator 13-41

Is Not Null condition 13-73

Is Not Null operator 13-41

Is Null condition 13-73

ISNULL function 13-59

Is Null operator 13-41

ISTOPN function 13-59

ISTOPNPERCENT function 13-59

Is True condition 13-73

Is True operator 13-41

L

labels 13-31

formatting 13-31

LAST function 13-59

Last function 13-67

leading characters 13-62

LEFT function 13-59

LEN function 13-59

Less Than condition 13-73

less than operator 13-64

Less Than or Equal to condition 13-73

less than or equal to operator 13-64

licensing 18-38

Like condition 13-73

LIKE function 13-60

literal values 13-77

locales

creating charts and 13-81

customizing formats for 13-33, 13-35, 13-38

locating text values 13-58, 13-62

logical operators 13-64

Long Date format option 13-34

Long Time format option 13-34

lowercase characters 13-60

Lowercase format option 13-34

LOWER function 13-60

M

master key

definition B-22

matching character patterns 13-74

mathematical functions 13-55, 13-56

mathematical operators 13-64

MAX function 13-60

Max function 13-67

MEDIAN function 13-60

Median function 13-67

median values 13-60, 13-67

Medium Date format option 13-34

Medium Time format option 13-34

membership filters 13-74

menus 13-25

migration

common scenarios 2-7

considerations 2-3

downloads 2-3

requirements 2-2

supported versions 2-2

MIN function 13-60

Min function 13-67

Mode function 13-67

MOD function 13-60

monitoring and report viewer

configuring remote database 15-20

dashboard 11-2

data backup and purge 15-3

data upgrade status 15-15

restore 15-7

viewing process status 15-14

viewing scheduled jobs 15-13

MONTH function 13-60

Move to Group Header command 13-46

Move to Group Header dialog 13-46

MOVINGAVERAGE function 13-60

moving columns 13-45

moving through reports 13-26

multipage reports 13-71

multiplication 13-65

multiplication operator 13-64

N

naming

calculated columns 13-65

navigating through reports 13-26

navigational tools 13-26

negative numbers 13-35

non-null values 13-59, 13-60, 13-73

Not Between condition 13-73

Not Between operator 13-41

note, description of ii-xxiv

Not Equal to condition 13-73

not equal to operator 13-64

Not Like condition 13-73

NOTNULL function 13-60

NOT operator 13-64, 13-78

NOW function 13-60

null value filters 13-74

null values 13-59, 13-60, 13-73, 13-74

Number Column Format dialog 13-35

Number column format dialog 13-36

number formats 13-34, 13-35, 13-36

numeric data types 13-34

numeric expressions 13-64, 13-65

numeric values 13-27, 13-36

O

opening

exported data files 13-29

Interactive Viewer 13-24

operators 13-41, 13-64

OR operator 13-64, 13-78

P

PAC

automatic provisioning B-24

definition B-22

manual provisioning B-25

refresh B-27

Page Break on Group dialog 13-44

page breaks 13-44

paging toolbar 13-26

pattern-matching filters 13-74

PDF files 13-29

PEAP

identity protection B-15

phases B-15

PEAP settings

configuring 18-3

percentage operator 13-64

percentages 13-35, 13-59, 13-61

Percent format option 13-34

PERCENTILE function 13-61

PERCENTRANK function 13-61

PERCENTSUM function 13-61

previewing conditional formats 13-42

primary sorting column 13-51

Print dialog 13-29

printing 13-29

printing options 13-29

Q

QUARTER function 13-61

QUARTILE function 13-61

Quartile function 13-67

R

RADIUS proxy 4-28

configuring proxy service 4-35

supported protocols 4-34

supported RADIUS attributes 4-35

range filters 13-74

range of values 13-40, 13-41, 13-72, 13-74

RANK function 13-61

relationships 13-79

Reorder Columns command 13-45

report designs

hiding data in 13-70

organizing data in 13-45

saving 13-30

report items 13-47

reports 13-1

catalog 13-10

changing 13-24

displaying 13-24

dynamic change of authorization 13-2

favorites 13-3

navigating through 13-26

printing 13-29

scheduled reports 13-7

setting page breaks for 13-44

shared 13-6

viewing specific pages in 13-26, 13-27

report sections 13-71, 13-72

report templates 13-31, 13-81

report viewers 13-24

resizing columns 13-28, 13-32

RIGHT function 13-61

ROUNDDOWN function 13-62

ROUND function 13-61

rounding 13-57, 13-61

ROUNDUP function 13-62

row-by-row comparisons 13-58

rows 13-70, 13-71

RUNNINGSUM function 13-62

running totals 13-62

S

Save As dialog 13-29

saving

exported data 13-29

report designs 13-30

Scientific format option 13-34

scientific numbers 13-35

SEARCH function 13-62

searching 13-58, 13-62, 13-75

sections 13-71, 13-72

Security Access Group 4-23

Select data item dialog 13-75

Short Date format option 13-34

Short Time format option 13-34

Show Columns command 13-48

Show Columns dialog 13-48

Show Detail command 13-72

sorting multiple columns 13-51

sort order 13-50

spreadsheet reports 13-27

SQRT function 13-62

square roots 13-62

standard deviation 13-62, 13-67

Standard Deviation function 13-67

Standard Viewer 13-24

STDEV function 13-62

String Column Format dialog 13-37

String column format dialog 13-36

string conversions 13-37

string data types 13-34

string fields 13-74

string patterns 13-62

strings 13-36, 13-59, 13-73

substrings 13-59, 13-61, 13-73

subtraction operator 13-64

subtypes (charts) 13-81

SUM function 13-62

Sum function 13-67

summary values 13-62, 13-67

T

tables

aggregating data and 13-66, 13-68, 13-69

counting rows in 13-57, 13-67

TACACS+ settings

configuring 18-1

templates 13-31, 13-81

testing

character patterns 13-74

for non-null values 13-60

for null values 13-59, 13-74

range of values 13-74

sets of values 13-74

text

aggregating values for 13-68

changing label 13-31

converting case 13-37

searching for 13-58, 13-62

text files 13-27, 13-29

text formats 13-34

text patterns 13-74

text styles 13-42

themes 13-81

thousands separators 13-35

time data types 13-34

time formats 13-34, 13-38

timesaver, description of ii-xxiv

time stamps 13-60, 13-62

time values 13-38, 13-53

TODAY function 13-62

Top N condition 13-73

Top Percent condition 13-73

totals 13-40, 13-62, 13-67

trailing characters 13-62

TRIM function 13-62

TRIMLEFT function 13-62

TRIMRIGHT function 13-62

troubleshooting

connectivity 14-1

expert troubleshooter 14-2

support bundles 14-1

true function 13-62

U

Unformatted format option 13-34

uppercase characters 13-62

Uppercase format option 13-34

UPPER function 13-62

V

values

averaging 13-57, 13-60, 13-63, 13-67

calculating 13-45

comparing 13-40, 13-41, 13-74

counting number of distinct 13-57, 13-67

determining rank 13-61

displaying frequently occurring 13-67

hiding duplicate 13-70, 13-71

returning highest 13-60, 13-67

returning last 13-59, 13-67

returning lowest 13-60, 13-67, 13-73

returning null 13-73

returning specified 13-73

rounding 13-57, 13-61

searching for 13-75

sorting highest or lowest 13-78

testing for non-null 13-60

testing for null 13-59, 13-74

testing for specified 13-58

testing range of 13-74

testing sets of 13-74

value series 13-79

VAR function 13-62

variance 13-62, 13-67

Variance function 13-67

viewers 13-24

viewing

data 13-33, 13-45, 13-70

detail rows 13-71

reports 13-24

specific report pages 13-26, 13-27

table of contents 13-26

viewing environments 13-24

vpn remote access 4-20

configuring access service 4-22

supported clients 4-22

supported identity stores 4-21

supported network access servers 4-21

supported protocols 4-21

W

WEEKDAY function 13-63

WEEK function 13-62

WEIGHTEDAVERAGE function 13-63

Weighted average function 13-67

wildcard characters 13-62

X

x-axis values 13-79

Y

y-axis values 13-79

YEAR function 13-63