How to export Alarms and Event log from NetXms tool to Excel.
-
I am new to NetXms tool. I have configured Netxms Version 0.2.22 for monitoring the CPU load memory and other parameters of the devices. And also I have set the threshold and appropriate rules in the event policy. Now am able to see the alarms in the alarm vewer.
Now i would like to export the events and alrms to an excel file for a trend analyziz and other reports. How can i acheve this. Am using the SQL LITE Embeded database as the storage.
Please guide me how to go forward.
Thanks in Advance,
Rejith -
Hi!
You can export active alarms into comma-separated file using nxalarm tool. For terminated alarms and events the only way to export is to query database directly. Alarms stored in table alarms, and events in table event_log. Ask if you'll need comments on structure of these tables.
Best regards,
Victor -
Hi Thanks for this reply.
I am using SQLite Database Browser for exporting the data from the netxms tool database.
-
You could use File -> Export -> Table as CSV file to export both tables and then load CSV files into Excel.
-
-
He probably mean menu in SQLite Database Browser, not in NetXMS console.
Best regards,
Victor
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login