topic Re: personalized / customized : Monitoring apps in Management & Governance

personalized / customized : Monitoring apps

cocuzzan — Mon, 17 Sep 2018 13:50:30 GMT

Hi I need to create apps that monitor access to Qlik.
Practically the default monitoring app is good, but I need to create a different one with the same data.

the first question is:
1) How do I recover or use the same Monitoring Apps data?

2) the second question is:
can I copy the monitoring apps and make changes in the data upload so that they do not conflict with saving QVDs?

Re: personalized / customized : Monitoring apps

Clever_Anjos — Mon, 17 Sep 2018 13:57:19 GMT

You can create a sheet into that app and create your customized dashboard OR
You can duplicate the app ( in this case, you should after modifying the app change the owner to sa_repository) so it can be reloaded

Re: personalized / customized : Monitoring apps

cocuzzan — Mon, 17 Sep 2018 14:05:41 GMT

ideas are generally good. But how to implement them?

Assuming that you follow the second option, which initialization variable should I modify for example in the "Lincense Monitor" app?

thank to your respond

follow code standard section : "Initialize" from "License Monitor"

// License Monitor

REM To manually override where this app loads log data, please update the variable db_v_file_override as follows:

0 = auto = script will check for recent data in logging database

1 = file logs only (no database logs loaded)

2 = database logs only (no file data loaded except where file log data already stored in governanceLogContent QVDs;;

SET db_v_file_override = 0;

REM END set manual override for log data source (Only update the script beyond here at your own risk!);

Let ReloadStartTime = now(1);

SET app_version = '7.7.0';

Let comp = ComputerName();

LET ProdVer = PurgeChar(ProductVersion(),chr(39));

LET startMsg = 'Reloading License Monitor $(app_version) from $(comp) running version $(ProdVer)';

TRACE $(startMsg);

SET monthsOfHistory = 100; // How many months of history should be available in the app. More history = more processing, bigger app, etc.

LET cutoffDate = AddMonths(today(),-$(monthsOfHistory),1); // Filter individual .log files and baseTable; note: the 1

Let LastReloadTime = timestamp(if(isnull(LastSuccessfulReloadStartTime),cutoffDate,LastSuccessfulReloadStartTime));

Let lastReloadCompare = num(LastReloadTime)-1; // (Re-)load any logs updated within 24 hours of the last reload

SET minSenseActivityDate = 42005; // Jan 1, 2015 - cutoff for all Sense-related activity

SET hideprefix = 'log'; // Hiding logList from view, though preserving it for now (not dropping it)

SET firstReload = 0; // RESET this each time -- it will check.

SET va_LoginToUserPass = 10;

LET serverLogFolder = 'lib://ServerLogFolder/';

LET archivedLogsFolder = 'lib://ArchivedLogsFolder/';

SET central_node_name = ; // Multinode intialize

LET baseFileName = 'governanceLicenseLog_$(app_version)';

LET baseTableName = '$(serverLogFolder)$(baseFileName)';

LET SessionFileName = 'governanceSession_$(app_version)';

LET sessionTableName = '$(serverLogFolder)$(SessionFileName)';

LET monitorAppStatsFile = '$(serverLogFolder)License_Monitor_Reload_Stats_$(app_version).txt';

SET storeBaseTableFail = 0; // If script fails to store base table, set to 1 and do not update LastSuccessfulReloadStartTime variable

LET tempErrorDetails = ;

// Set date and time formats

SET TimeFormat = 'hh:mm:ss';

SET DateFormat = 'YYYY-MM-DD';

SET TimestampFormat = 'YYYY-MM-DD hh:mm:ss';

// Calendar Variables

Let vLast4Hours = Num(timestamp(Now(1)-1/6)); /// 4 hours = 1 day / 24 hours (per day) * 4 hours = 1/6 Days

Let vLast24Hours = Num(timestamp(Now(1)-1));

Let vLast72Hours = Num(timestamp(Now(1)-3));

// Colors

set c_red = 'RGB(204,102,119)';

set c_yellow = 'RGB(221,204,119)';

set c_blue = 'RGB(68,119,170)';

set c_green = 'RGB(17,119,51)';

set c_gray = 'RGB(150,150,150)';

set c_lightred = 'RGB(240,209,214)';

set c_lightblue = 'RGB(188,181,201)';

Re: personalized / customized : Monitoring apps

rwunderlich — Mon, 17 Sep 2018 16:19:13 GMT

Another option is to BINARY load the existing monitoring app and reuse it's data.

-Rob

Re: personalized / customized : Monitoring apps

Anders_Eriksson — Tue, 18 Sep 2018 07:28:45 GMT

How do you binary load on Sense server?
I thought binary load in Sense was only possible when you have a QVF?

Re: personalized / customized : Monitoring apps

rwunderlich — Wed, 19 Sep 2018 21:26:55 GMT

I'm told it's possible but haven't tried it myself

-Rob

Re: personalized / customized : Monitoring apps

Anders_Eriksson — Thu, 20 Sep 2018 09:49:48 GMT

I looked in the help-file for it the other day and there is stated it only works from qvf-files not applikations deployed on the Sense server.

Re: personalized / customized : Monitoring apps

rwunderlich — Thu, 20 Sep 2018 14:11:19 GMT

I followed the instructions here

Binary load from qvf file in Qlik Sense

It works, but as you pointed out, this is not a supported technique so I withdraw my suggestion to use this as a solution for this poster's requirement.

-Rob

Re: personalized / customized : Monitoring apps

eike_s — Thu, 20 Sep 2018 14:12:19 GMT

All Apps are stored in your shared folder like this:

QlikShare\Apps\APPID.qvf

so you can create a data connection to that folder and perform a binary load. I have tried it a long time ago, but it should still work. Not sure if it has any effects on your environment.

Re: personalized / customized : Monitoring apps

Anders_Eriksson — Thu, 20 Sep 2018 14:48:15 GMT

Had a thought about trying that as I guessed those files are actually QVF-files even though they don't have the extension.
Do it at your own risk would be the conclusion.