add Application protection job duration in SPPMON Dashboard

[daytoju]

Feature request : in Grafana dashboard, under the protection job section there is no details on Protection job duration for MS-SQL jobs , although we have it for VM and DB2 .. is it possible to get it ? same for other workload as well ( openshift , oracle , ... )

Alternative would be a documentation section explaining how to build our own dashboards from the data you are collecting . I'd be happy to work with you to develop this.

[NielsKorschinsky]

Hello @daytoju,
I'm currently out of the office and will respond to any further questions at a later notice after 21.09.

You may easily add these panels as you wish, as long as it only uses existing data (check the "all job executions"-panel).
All job executions are collected, as they are available via the SPP catalog.

Steps to do so:

1. Find the VM backup or db2 panel in the section
2. Go on the dots/menu of the panel and select duplicate
3. in the new panel, go on edit
4. The job name is selected in the query, SQL style. You may change the selection to the job name of the ms-SQL job:
   • Please check the other panels for different values of the selection to get an idea of how it is selected
   • Grafana should, but not always does, provide a drop-down of existing values. You may check the "all job executions panel" for your required job-name value.
   • You may also use regex to select all jobs with a given prefix. A Regex requires slashes / before and after and the ~=sign set in the Grafana query. Please check the other queries; I think vm-jobs use a prefix.
5. if available, feel free to press the "migrate to new version" button on the right-hand side.
6. Move your query to a location of your desire; you may also re-size it.

Important note:
Once a new dashboard version is released, and you import it, your changes might be lost.
There is no routine for this process yet, but you can:

1. write down your changes to easily replicate them
2. Make the panel a library panel via the menu. This way, you might be able to retain it once the dashboard is overwritten. This process is untested!
3. Open a pull request to supply your newly changed dashboard as the new official version.

Another context:
SPPMon also tracks and shows MySQL backup data; however, as of Issue #76 , this data is disabled for normal execution, and the panel within Grafana is empty.
Please use the --fullLogs'flag on the --dailyand--all` execution to track these data again.
Be aware that more errors might occur during execution; however, they should (usually) not affect the data you're worried about.

[NielsKorschinsky]

Also, I'm up for writing another wiki page, I though I'd already added one about this topic, but it doesn't look like it.
However, my master's thesis is almost over and with it my time on this project will most likely end.
The wiki is written in markdown. If you have any suggestions, please feel free to share here or via slack.