Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Qlik Sense App: Parse Router Logs in Qlik Sense Cloud

MVP & Luminary
MVP & Luminary

Qlik Sense App: Parse Router Logs in Qlik Sense Cloud

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

Attachments
Version history
Revision #:
1 of 1
Last update:
‎03-19-2019 08:07 PM
Updated by: