Hello. Recently I deployed ASEmon v.3.2.3. Some of the metrics that are displayed in table format allow for quick lookup and edit of the sql query that provides the data. The query is shown in this white pop window which allows you to edit it, but I don't see any 'apply' or 'ok' or 'confirm' button. If I add some changes and click on the close button, they are lost. See attached ss. Does ASEmon support this functionality of adhoc changes to collectors' queries ? If so how can I apply them in the GUI.
I found that you can edit these queries in .php files located in
\AsemonReportSRV\Asemon_report\ASE\sql ,but this is not convenient and you need to know which file to look for them.
Hi,
no, this windows just allow you to see the last statement which fectch rows into asemon_report
"Last statement" since sometime asemon has to execute several statements (and sometimes uses cursors) and this windows displays only the last executed statement
This windows should not be editable.
Regards
Jpm
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello. Recently I deployed ASEmon v.3.2.3. Some of the metrics that are displayed in table format allow for quick lookup and edit of the sql query that provides the data. The query is shown in this white pop window which allows you to edit it, but I don't see any 'apply' or 'ok' or 'confirm' button. If I add some changes and click on the close button, they are lost. See attached ss. Does ASEmon support this functionality of adhoc changes to collectors' queries ? If so how can I apply them in the GUI.
I found that you can edit these queries in .php files located in
\AsemonReportSRV\Asemon_report\ASE\sql ,but this is not convenient and you need to know which file to look for them.
Thank you in advance !
Last edit: elovelo 2024-11-08
Hi,
no, this windows just allow you to see the last statement which fectch rows into asemon_report
"Last statement" since sometime asemon has to execute several statements (and sometimes uses cursors) and this windows displays only the last executed statement
This windows should not be editable.
Regards
Jpm
ok, got it. thank you, Martin.