#pppoe

In this script, you need to define the username variable with the username of the PPPoE user you want to monitor. You also need to set the threshold variable to the maximum amount of data (in bytes) that the user can consume before being disconnected. Adjust these variables according to your requirements.

The script retrieves the bytes-in and bytes-out counters for the specified user and compares them with the threshold. If either the incoming or outgoing data exceeds the threshold, it logs a warning message and removes the user from the PPPoE server, effectively disconnecting them.

You can schedule this script to run periodically using the MikroTik scheduler to continuously monitor and disconnect users who exceed the data threshold.

Let's go through the script step by step:

1. The first line `:local username "user1"` assigns the value "user1" to the local variable "username". You can change this value to the desired PPPoE username you want to monitor.

2. The second line `:local threshold 1000000000` sets the data threshold to 1GB (1,000,000,000 bytes). You can adjust this threshold to the desired value.

3. The next two lines retrieve the bytes-in and bytes-out values for the specified username using the `/interface pppoe-server monitor get` command.

4. The if condition `:if ($bytesIn > $threshold || $bytesOut > $threshold) do={...}` checks if either the bytes-in or bytes-out values for the user exceed the threshold.

:local dataLimit 1G; -- Set the data limit here (e.g., 1 Gigabyte)

:local threshold ($dataLimit * 0.9); -- Set the threshold (e.g., 90% of the data limit)

:foreach user in=[/ppp active find] do={

:local userName [/ppp active get $user user];

:local bytesOut [/ppp active get $user bytes-out];

:local bytesIn [/ppp active get $user bytes-in];

:local totalBytes ($bytesOut + $bytesIn);

:if ($totalBytes >= $threshold) do={

:log info ("Data limit reached for user: ".$userName);

/ppp active remove $user;

}

}

2- Schedule the script to run periodically:

Go to "System" -> "Scheduler" in the MikroTik interface.

Click on the "+" button to add a new scheduler entry.

Set the desired interval for the script to run (e.g., every 5 minutes).

In the "On Event" field, enter the name of the script created in step 2 (e.g., "DataLimitScript").

This script will check the data usage of each active PPPoE user and disconnect them if they reach the specified data limit or threshold. Adjust the "dataLimit" variable to set the desired limit (e.g., "1G" for 1 Gigabyte). You can also modify the "threshold" variable to change the percentage at which users will be disconnected.