New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


text file monitoring sql

Votes:

0

Your Vote:

Up

Down

Hello, I am trying to figure out a way to monitor a folder that a batch process drops text files into. In the name of the text file is a number after the first three letters and I then want a way to query a sql table to check if it got entered. Is that possible, so for each new file, wait a few seconds, then query SQL and if it doesn't match, then create alert?

Thanks!

file monitoring sql text

Created on Oct 4, 2019 10:45:34 PM by  fkiwergrower (0) 1



1 Reply

Votes:

0

Your Vote:

Up

Down

Hello,

This isn't something one of our sensors would be able to do natively. The best method to accomplish this would be to create a custom sensor to accomplish this. PRTG could invoke it with a Folder sensor, because we can watch a folder, and alert based on the age of the newest file. So PRTG could trigger an alert that kicks off this script. The script would handle all the logic you're asking for, and the pass a result code back to PRTG.

If this sounds like something you're interested in looking into, I would check out the PRTG API Custom Sensors section. Go to Setup -> PRTG API -> Custom Sensors in your web UI for more information.

Thanks!

Benjamin Day
Paessler Support

Created on Oct 5, 2019 1:39:56 AM by  Benjamin Day [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.