Tactical Software Tech Note

 


All Tech Notes

Creating Queries and Reports with the TacServe Log Database

The TacServe Log Database of Call and Event Records

The TacServe MMC user interface includes views of information in the Call and Event logs.  These logs are in a database at the default location:

      C:\Documents and Settings\All Users\Application Data\TacServe\tacserve.mdb

As a database accessible with ODBC, the TacServe log database can also be viewed, analyzed and reported by various third-party programs.

Event and Call Log columns

Columns in the Event Log:

  EventTime The date and time in YYYY-MM-DD HH:MM:SS format of when each event took place
  ClientAddress The IP address of the client that was responsible for the event.  This will be blank for internal events such as notices for the stop and start of the TacServe service.
  PortGroup The TacServe Port group that was accessed for the call (is blank for internal events)
  ComPort The COM port that was used on the TacServer machine (is blank for internal events)
  Event The type of event that occurred such as OPEN, CLOSE, DIAL (is blank for internal events)
  User The username that used the COM port. This will be blank for internal events or if user authorization is not used
  Duration The time that the COM port was in use (is blank for internal events)
  PhoneNumber The phone number that was dialed (is blank if a phone number is not dialed)
  Comment Detail for an internal event or error condition, blank otherwise


Columns in the Call Log:

  Begin Date/time that the call was initiated
  BytesRecieved The amount of bytes that were received from the TacServe modem during the call
  BytesSent The amount of bytes that were sent to the TacServe modem during the call
  ClientAddress The IP address of the client that made the call
  ComPort The COM port that was used on the TacServe machine
  Duration The time that the COM port was in use
  PhoneNumber The phone number that was dialed
  PortGroup The TacServe Port Group that was accessed for the call
  ServerAddress The IP address of the TacServe machine
  Status Shows if the call was successful or not
  Type DATA or FAX depending on call type
  User The username that used the COM port (is blank if user authorization is not used)