Hi to all ,
I need to find "Removed Externally" flag from QMC on the Licence Monitor app
Can you provide me with the right name for this field on the Qlik repository side ?
I tried to search for it here : (RemovedExternally is my gues and it's wrong )
SUB monitor_apps_REST_user
LIB CONNECT TO 'monitor_apps_REST_user_condensed';
User:
Load
LOWER(userDirectory & '\' & userId) AS UserId,
[name] AS [User Name],
"RemovedExternally" as Removed_Externally,
userDirectory as [User Directory]
;
SQL SELECT
"userId",
"RemovedExternally",
"userDirectory",
"name"
FROM JSON (wrap on) "root";
ENDSUB