Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Task details do not match Logs

Hello all,

I'm fairly new to QlikView, and I'm now faced with a challenge of creating of report that needs to show details about reports that are on Access Point.

In Qlikview Managment Console, when I look in the task details i see a valid number of user that can access the report,

but when I make an application it shows a different information about number of user.

Here is the code,

any help will be appreciated

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD.MM.YYYY';

SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

// Start of [Task_0a2f3b46-e956-4d92-bc5c-fe305923c400.xml] LOAD statements

AddRecipient:

LOAD

    filebasename() as %KeyTask,

ObjectType,

    ID as UserApp

    //%Key_DistributeTask_3BD6A6DF582C1659    // Key to parent table: DistributeTask

FROM [\\10.145.73.78\Qlikview\QlikView_Server_QV_Server\REPO\Tasks\*.xml] (XmlSimple, Table is [DistributeTask/Resources/Resource/AddRecipient]);

DistributeTask:

LOAD

    filebasename() as %KeyTask,

    Name,

    Enabled,

    [AbendTriggers/RunTimeTrigger/MaximumMinutes] as MaximumMinutes,

    [Resources/Resource/AddRecipient/ID] as [AddRecipient/ID],

    [SourceDocument/FileName] as FileName,

    [TaskCategories/TaskCategory/Name] as [TaskCategory/Name],

    [StartTriggers/ScheduleTrigger/RepeatEvery] as RepeatEvery,

    [StartTriggers/ScheduleTrigger/HourStart] as HourStart

  

FROM [\\10.145.73.78\Qlikview\QlikView_Server_QV_Server\REPO\Tasks\*.xml] (XmlSimple, Table is [DistributeTask]);

// End of [Task_0a2f3b46-e956-4d92-bc5c-fe305923c400.xml] LOAD statements

3 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

That is because QlikView store UTC time.

In order to proper utilize QlikView logs and generate a report like who accesses application and all.

why don't you try the below ready made application.

http://community.qlik.com/docs/DOC-4307

Regards

ASHFAQ

Not applicable
Author

Hello Mohammed,

this is not exactly what I was looking for. I need correct data from logs, but the data is not actual.

That is the problem.

Thank you for input, but do you have idea what should I do?

ashfaq_haseeb
Champion III
Champion III

Hi,

Did you look at the link to application in my post?

It covers lot of things.

Regards

ASHFAQ