Hi,

I have to get the number session on my PRTG console with command as select count(*) from sys.v_$session

In old version, we could use Oracle SQL but new version with Oracle SQL v2 is not possible.

How can I do Oracle query and get the payload in PRTG ?

Thanks in advance

Article Comments

With the new SQL v2 sensor framework, queries are now stored in PRTGs app directory,
C:\Program Files (x86)\PRTG Network Monitor\Custom Sensors\sql\ to be exact. Store the query files in the corresponding DBMS folders and you can select the query when creating the sensor. Make sure that Data Processing is set to Count table rows.



Let me know if it worked out!


Jun, 2016 - Permalink

Hi,

Yes it is working :)

I have to use a 'System' account too.

Thanks for your help and time.


Jun, 2016 - Permalink