How Many Months Of History Should Be Available In The Operation Monitor App

[Daniel_Seo]

How to reduce the size of the Operations Monitor App or decide how much history is being stored.

Scenario: There are only 3 months of history/data in Operation Monitor app. Even though there are enough logs in Archived log folder to provide information for more months. 

Scenario 2: There are 3 months of history/data seen but less data is required due to too high traffic. 

This article explains how Operation monitor app can be displayed more or less than 3 months of history/data. Note: We do not recommend configuring the Operations Monitor to provide a history longer than 3 months as this amount of data will lead to long loading times and large apps.

Resolution:

1. Duplicate the Operation Monitor app. You can do so from the Hub or the Qlik Sense Management Console if you have access to the App.
   
   
2. Open the Qlik Sense Hub, Navigate to Work and open your copy of the Operations Monitor(1)
   
   
3. Open the Data load editor
   
   
4. Locate line 24 in the Initialize tab (first tab)
   
   
5. Line 24 will read: SET monthsOfHistory = 3
   
   
6. Modify SET monthsOfHistory = 3  to your preferred value.  The Operations Monitor will be able to load data as long as you have log files that go that far back. 
   
   Example:
   

   "SET monthsOfHistory = 3"        -- 3 Months
   "SET monthsOfHistory = 6"        -- 6 Months
   "SET monthsOfHistory = 12"      -- 12 Months​

7. Open a Windows file browser and navigate to: %PROGRAMDATA%\Qlik\Sense\Log (default install folder)
   
   
8. Remove all “governance” QVDs from this folder. This step is crucial for the changes to work.
   
   
9. Go to the Qlik Sense Management Console
   
   
10. Open Apps
    
    
11. Locate your copy of the Operations Monitor.
    
    
12. Click publish
    
    
13. Select the Monitoring Apps stream
    
    
14. Check the Replace existing app checkbox
    
    
15. Select the original Operations Monitor 
    
16. Click OK
    
    
17. Go to Tasks and start the Operations Monitor task
    
    
18. Your app will now show the desired number of months. 

Note: 
Please note that the reload time for that long of data will be rather long.

[Ken_T]

Hi , can you give some guidance on how to correct the Latest activity filter in top left corner of the session overview ?  This filter no longer functions properly when it has been increased for example to 12 months worth of data. It has 3 values, 30 days, 60 days and 90 days. selecting any of these values has no affect on the data shown and results calculated this article should explain how to fix that problem.   thanks!

[Ken_T]

I logged a ticket on this issue and got no assistance. This is a hard coded filter and it does not function properly after applying the changes from this article. Can Qlik confirm that after performing this change to bump up the data to be more than 3 months, the Latest activity filter on Session overview stops functioning and will require some code changes to try to correct the problem.

also, a list of the governance qvd's could help clarify this article.

[Sonja_Bauernfeind]

Hello Ken,

The setting has been confirmed to work and no additional changes to the app itself are needed (except step 8 in the instructions: deleting the old .qvds).

I've reached out to our SMEs for an additional review though and will update you accordingly.

All the best,

Sonja 

[Ken_T]

The built-in filter named "Latest activity" with values of 30+ Days, 60+ Days and 90+Days does not work properly after performing these steps.
So far I have not found the configuration/script changes required to make this filter work after increasing the months of history.
That filter is hard coded and cannot be easily removed and must have one value selected.
I logged a support ticket about a year ago and got not confirmation or assistance on the issue.

[Sonja_Bauernfeind]

This article was verified and the steps were updated to reflect all required steps. Should you run into issues, please report a ticket with support.

[505018417]

For the cluster environment where would you find below qvds?

1. Open a Windows file browser and navigate to: %PROGRAMDATA%\Qlik\Sense\Log (default install folder)
   
   
2. Remove all “governance” QVDs from this folder. This step is crucial for the changes to work.

[Sonja_Bauernfeind]

Hello @505018417 

They will be stored in whichever folder you have defined during setup in the Data Connection (see Configuring multi-node environments).

All the best,
Sonja 

[505018417]

What do I look for? What file/folders should I be looking for to change that. We would like to have 12 months of History in the Operation Monitor App.

[Sonja_Bauernfeind]

Hello @505018417 

Can you be more specific with your request? Do you need assistance locating the folder where the .qvds are stored in your multi-node environment? Suppose you have configured the monitoring apps correctly as per Configuring multi-node environments. In that case, you can find this folder as per step 1 in the multi-nod instructions (Configuring multi-node environments)

Update the data connections ServerLogFolder, by replacing C:\ProgramData\Qlik\Sense\Log with the FQDN path to the central node: \\<FQDN>\<UNC_Share>\Log.

This refers to the data connection in the Qlik Sense Management Console:

Open your Data Connections, scroll down and locate ServerLogFolder (1) and click Edit (2).

This opens the connection, and there you can see what the connection string was configured to:

Note that in my screenshot, it is the default folder since this is a single-node environment where I have not set up the monitoring apps to work with a multi-node.

All the best,
Sonja