|
In this topic: |
Master Login
Database statistics give you an idea of the number of recordings and the dates covered within a STORAGE database. The statistics themselves also give you a bird's eye view of activity on your network, showing program/Internet/network usage across broad periods of time. They can help you determine the nature of the data contained in a database before you archive or restore a backup.
You can get statistics on:
To view statistics on a database:
Select Management and the Databases folder.
In the right pane, select the STORAGE or DATA VAULT database you wish to view.
Select View Statistics on the toolbar, or right-click on the database and select View Statistics.
|
|
The DATA VAULT database statistics may show few or no records. When data stored here is processed and inserted into the STORAGE database, this database empties. It begins refilling as Clients pass additional data to it. The DATA VAULT database may be empty at the time you choose to view statistics. |
The statistics shown for all databases take the same format, and all views of the statistics show these fields:
Record Count: Total number of event recordings for each activity type. By default all views of the statistics show records ordered from largest Record Count to smallest.
Start Date: When this database started receiving these event recordings.
End Date: Last time the database received new data for each type of recording.
Status: Status of the database can be Online, the Dashboard can access the data, or Archived, the data has been archived and deleted from the accessible location.
Use the play buttons at the bottom of the window to navigate through Statistics records:
To change the statistics displayed:
Select an option at the top of the Database Statistics window. You can select one, several, or all options. The database contents are summarized in the Database Statistics window. By default, the Dashboard shows statistics by Event:
Across
Databases: When checked, this option shows statistics from all
available STORAGE and DATA VAULT databases. By default the option is cleared,
and you see statistics only from the database you selected. You can switch
between the Events/Users/Computers view of statistics with this option
selected. If Users is also selected,
you will not see the DATA VAULT database. For
example...
Events:
Lists event statistics from the database(s) showing Event type in the
first column, starting with the most active Event type (as shown in the
illustration above). If you also select Users or Computers, those fields
are added, and the window shows Program/Network/Web Site events for each
user or each computer. For
example... You can select all options for a single database. The User
field appears first, Computer second, Event Type third: 
Users:
Lists statistics by User name, starting with the user with the greatest
record count. Whenever you select Users in addition
to Events or Computers,
Users are listed in the first column. Selected alone, this option provides
a quick summary of each user's activity. For
example...
Computers:
Lists statistics by Computer name, starting with the computer with the
greatest record count. Selected alone, this option provides a quick summary
of activity on a computer. For
example...
|
|
The Statistics window always opens to its default view of Events only for the selected database. |
To sort statistics by a field
Click on a column heading in the Database Statistics window. The statistics are sorted by that field, greatest to least (down arrow next to field name). If you click on the same column heading again, the sort order is reversed to least to greatest.
You can also drag and drop the column headings to change the order of fields in the window.
For example, to get a detailed view of one user's activity from all recorded data, select all options at the top of the Statistics window. This gives you all databases, all events, all users, and all computers in the Statistics window. Click the User column heading to sort by user. You can then scroll or page to the user you wish to review.
To create a report from the statistics:
Click the Reports
button at the bottom of the Database Statistics box. More...
You can print and export the Statistics Report to a variety of data formats.
More...
Opening Database Statistics