No announcement yet.
  • Filter
  • Time
  • Show
Clear All
new posts

  • User Activity Details Report - Command table?

    I am working on customizing the User Activity Details report for my work. When I open the report in crystal reports I notice that the only table that is linked to the report is called Command. I am unable to locate that table in the shorewarecdr database. It looks like the command table in the report is just a combination of fields in the Call and Connect table. Does anyone know any more details about this? Thanks!

  • #2
    It is a call to a massive stored procedure named "sp_userActivityDetail". You can find this procedure in the file "MakeCDR_sp.sql" on the ShoreTel Server.

    We've redeveloped many of ShoreTel's reports as single SQL queries which not only easier to understand, but also run faster. We have a web-based reporting portal or we can license the query to you for use in any reporting environment. If you're interested in this route, please PM me.