Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to extract only needed information from log file

Hi

How to extract only needed information from log file..?

Say I want username,timestamp and which file/report user had download.

Br

Avantika

6 Replies
erich_shiino
Honored Contributor

How to extract only needed information from log file

Hi,

The application in the following link reads qlikview server log.

http://community.qlik.com/qlikviews/1029

You can adjust it to get only the fields that you need.

Regards,

Erich

Not applicable

How to extract only needed information from log file

Hi Erich

I want to design my own script. Is there any way to design ? I am new to this QlikView

erich_shiino
Honored Contributor

How to extract only needed information from log file

You can read the logs with your own script.

You can start from scratch or use the qv server performance as a reference.

If you open the script on that qvw you can check with files are accessed and their content.

To open the script you can use Ctrl+E or menu file -> Edit Script

Hope this helps,

Erich

Not applicable

How to extract only needed information from log file

Hi Erich

sorry but I am not getting your point

Could you plz explain in more detail ?

erich_shiino
Honored Contributor

How to extract only needed information from log file

I saw your other post. Maybe I misunderstood you.

Are you reading QlikView Server logs? or other type of log? If it is a different type, please post a small sample and we can help you write a script to read it.

Not applicable

How to extract only needed information from log file

c:\programdata\qliktech\webserver\log\20100729.txt:7/29/201o 09:10:18.5297053 Information Request received [GET]: http://SERVER_NAME/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@Server_NAME|DEMO/DOC_Name.qvw&client=Down...

c:\programdata\qliktech\webserver\log\20100729.txt-7/29/2010 09:10:18.5297053 Information <Global method="GetTicket"><UserId>USER_NAME</UserId><GroupList><string>xxxx..yyyy3</string><string>xxxx..yyyy</string><string>xxxx..yyyy</string><string>xxxx..yyyy</string><string>xxx..yyy</string></GroupList><GroupListIsNames>false</GroupListIsNames></Global>

c:\programdata\qliktech\webserver\log\20100729.txt-7/29/2010 09:10:18.5765068 Information <Global><_retval_>HFGGFKFG2</_retval_></Global>

c:\programdata\qliktech\webserver\log\20100729.txt-7/29/2010 09:10:18.5765068 Information <Global method="FileDownload"><Path>DEMO/DOC_Name.qvw</Path></Global>

THIS IS THE ONE OF THE KIND OF LOG. FROM this, I want  timestamp,username and report name, i.e. downloaded.

I have installed GREP FOR WINDOWS.

Community Browser