Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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