Create App for Qlik Sense User Data

[rittermd]

I would like to create an app that displays the user information out of the QMC.

Does something like this already exist?

If not, how do I access this data?  I assume it is in the repository somewhere?

v3.0

Thanks

[swuehl]

Have you had a look at the default monitoring apps?

Qlik Sense Platform - Qlik Management Console License and Operations Monitor - Part 4

[rittermd]

Not what I want there.  I want a combination of what is displayed when you click on the i along with values in the columns when looking at users.

[fkeuroglian]

Hi Mark

Do you try using the logs that the qmc generate when the user entry and use the app in the acces point?

https://www.youtube.com/watch?v=iMBDASFxA3M

[rittermd]

This link is for QlikView and I am using Qlik Sense.

I don't think that I want logs in this case.  I just want the static user information that is loaded into QS so that I can audit it more easily.

[Levi_Turner]

Here's a commented out portion of  a method that I have used before for accessing the underlying Qlik Sense Repository:

// // https://www.postgresql.org/ftp/odbc/versions/msi/ is the d/l URL for the PostgreSQL

// // ODBC Driver

// // This needs to be edited to reflect the actual data connection

// // that the customer is using which points to a System DSN on the server

// LIB CONNECT TO 'PostgreSQL30 (levi)';

// QUALIFY *;

// SET Errormode = 0;

// QSR_Tables:

// SQL SELECT

//     DISTINCT

//     table_name,

//     'public."' || table_name || '";' AS table_name_qualified

// FROM

//     information_schema."tables"

// WHERE

//     table_catalog = 'QSR'

//     AND table_schema = 'public'

//     AND table_type = 'BASE TABLE'

// ORDER BY

//     table_name,

//     'public."' || table_name || '";';

// LET nRows = NoOfRows ('QSR_Tables') - 1;

// FOR i = 0 TO $(nRows)

//     LET TableName = PEEK('QSR_Tables.table_name', i,'QSR_Tables');

//     LET TableNameQualified = PEEK('QSR_Tables.table_name_qualified', i,'QSR_Tables');

//     $(TableName):

//     SQL SELECT * FROM $(TableNameQualified);

//     // Uncomment the following line if you want QVD table export

//     //STORE $(TableName) INTO [lib://QVD Export (qtsel_wwi)/QSR__$(TableName).qvd](QVD);

//     // Drop resident tables (QVD export only)

//     //DROP TABLE $(TableName);

// NEXT

// SET Errormode = 1;

// DROP TABLE QSR_Tables;