topic How to set up Log Analysis Qlikview in QlikView

How to set up Log Analysis Qlikview

Mon, 11 Feb 2013 10:40:22 GMT

Looking at the below Qliktech supplied document, this looks like a really great tool to have.

http://us.demo.qlik.com/detail.aspx?appName=Log%20Analysis.qvw

However when it comes to setting up the report I'm at a bit of a loss, can anyone point me to a step by step guide on what to change and what needs to be in place?

Thanks in advance

Re: How to set up Log Analysis Qlikview

alexandros17 — Mon, 11 Feb 2013 10:52:34 GMT

Try

Settings -> document properties -> general -> generate logfile checkbox on the upper left

When you reload the document it generates Log

Hope it helps

Re: How to set up Log Analysis Qlikview

Mon, 11 Feb 2013 11:04:05 GMT

Hi,

Afraid the name of the report is a misnomer, this is related to system logs on multiple servers....

Regards,

Re: How to set up Log Analysis Qlikview

Tue, 12 Feb 2013 19:51:36 GMT

Hey Chris,

are you trying to use that qvw? or are you looking for something else?

That QVW will read Event logs that have been exported to a specific directory on several different servers. or are you trying to accomplish something different?

-Ralph

Re: How to set up Log Analysis Qlikview

Tue, 12 Feb 2013 20:01:37 GMT

Hi Ralph,

Yes I am trying to use the Qlikview report and reading your response has made something twig...

Do I need to set up my servers to write their event logs to the same location on each server?

Re: How to set up Log Analysis Qlikview

Tue, 12 Feb 2013 20:03:46 GMT

Bingo. The UNC path to the logs is autogenerated, so yes, the logs will need to be exported to the same directory on each server. Off the top of my head, I imagine you could write a powershell script to export them and then put that in the scheduled tasks OR, if you like powershell, run a powershell script on reload of the Qlikview file that tells each server to do the export.

Re: How to set up Log Analysis Qlikview

Tue, 12 Feb 2013 20:17:06 GMT

Lovely stuff, thanks for the help!

Now time to learn some PowerShell...