Hello,

i tried it without any success in wmi tester.

Can you help me please ? I want to know if a windows firewall is activated or not : (root\Microsoft\HomeNet)

SELECT [Connection],
CASE
WHEN [IsFirewalled] = 'False' THEN 0
WHEN [IsFirewalled] = 'True' THEN 1
ELSE 2
END as IsFirewalled
FROM HNet_ConnectionProperties

Where did you get this query? Not sure it's syntactically valid WQL :( You might want to use the custom script sensors and a PowerShell script that reads the values.The cmdlet

Get-NetFirewallProfile | Select Name,Enabled

...will provide you with the states. Note that it doesn't work on remote hosts unless you create a CIM Session first.

Hi,

My default sensor (Oracle Sql v2 - Beta) is OK (Demo Serveruptime.sql).

I create a new sensor with a simple query to check if exist any lock session but the error is always - Erro Oracle ORA-1153*

SELECT
   'BLOCK_USER',count(*)
FROM
   v$session s
WHERE
   blocking_session IS NOT NULL

Can you help me?

Thanks a lot.

Could you execute the following:

C:\Program Files (x86)\PRTG Network Monitor\Sensor System\SQLv2.exe

...and enter the data accordingly - do you get the same error there?

Hi, if SQLv2.exe, the error is ora-12505: TNS:listener does not currently know of sid, but if I execute TNSPING* the connection works.

C:\>tnsping lithetst

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 27-AGO-2
015 16:22:49

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Arquivos de parÔmetros usados:
C:\oracle\app\product\11.2.0\client_1\network\admin\sqlnet.ora


Usado o adaptador TNSNAMES para resolver o apelido
Tentativa de contatar (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = exa1-scan.*******.com.br)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME =
 lithetst) (SERVER = DEDICATED)))
OK (20 ms)

Hi, I forget to talk that my Oracle Server is a Cluster (exadata - ORACLE RAC). Thati is a problem?

I'll talk to the developer to take a look at the thread :) Bear with us!

Its Works. But I need use to different SIDs (2 sensors - LITHE1 and LITHE2). If I use a servicename (LITHE), the connection fail. Its possible use a servicename?

Thanks

This is not possible now, but starting with version 15.x.19 there will be the possibility to use either the sid or the service name.

OK, I will wait.

Thanks a lot for your attention.

We have several sql servers, with more than 100 jobs at each. I had a simple script to get last 5min job failures, returning job's names and some more info. I used to get sms with job's name and first words of failure reason... Now it's seems like imposible to do. Create over 200 lookups? And change them, if job's name changes? Srsly? Consider going back to pasing real strings from SQL to PRTG, please.

Hello qurvax,
thank you for your post.

Please check the following:

• How to setup the SQL v2 sensors in PRTG? Is there a guide?

I advise you to adjust your SQL query and deploy it the following way:

• The SQL query should return the NUMBER of failures in the last 5 minutes (Within the deployed sensor set limits to set the sensor down or into warning based on this value).

• The SQL query should ALSO return a single string with the name of the jobs that failed (check the link above for mysql example), match this result to the sensor's message. It should behave exactly as expected.

When the number of failures is greater than the defined limit (0.1 for instance) the sensor will go down, if there are jobs in the sensor's message this will also be included in the notification once the sensor is down.

Please let me know whenever that works out or if you have further questions.

Best Regards,
Luciano Lingnau [Paessler Support]

Hello. Thanks for your help. Tried to implement, but...

1 # (#) is above the error limit of 0 # in # (Job Ok failed) :)

When there is failed jobs the result set looks like this:

And when there is none, it's just one row with single column containing 0. No problems getting sensor to determine when to go red. Problem is it still wont take my message.

• Use Data Table Value in Sensor Message is enabled
• Sensor Message Column Number set to 1
• Sensor Message* is Job {0} failed

Hello gurvax
thank you for your reply.

I assume that you're running PRTG Version 16.3.25.xxxx. The guide which I previously linked was created in version 16.3.24. I've checked our issue-tracker and just located a Bug which affect our current release (PRTG Version 16.3.25.xxxx):

I'm terribly sorry for not having spotted this earlier, your set-up looks absolutely correct, but due to this bug "Ok" is being displayed instead of the actual text. Consider one of the following alternatives:

1. Wait for the release of PRTG 16.3.26, it should be released in a couple of weeks/months.
2. Downgrade to PRTG 16.3.24, your PRTG will have kept the installer in the following directory: C:\Program Files (x86)\PRTG Network Monitor\PRTG Installer Archive

Best Regards,
Luciano Lingnau [Paessler Support]

No problem, I'll wait for updates, then.

We monitor dozens of MySQL database servers with PRTG. One of our most basic sensors is a MySQL v1 sensor that reports on the MySQL version using a very simple query: select version(); Typical output would be strings like:

• 5.6.25-73.0-log
• 5.6.31-77.0-log
  How can we do this with a MySQL v2 sensor that doesn't support text output? Creating a custom lookup for each possible value is not a good option.

This can be done using the sensor message option and modifying the query slightly: SELECT VERSION() AS Version;

The sensor will then state something like: Installed MySQL version: 5.5.41-log

Please note Luciano's post, as the function is broken in the current branch (16.3.25.xxx).

We're still running version 16.3.24.5303+ The query does display the version number, but the sensor goes to an error state and the full message is: Id 3: "5.6.25-73.0-log" [System.String] value can not be parsed. Please keep in mind that any date or time formats need to use the "EN-US" format.

I'm willing to wait for 16.3.26.x version, but I still have some concerns here.

1. I don't want my sensor to be in an error state to display the string. Is this just a bug of the v2 sensor in our current PRTG version?
2. I don't know why the string cannot be parsed. Is this what's sending the sensor into alarm?
3. Upgrading past 16.3.24.x will fully deprecate our existing sensors. I've read about the migration path but this is a scary option. The part about "Some SQL queries may return other values than before or may not work at all" is not exactly confidence inspiring.
4. Not upgrading to 16.3.26.x does not allow us to recreate & test our sensors with the fully bug-fixed MySQL v2 sensors.

This seems like a terrible catch-22, caught between a killed-off v1 sensor and a not-ready-for-primetime v2 sensor.

(Note that this is just an example; we have other, more complicated queries where we need text output but a lookup table is not practical, and we have other queries where we do want to set the sensor to an error state based on certain values.)

Hi Noah,

This will allow you to show strings within the message field of the sensor. The number field is just there so PRTG has a number to evaluate. Please use the following query in the SQL file: SELECT VERSION() as Version, "0" AS number

Which will output:

In the sensor settings, configure the following:

1. Data Processing
   Process Data Table
2. Select Channel Value by
   Column Name
3. Sensor Channel #1 Name
   number
4. Sensor Channel #1 Colum Name
   number
5. Use Data Table Value in Sensor Message
   Enable
6. Sensor Message Column Name
   Version
7. Sensor Message
   Installed SQL version: {0}
8. If Sensor Message changes
   Trigger 'change' notification

As for your migration concerns, the best way for you would probably be to setup a PRTG trial and check if the queries work and if they require changes. Sorry that this is causing those inconveniences for you :/

Oh! Great, thank you for the help and the super-speedy reply.

If I'm understanding this correctly, the important thing here is to return some sort of numeric result and then ignore it, so the string we actually want can come through in another channel?

Exactly :)

Is there any easy way to minitor Firebird DB's?

Only via the ADO SQL v2 Sensor and a corresponding connection string.

Have VBS code:

Dim dbfolder As String

        db_File = My.Settings.dbpath

        If My.Settings.serverrole = 0 Then
            FBDB= "Database=" & db_File & FB_ext
        Else
            db_loc= "maindb.FDB"
            FBDB = "User=SYSDBA;" +
                "Password=masterkey;" +
                "Database= " & db_loc & ";" +
                "DataSource=" & My.Settings.servername & ";" +
                "Port=" & My.Settings.serverport & ";" +
                "Dialect=3;" +
                "Charset=NONE;" +
                "Role=;" +
                "Connection lifetime=15;" +
                "Pooling=true;" +
                "MinPoolSize=0;" +
                "MaxPoolSize=50;" +
                "Packet Size=8192;" +
                "ServerType=0"
        End If

Could you give us an example of SQL code?

Unfortunately not :( What exactly are you trying to monitor, e.g. what metrics do you get when you execute that?

I will have enough of the similarity as a SQL Server sensor (SQL 2016)

There is a similar topic here https://kb.paessler.com/en/topic/14753-is-there-any-easy-way-to-monitor-firebird-database

So you want to have similar metrics, compared to the MSSQL 2016 Sensor(s), for the firebird database? I'm afraid that I'm not experienced with the database, you'll need to check the web for howto's (retrieve health metrics from firebird). This might be helpful: http://www.firebirdfaq.org/faq95/.

The other thread is eight years old, I doubt that the user is still active / has this solution :(

I'm also not experienced with the database Firebird, so I ask the public :-(

There are good answers, but they all do not indicate the correct ready-made solution, here is an example https://developer.ibm.com/answers/questions/371686/monitoring-agent-for-firebird-db.html

You could also check out the firebird subreddit. It doesn't have that many subscribers, but perhaps you're lucky and someone has a query that reads the health metrics.

Nobody helped, and I also did not find an answer on the Internet :-(

Hi K0NCTANT1N,

Thank you for the update.

I'm sorry, we have no experience with firebird DB either. Maybe the this article will help you create the required SQL query that you can use in the ADO SQL v2 Sensor.

Best Regards,
Moritz Heller
Paessler Support Team

Hello.
I would like to create a sensor that make one channel for each value in column 0 (Job) and takes its corresponding value in column 1 (IsRunning).
I cant figure out the right options to choose to have one channel for each row created automatically.
I don't want to create the channel manually as more job are added frequently.
Does anyone know a way to do it?

Thank for the help