Anybody familiar with the Shoretel database?

Question

I have a copy of the local db from our old shoretel voip system... which is no longer in service. I've been tasked with trying to locate information pertaining to calls to and from specific numbers over the past year or so.

Wondering if anybody is familiar with the schema of this database and which tables I might be able to query to find call info. I had done some investigation and read that there should be a "calls" table, but there is not. None of the tables are named in such a way that it sounds like the correct table for call transactions.

Any info is helpful, thank you

You may find this google.com search helpful. shorewarecdr tutorial — Wilson Hauck, Apr 09 '23 at 00:29

score 2 · Accepted Answer · answered Apr 06 '23 at 18:41

2

The database you search for is named shorewarecdr (from CDR - Call Detail Record). It should have tables call, connect and few other. Check there.

answered Apr 06 '23 at 18:41

Romeo Ninov

5,263
4
20
26

1

Thanks, after some more research I was able to determine that the shoreware cdr database is served from port 4309- I was looking in the shoretel configuration database which is on port 4308. – boog Apr 12 '23 at 14:06

Anybody familiar with the Shoretel database?

1 Answers1