Hi
Our scenario is to create a Incident Workflow matrix/SLA metrics on SPlunk Enterprise.
For that we have a Ticketing Tool called Help Desk Software from SolarWinds which we need to integrate to splunk Enterprise. The database is of mysql server and we need to pull out the records. Kindly assist.
How can we get the ticketing details( log messages) from the mysql database
Is there any add on for the Help Desk Software to pull out the data
I couldn't find any addon for Splunk ready-made for SolarWinds. But overall the key things you can try for is
The key thing you need to find from "solarwinds ticket tool" is the rising column (or time based column) which changes on every update of the ticket. Let's say that column to be my_ticket_rising_column
my_ticket_rising_column
. Create a new index and pull the data using dbconnect and look for the latest(my_ticket_rising_column)
in your searches.Can i make use of the Splunk DB Connect add-on in the Splunk ES trial version?
should be yes.
(Else request a developer license for 10GB from Splunk to try things out. This will give you full Splunk control)