Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you had a look at the default monitoring apps?
Qlik Sense Platform - Qlik Management Console License and Operations Monitor - Part 4
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.
Hi Mark
Do you try using the logs that the qmc generate when the user entry and use the app in the acces point?
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.
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;