Vikram Lall
Hello.
I have a question. We want to obtain xMatters event information to feed into another system for reporting purposes.
I am aware of the GUI option (Reports / Recent or All Events) which can be exported to a CSV.
I wanted to see what other options were available for us to obtain this event information automatically.
A database connection with a SQL command would be ideal for us to connect and obtain on a nightly schedule, but as that doesn't seem to be available, can you please give me some advice on a simple way to achieve this? Perhaps some sort of workflow action can be used to save down a csv file nightly?
Many thanks in advance for your help!
0
Comments
Please sign in to leave a comment.
Hey VL,
There are a couple of options here. The first is to build a process and extract the needed events via the REST API. Most ETL tools have a way to pull from an API and then write to a csv file. Another option is to use the same concepts outlined in these steps that write individual events to Splunk. This would be on per canvas basis though and would need to be added to each flow that generates an event.
Actually, I also remembered the xmtoolbox, which is a nodejs package. This has a getMany events method that takes some parameters and makes the API call. You can pass these values to another node module, csv, for example that would write the data into a csv. Or maybe wherever you need it to finally rest.
I'll ask around and see if anyone else has implemented something that might help.
Happy Sunday!