What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

text file monitoring sql

Votes:

0

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



1 Reply

Votes:

0

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] (1,441) ●2 ●1




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.