2 basic reporting, 3 usage graphs, 4 sql database structure – FaxBack NET SatisFAXtion 8.6 - Manual User Manual

Page 89: 1 table columns

Advertising
background image

2 – Server Administration

NET SatisFAXtion 8.6 Manual

89

2.7.2

Basic Reporting

There are five built-in reports that will return information about the faxes that
went through the fax server during the specified time period. Click the Date
Range
drop-down to change the time period reported.

Simple: Lists all faxes sent and received, but only displays basic information
about them.

Everything: Lists all faxes sent and received, and all information about them.

Sent Faxes: Lists all information about faxes sent.

Received: Lists all information about faxes received.

Errors: Lists all sent and received faxes that failed.

The table can be sorted by clicking on the column header. Drag a column
header to the gray bar at the top of the table to group the results by that
column’s value.

Double-click a row to see all details of that fax.

2.7.3

Usage Graphs

There are four built-in usage graphs that will display usage levels during the
specified time period. Click the Date Range drop-down to change the time
period reported.

Each bar in the graph will represent the next smaller unit of time. There will be
two bars per unit of time: one for sent faxes, the other for received.

Fax Traffic: Graphs number of faxes sent and received.

Fax Page Traffic: Graphs number of pages sent and received.

Fax Connection Time: Graphs call duration for sent and received calls.

Port Utilization: Graphs maximum port usage during each time period. This is
useful for capacity planning. If the server ever uses all available ports, it is
possible for inbound callers to get busy signals.

2.7.4

SQL Database Structure

For advanced reporting, it is possible to use a third-party report generation tool
to query the SQL database directly. Note that by default, Microsoft SQL Server
2005 Express does not allow network connections. Please consult the

Microsoft

SQL Server 2005 Express

documentation and your third-party report generation

tool documentation for more details.

SQL Instance Name:

ServerName\NETSATISFAXTION

Database Name:

NET_SatisFAXtion_Logs

Table Name:

FAX

sa Password:

IW@-2ej*M(Ic#^c@

2.7.4.1

Table Columns

[Event_ID] [varchar](50)

A unique identifier, created based on [Time_Date_Stamp].

Advertising