Active services at certain month

[Rodrigo]

Hi,

Currently i'm working with Holistics.io, where I connect it to Blesta DB via remote mysql and it shows me a full B.I dashboard with awesome statistics and charts. I would like to know if Blesta model does support a query to be able to retrieve how many services where active at a certain date.

We can't rely on Canceled or Suspended dates of 'services' table as the former can occur much later after the service was suspended, and the latter disappears when a service is unsuspended.

I'm thinking about writing a small script that logs this value every day to a database in order to be able to have this value from now on, but I would like to know if I have been missing a table that might have this information (directly or via an specific query).

Thanks!

Rodrigo

[Paul]

Unfortunately there is not a log of all service status changes, so producing your own log as you suggested would be the way to go. It would be good to maintain this history within Blesta, so a feature request would be welcome.