NetXMS Support Forum

Hello
Just tried out NetXMS and after some initial doubts I now love it.
There is however 1 thing that I would need and that I didn't understand if it's possible to do or not:

is it possible to export in some way the contents of the dashboard to e.g. an html-file?
Or to export one or more graphs I see in the dashboard to a png/gif/whatever file?

I don't want to have to write a report in jasperXML and failed so far to find any alternative. Found some posts like this one https://www.netxms.org/forum/configuration/report-generating/msg3975/#msg3975 but they seem all to be quite old and was wondering if any new functionality has been added in the meanwhile which I missed in the user manual.

Reason: would be less risky in a secured corporate environment to serve static content through a normal webserver instead of having to rely on the security of the NetXMS product.

Thanks a lot!

Hi!

If I understand correctly you need some kind of automated tool to export dashboard content periodically. Currently it is not possible. Theoretically this can be done, especially if limit set of exportable elements to only charts and labels. I'll think how hard it would be.

Best regards,
Victor

Yes, something like that might be useful - thanks a lot   

And btw., last Friday we had a look at the contents of the database (we did the test installation just using sqlite3) but haven't been able to find the table that contains the values that can be seen when checking the historical data of the DCIs. We did this because the were thinking about creating some custom scripts that would extract the data from the DB and then create our own graphs.
We did find a table that seems to contain only the last values but we could not find the historical values... .
Did we oversee the table or is such data stored somewhere else?

Quote from: blah on December 16, 2012, 11:07:57 PM
Yes, something like that might be useful - thanks a lot   

And btw., last Friday we had a look at the contents of the database (we did the test installation just using sqlite3) but haven't been able to find the table that contains the values that can be seen when checking the historical data of the DCIs. We did this because the were thinking about creating some custom scripts that would extract the data from the DB and then create our own graphs.
We did find a table that seems to contain only the last values but we could not find the historical values... .
Did we oversee the table or is such data stored somewhere else?

idata
tdata

tables

Collected DCI data stored in multiple tables - one table per node. These tables are called idata_nodeid, for example, idata_100.

You can also use Java API to access collected data from external application.

Best regards,
Victor

Thanks a lot!
We'll dig into this.

Hi!

FYI 1:
we're preparing some kind of pilot installation for the company I'm working for.
After an initial evaluation phase we decided within the team to propose NetXMS as the data/metric gathering & evaluation engine.
If it is accepted or not, will depend on our domain architects.

FYI 2:
To present the data to the user in the form of graphs or status indicators we decided not to use NetXMS' Dashboard but to write a custom PHP frontend (which might use multiple PHP and js graph engines which would be selectable by the user through parameters on the custom PHP webpage, depending on how the user would want to see the output - we initially thought about using "Graphite", which worked very well privately, but it's just too hard to install its dependencies in a strictly controlled enterprise environment).

Theoretically the configuration about how the graphs are presented on the webpage(s) (which graphs show up on which webpage, which statistics are shown in the same graph, etc...) would be done by specifying options in a long hierarchy-like text-string in the "Description" field of the NetXMS Data Collector (which, if I'm right, can be 256 chars long).


We're currently working on the second part (10% progress until now - just able to display a single graph for a single metric on a single page), and it will take a while until we're able to generate something more complex
The current priority of the DB-backends SQLs is towards Oracle and SQLite, where Oracle will get the highest priority.

I'll post here some updates if anything crucial happens and especially to ask you what you think about the result if we manage to put together something usable.


So please, don't do any crazy changes to the base concepts & DB-layout, otherwise I'll have to rewrite all the SQLs and rethink about the whole approach! 
Cheers

Hi!

Would be interesting to see the results. There are no plans for dramatic changes in DB schema, so you are safe here

Best regards,
Victor

Hi Victor

It took a long time but in the end we decided to do it.
I posted a preview https://www.netxms.org/forum/feature-requests/netxms-quick-graphs-and-info-useful-how-to-name/.
Do you think it's useful?

Thank you