Task details do not match Logs

Mon, 26 May 2014 04:57:33 GMT

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

Re: Task details do not match Logs

ashfaq_haseeb — Mon, 26 May 2014 05:43:07 GMT

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

Re: Task details do not match Logs

Mon, 26 May 2014 07:05:11 GMT

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?

Re: Task details do not match Logs

ashfaq_haseeb — Mon, 26 May 2014 07:09:31 GMT

Hi,

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

It covers lot of things.

Regards

ASHFAQ

topic Re: Task details do not match Logs in QlikView

Task details do not match Logs

Re: Task details do not match Logs

Re: Task details do not match Logs

Re: Task details do not match Logs