topic QlikView Governance Dashboard 2.0.4 released! in Management & Governance

QlikView Governance Dashboard 2.0.4 released!

Tyler_Waterfall — Fri, 18 Aug 2017 17:57:22 GMT

Hello everyone -

QlikView Governance Dashboard 2.0.4 was just released and is available on the download site. Wahoo!

See: QlikView 12.10 Service Release 8 and QlikView Governance Dashboard 2.0.4 now available

It includes several bug fixes which should improve all of our lives.

Enjoy!

Tyler

Re: QlikView Governance Dashboard 2.0.4 released!

marcelviegas — Mon, 16 Oct 2017 15:23:32 GMT

Hi,
I can not find the link to do the governance 2.0.4 download, can anyone help me?

Re: QlikView Governance Dashboard 2.0.4 released!

Tyler_Waterfall — Mon, 16 Oct 2017 15:29:32 GMT

Log In to qlik.com and go to "download". Just be sure you log in first!

Re: QlikView Governance Dashboard 2.0.4 released!

marcelviegas — Mon, 16 Oct 2017 16:11:09 GMT

I logged in and even then I do not see the option to dowload the governance

Re: QlikView Governance Dashboard 2.0.4 released!

Tyler_Waterfall — Tue, 17 Oct 2017 11:24:40 GMT

Try Qlik Market instead: Qlik Market

Re: QlikView Governance Dashboard 2.0.4 released!

bvanderzanden — Mon, 06 Nov 2017 14:46:31 GMT

The file on Qlik Market is still 2.0.2

Re: QlikView Governance Dashboard 2.0.4 released!

Tyler_Waterfall — Mon, 06 Nov 2017 15:45:04 GMT

That's no good! Thanks for the heads up bvanderzanden‌.

We will be updating it with 2.0.5 soon.

Re: QlikView Governance Dashboard 2.0.4 released!

Anonymous — Tue, 07 Nov 2017 12:19:42 GMT

The governance dashboard is in Qlik.Com Downloads, hard to get to but its there, its called Governance Dashboard 2.0, and there is 2.04 in the version column. Just downloaded it! took a few moments to read the screen and digest!

Re: QlikView Governance Dashboard 2.0.4 released!

bvanderzanden — Tue, 07 Nov 2017 13:12:24 GMT

Thanks Liam.

I see it now. I think I was thrown off by the change to the naming convention and was expecting to see a file name 2.0.4. It looks like 2.0.5 was released today as well.

Re: QlikView Governance Dashboard 2.0.4 released!

rory_mchugh — Fri, 16 Feb 2018 14:57:40 GMT

Hi we did a penetration test on our QlikView Server, so I've now got a load of sessions and activity coming up in the Governance Dashboard that I would like to exclude. I have the user name of the account that did the testing. Can you advise how best to exclude this user's activity? I guess I could make selection or a bookmark, but I'd like to just exclude it from the data model entirely. Probably best to tinker with the load script but I'm not sure where to start...

Re: QlikView Governance Dashboard 2.0.4 released!

Tyler_Waterfall — Fri, 16 Feb 2018 15:02:36 GMT

Honestly, I would just remove the session and audit log files for the days when you did the penetration test. But that's a bit of a hack.

You can certainly go in the load script (it's no longer hidden) and just exclude data with something like

Where not ActiveUserId='user_name_for_testing'

The trick will be to make sure you have the correct form of user Id to match the field. For example

Doman\User

User

DOMAIN\User

etc.

Re: QlikView Governance Dashboard 2.0.4 released!

rory_mchugh — Fri, 16 Feb 2018 15:31:16 GMT

I'd quite like to keep the other users' activity, so I think I'll try to edit the load script. Which tables do you think I need to amend?

Re: QlikView Governance Dashboard 2.0.4 released!

Tyler_Waterfall — Mon, 23 Apr 2018 11:45:39 GMT

In the Sessions tab of script, add to the WHERE statement -- something like AND upper([Authenticated user]) <> 'TEST_DOMAIN\TESTER'

SUB Sessions (fname)
// Let tmp_node = $(fnode(Evaluate('$(fname)'))); // Node name from filename, as defined on variables tab of loadscript
Concatenate (Sessions)
Load
RecNo() as SessionsEntry,
'$(fname)' as SessionsFileName, // For incremental loading of Sessions
'$(fname)' & RecNo() as _SessionId, // For incremental loading of sessionheatmap

makedate(year([Session Start]),month([Session Start]),day([Session Start])) as SessionDate,
num(makedate(year([Session Start]),month([Session Start]),day([Session Start]))) as SessionDateNum,
1 as Session_Start_Count,
hour([Session Start]) as SessionHour,
[Cal Type] as Cal_Type,
if(len([Authenticated user])>0,lower([Authenticated user]),'Anonymous') as Authenticated_User,
Selections as SessionSelections,
Calls as SessionCalls,
[Bytes Sent] as Bytes_Sent,
[Bytes Received] as Bytes_Received,
[CPU spent (s)] as CPU_spent__s_,
[Session Duration] as Session_Duration,
$(SessionStart_field) as Session_Start,
$(Timestamp_field) as SessionTimestamp,
[Exe Version] as SessionExeVersion,
[Exe Type] as SessionExeType,
lower(replace(Document,'/','\')) as Sessions_FileName,
LOWER(SubField(replace(Document,'/','\'),'\',-1)) as DocName,
SubField(replace(Document,'/','\'),'\',-1) as DocName_Sessions,
$(DocumentTimestamp_field) as Document_Timestamp,
[Exit Reason] as Exit_Reason,
([Exit Reason]='Server shutting down')*-1 as [Session Lost to Server Restart],
[Client machine identification] as Client_machine_identification, 
[Serial number] as Serial_number, 
[Client Type] as Client_Type, 
[Secure Protocol] as Secure_Protocol, 
[Tunnel Protocol] as Tunnel_Protocol, 
[Server Port] as Server_Port, 
[Client Address] as Client_Address, 
[Client Port] as Client_Port,
'$(tmp_node)'&'|' & round(num($(Timestamp_field)),0.001) as Node_TS

FROM '$(fname)' (txt, utf8, embedded labels, delimiter is '\t', msq)
WHERE NOT EXISTS(_SessionId,'$(fname)' & RecNo())
<<ADD HERE>>
;

ENDSUB