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
// Copyright 1993-2017 Qliktech International AB
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)';
