3 usage graphs, 4 sql database structure, 1 table columns – FaxBack NET SatisFAXtion 8.7 (Including R3) - Manual User Manual
Page 96

2 – Server Administration
NET SatisFAXtion 8.7 Manual
96
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 peri-
od 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 pos-
sible 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
port 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].
[Time_Date_Stamp] [datetime]
When this record was added to the logs database.
[Message_Type] [int]
What type of fax it is:
0: Send
4: Receive
[Receiver_Address] [varchar](100)
The dial string on an outbound fax, or the receiver’s email address on an in-
bound fax.
[Receiver_Name] [varchar](100)