Statistics enhancements.

Suggestions on Community Server Installation/Functionality
Post Reply
rudais
Posts: 25
Joined: Mon Oct 02, 2017 11:14 am

Statistics enhancements.

Post by rudais » Thu Oct 12, 2017 4:55 am

Hello,

Are there any plans on upgrading statistics for server? At the moment it only shows us Usage graphs with hits, which honestly does not tell us much as administrators.

Two more graphs would be needed I think:
* Logged in portal users
* Active document server sessions so that we may keep an eye on how much connections from our license limitations are active.

Second would be more to keep an track on if license upgrades are needed or will be needed in the future.

Maxim
Posts: 2016
Joined: Tue Oct 11, 2016 2:34 pm

Re: Statistics enhancements.

Post by Maxim » Tue Oct 17, 2017 5:40 am

Hello rudais!
Thank you for your feedback!
I have redirected your feedback to our developers.

dsi-lille
Posts: 202
Joined: Mon Jul 11, 2016 1:47 pm

Re: Statistics enhancements.

Post by dsi-lille » Tue Oct 17, 2017 7:49 am

Hello rudais,

here we use piwik (https://piwik.org/) to keep track of the users connected to the community server.
There is a js script (generate by piwik) to add on each community server page.
Just copy the script in /var/www/onlyoffice/WebStudio/js/third-party/
and add this line to web.appsettings.config :
<add key="web.custom-scripts" value="/js/third-party/piwik.js" />

About the Document Server, you can send statistic to a graphite server (https://graphiteapp.org/).
You can do that by modifying the config.js from the metrics modules (/var/www/onlyoffice/documentserver/server/Metrics/config/config.js)
Here an example :
{
port: 8125
, graphite: { legacyNamespace: false, globalPrefix: "escola" }
, graphiteHost: "your_graphite_server_host"
, graphitePort: 2003
, flushInterval: 60000
, backends: [ "./backends/graphite" ]
}

escola.gauges.ds.expireDoc.connections.edit : show the number of users editing a document on the document server
escola.gauges.ds.expireDoc.connections.view : show the number of users viewing a document on the document server

After that, if you want better graph, you can use Grafana (https://grafana.com/) with graphite (http://docs.grafana.org/features/datasources/graphite/).

the result :
graph.jpg
graph.jpg (53.09 KiB) Viewed 4428 times
hope this helps :)
Yoann.

rudais
Posts: 25
Joined: Mon Oct 02, 2017 11:14 am

Re: Statistics enhancements.

Post by rudais » Tue Oct 17, 2017 2:16 pm

@ Maxim

Thanks for follow up.

@ dsi-lille

Thank's for info. I will look into setting this up to monitor our server. :)

mmasquelin
Posts: 1
Joined: Tue May 25, 2021 6:34 pm

Re: Statistics enhancements.

Post by mmasquelin » Wed May 26, 2021 3:46 pm

Hi @dsi-lille,

I am attempting to get those statistics from documentserver (OnlyOffice Workspace Enterprise instance). I am trying to export all metrics to an influxdb server (graphite backend is enabled). Some of these metrics are sent successfully.

root@influxdb:~# influx
Connected to http://localhost:8086 version 1.7.7
InfluxDB shell version: 1.7.7
> use oow
Using database oow
> show measurements
name: measurements
name
----
Content-Length:
Dnt:
X-Grafana-Org-Id:
X-Panel-Id:
isc.counters.statsd.bad_lines_seen.count
isc.counters.statsd.bad_lines_seen.rate
isc.counters.statsd.metrics_received.count
isc.counters.statsd.metrics_received.rate
isc.counters.statsd.packets_received.count
isc.counters.statsd.packets_received.rate
isc.gauges.statsd.timestamp_lag
isc.statsd.graphiteStats.calculationtime
isc.statsd.graphiteStats.flush_length
isc.statsd.graphiteStats.flush_time
isc.statsd.graphiteStats.last_exception
isc.statsd.graphiteStats.last_flush
isc.statsd.numStats
isc.statsd.processing_time

How did you manage to get gauges data from documentserver ?

root@oow:~# echo "gauges" | nc 127.0.0.1 8126
{ 'statsd.timestamp_lag': 0 }
END

Thanks for your advices,
Mickael
dsi-lille wrote:
Tue Oct 17, 2017 7:49 am

escola.gauges.ds.expireDoc.connections.edit : show the number of users editing a document on the document server
escola.gauges.ds.expireDoc.connections.view : show the number of users viewing a document on the document server

After that, if you want better graph, you can use Grafana (https://grafana.com/) with graphite (http://docs.grafana.org/features/datasources/graphite/).

hope this helps :)
Yoann.

Carl
Posts: 652
Joined: Thu Apr 12, 2018 10:00 am

Re: Statistics enhancements.

Post by Carl » Wed Jun 02, 2021 2:13 pm

Hello Mickael,

I see in our Helpdesk that you've figured out how to solve this issue.

Post Reply