Automation through SPLUNK

[abhayneilam]

H,

I prepare Information Security Metrics every week , where I take data from database, website links and excels, etc and do it manually and make the report.

I want to automate this through SPLUNK, Can you please let me know how to get the data inputted in SPLUNK from database, website links, excel , so that I would start with the automation part.

Please help , If you want me to open seperate question for separate source input, I would do that, but please help me in this regards, as I have heard that splunk can take input from any source

[jtworzydlo]

Hi,
I would be great if you could give some more details.
To get data from database you would probably need splunk DB Connect app. What info do you need from websites? execl file can also be an input for splunk just like any other log file (for that you need splunk forwarder).
After you will have all the data you need I would recommend to make a dashboard and schedule generating it as a pdf to get reports.
More details would be nice 🙂

[jtworzydlo]

take a look at:
http://docs.splunk.com/Documentation/Splunk/5.0.2/Data/WhatSplunkcanmonitor
http://docs.splunk.com/Documentation/Splunk/5.0.2/Data/Setupcustominputs
http://docs.splunk.com/Documentation/Splunk/5.0.2/Tutorial/Aboutgettingdatain

[abhayneilam]

Thanks for your prompt response .for excel file I convert it to .csv file and use inputlookup command, through forwarder can it be done directly through excel file itself ? Regarding website I have a link whichupon clicking get me another two link if I click the first one I get some data in a tabular format that data I want to fetch through splunk