The ShoreTel Server (Director) back-end is MySQL.
The reporting login is:
id: st_cdrreport
pwd: passwordcdrreport
database: CDR
schema: shorewarecdr
The default root login is:
id: root
pwd: shorewaredba
schema: shoreware
To access the MySQL server, you would also want to install the mySQL ODBC connector.
The text log files are in the folder:
c:\Shoreline Data\Call Records 2\
To dump the logs from the database:
1. Open a command prompt:
Start --> Run --> cmd
2. Navigate to the following directory on the server running ShoreTel:
<install drive>:\Program Files\Shoreline Communications\ShoreWare Server\MySQL\MySQL Server 5.0\bin\
3. Type in and run:
mysqldump.exe --add-drop-table --routines --user=root --password=shorewaredba --database shorewarecdr > C:\shorewarecdr_xxxx.sql
(where xxxx = today's date)
Notes:
Assumes you want to save the file to the root of the c: drive.
Update these parameters if the default passwords have been changed.
previous page
|