Skip to main content

Qlik Sense App: Parse Router Logs in Qlik Sense Cloud

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Qlik Sense App: Parse Router Logs in Qlik Sense Cloud

Last Update:

Mar 19, 2019 8:07:54 PM

Updated By:

stevedark

Created date:

Mar 19, 2019 8:07:54 PM

Attachments

This app was created to accompany a tutorial blog post which shows how you can pick up content from emails, using the IMAP connector, and parse this into an app. It was also created as I had a requirement to get information out of the logs on my Netgear R7000P router.

The solution is fully automated, with the router sending logs to an email account on a schedule and Sense then picking those logs up each day.

Here is the link to the blog post with all the instructions on building this solution from scratch:

https://www.quickintelligence.co.uk/netgear-router-logs-qlik-sense/

The app takes unstructured log data and splits it into a table with multiple columns, making selections easier, and a sheet to visualise what is happening on your network - helping you stay secure.

Count of Rows.png

Note that the app does not have any data or connections embedded in it. You will need to follow the instructions in the blog post to get the connection working and to be able to load data.

This is just one of the tutorial apps we have uploaded, you can find others here:

https://www.quickintelligence.co.uk/examples/

If you have any suggestions or comments please use the comments section, either here or on the blog itself. I would be particularly interested in knowing any other router models that this works with.

Qlik Netgear R7000P Mail.jpg

 

 

 

 

 

Many thanks,

Steve

Version history
Last update:
‎2019-03-19 08:07 PM
Updated by: