QlikView User Audit Dashboard

[jbeierschmitt]

I need to perform an audit of our QlikView user base and would like to develop an application to provide this in a daily report.

We currently utilize QlikView Publisher Enterprise 8.5 via AccessPoint to distribute QlikView documents to specific Active Directory Groups. I would like to build the application to tell me which Active Directory Group(s) are valid per published document as well as query AD to tell me who are the current users assigned to each group.

I'm uncertain if there is a way to query QlikView Publisher Enterprise to tell me which AD Groups are recipients for each document? Anyomne have any experience developing a similar application?

Jim

[#2]

Brad, let us know when you've got the SR3 Ops Monitor ready to go.

Cheers.

[#3]

Hello,

Does anyone know if the QVPR database stores user's email address?

I could find the NT acct name, but unfortunetely, it's just initial and hard to tell names.

Any suggestion?

Hi Brad,

Do you think it's possible for you to make a screen shot for us of the new Audit dashboard?

Thanks.

[Brad_Peterman]

Here is a screenshot of new v9 Ops Monitor application. This is being tested for v9 SR3 compatibility right now and will be put out there on QlikCommunity soon.

[#5]

Thanks Brad! Looks good.

[#6]

Hi Guys,

If you are still working on this. I have some info to share.

There's a site by Rob Wunderlich, download the cookbook, and go to the ADextract folder.

http://robwunderlich.com/Download.html

The script allow you to see name from the AD directory, but you can add the following to get more, then you can import data you need from QVPR.

SQL select
distinguishedName,
cn,
displayName,
givenName,
sn,
mail,
userAccountControl,
name,
c,
company,
department,
telephoneNumber

[jbeierschmitt]

Trying to utilize the Qperations Monitor to support our requirement to identify which AD Groups/email users have authorization to access the various QlikView documents on our AccessPoint.

Think I understand how to put together the xml pieces through the Operations Monitor and the other posts, however....

Hit a dead end when trying to load the DistributionReport.xml into QlikView - error states "Switch from current encoding to specified encoding not supported. On line number: 1. On column number: 40"

C:\ProgramData\QlikTech\Publisher\Qlikview Distribution Service\1\Log\20100224\190847 - IT_QV_008_UserDocument1

xml header: <?xml version="1.0" encoding="utf-16"?>

It appears that QlikView Desktop is not able to load this as xml? The data that I need is the document name in AccessPoint as well as the recipients - both called out in the DistributionReport.xml document

We are on Windows Server 2008 64-bit, QlikView 9.00.7436.8 (x64)

Thansk in advance for your help!

[Brad_Peterman]

Jim,

This definitely looks like it was written using a different coding format. If you are still having an issue with this please send me a copy of your DistributionReport.xml file and I will see if I can get it to read into QV correctly.

http://www.w3schools.com/XML/xml_encoding.asp

Thanks,

brad.peterman@qlik.com

[#9]

Hello all,

Finally, there's a way to really see "who has access to which QVWs".

With the help of this vbscript.

It read the DACL of QVW document, extract them into txt with this format >> QVWName | LOGON

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

WIth this file, you can easily integrate into V9/V10 Ops Monitor dashboard and link it with Sessions table.

[bonarasido]

Hi nicksatch do i need specific permission to view this document? i try to view but can't

[#11]

Hi Bonar

In fact, i lost all my published doc, i don't know why, i sent a message to the community manager Jason Long, he didn't reply, and i don't know who else to contact.

If you want to see the doc, you can give me your email address, i'll send a copy to you. it's a simple vbscript.

-Nick