Point 'n' Click
The query builder built into aaa-reports! gives you instant access to
the power of a relational database in a convenient
windowing environment. Forget learning complex SQL
syntax - just select the data source (AAA server logs,
imported ACS database or even the datasets that drive
our canned reports) select which fields you want to see
and hit Run. The data is then displayed for you ready to
export as csv, excel, html or text.
If you need to go further you can choose to display
only certain columns, sort/filter/group on others, and
even calculate totals and counters. If you want to
create a custom report just click Save and give it a
name - you'll then be able to include it in any report
batches you have configured.
With the query builder you can do things like
Find the number of times a given user logged in between
Total up the number of failed login attempts against devices
in a specific Network Device Group
Create session counts and session duration totals for each
AAA server Group sorted by group name
Group unauthorised command attempts by user
Of course if you need to perform complex searches the
query builder supports common SQL operators such as
equal, not equal, null and like plus combinational logic
(or, and) etc.
With all this functionality and your
imported AAA server logs you have all the tools you need to deep
dive into the data and find what you're looking for.