Hi i having trouble with the script on RouterOS - RouterOS - MikroTik Documentation
I cannoy make the monthly usuage script work. As they say at the bottum is states that i must remove all the # . I did that and i also changed the example.com to my email address and the server.
the one on the site looks like this...
:local content
:local i
:local sitename
:local gigs
:local email
:local megstotal
:local totalcurrent
:local bytesdowncurrent
:local bytesupcurrent
:local megsdowncurrent
:local megsupcurrent
:local percentage
:local bytesdownsaved
:local bytesdowntotal
#Script based on Automated billing script at RouterOS - RouterOS - MikroTik Documentation
This version created by Andrew Cox - www.accessplus.com.au
:log info "------ Begining Monthly Reports -------"
#For each queue in the list
:foreach i in=[/queue simple find name !=""] do={
#Pull name out of queue and divide up accordingly
:set content [/queue simple get $i name]
#Determine variables from name
#Format is: sitename ! gigsallowed # who-to-email ! last warning level(0-50-75-90-100)
:if ( [ :find $content "!" ] != "" ) do={
:local pos1 [:find $content "!"]
:local pos4 [:len $content]
:local pos2 ([:find [:pick $content ($pos1+1) $pos4] "#"]+$pos1+1)
:local pos3 ([:find [:pick $content ($pos2+1) $pos4] "!"]+$pos2)
:set sitename [:pick $content 0 ($pos1)]
:set gigs [:pick $content ($pos1+1) $pos2]
:set email [:pick $content ($pos2+1) ($pos3+1)]
:set totalcurrent [/queue simple get $i bytes]
:local pos5 [:find $totalcurrent "/"]
:local pos6 [:len $totalcurrent]
:set bytesupcurrent ([:pick $totalcurrent 0 ($pos5)])
:set bytesdowncurrent ([:pick $totalcurrent ($pos5+1) $pos6])
:set megsupcurrent ($bytesupcurrent / 1048576)
:set bytesdownsaved ([:pick $content ($pos3+5) $pos4])
:set bytesdowntotal ($bytesdowncurrent + $bytesdownsaved)
:set megsdowncurrent ($bytesdowntotal / 1048576)
#Begin calculating usage percentage
:set percentage ( ( $bytesdowntotal * 100 ) / ( $gigs * 1073741824 ) )
:log info "$sitename: $percentage%"
:if ([$email] != "" ) do={
/tool e-mail send to=$email from=noreply@example.com server=1.3.3.7 subject="$sitename: Monthly Report" body="This message is to inform you of the full monthly usage for $sitename
In this month this site has downloaded $megsdowncurrent MB, which is $percentage% of the $gigs GB monthly download allowance.
This is an Automatically generated E-mail that is sent out at the end of each month.
Traffic Monitor System,
accounts@example.com"
}
#Send email to support/accounts also
/tool e-mail send to="accounts@example.com" from="noreply@example.com" server="1.3.3.7" subject="$sitename: Monthly Report" body="Full monthly usage for $sitename
In this month this site has downloaded $megsdowncurrent MB, which is $percentage% of the $gigs GB monthly download allowance.
Traffic Monitor System,
accounts@example.com
Please report any errors in this message to someone@example.com"
:log info "Sent monthly report for $sitename to $email"
#Set warning level on queue name back to 00 and reset counters
/queue simple set $i name="$sitename!$gigs#$email!00#0000"
/queue simple reset-counters $i
}
}
and.........my one looks like this............
:local content
:local i
:local sitename
:local gigs
:local email
:local megstotal
:local totalcurrent
:local bytesdowncurrent
:local bytesupcurrent
:local megsdowncurrent
:local megsupcurrent
:local percentage
:local bytesdownsaved
:local bytesdowntotal
Script based on Automated billing script at RouterOS - RouterOS - MikroTik Documentation
This version created by Andrew Cox - www.accessplus.com.au
:log info "------ Begining Monthly Reports -------"
For each queue in the list
:foreach i in=[/queue simple find name !=""] do={
Pull name out of queue and divide up accordingly
:set content [/queue simple get $i name]
Determine variables from name
Format is: sitename ! gigsallowed # who-to-email ! last warning level(0-50-75-90-100)
:if ( [ :find $content "!" ] != "" ) do={
:local pos1 [:find $content "!"]
:local pos4 [:len $content]
:local pos2 ([:find [:pick $content ($pos1+1) $pos4] "#"]+$pos1+1)
:local pos3 ([:find [:pick $content ($pos2+1) $pos4] "!"]+$pos2)
:set sitename [:pick $content 0 ($pos1)]
:set gigs [:pick $content ($pos1+1) $pos2]
:set email [:pick $content ($pos2+1) ($pos3+1)]
:set totalcurrent [/queue simple get $i bytes]
:local pos5 [:find $totalcurrent "/"]
:local pos6 [:len $totalcurrent]
:set bytesupcurrent ([:pick $totalcurrent 0 ($pos5)])
:set bytesdowncurrent ([:pick $totalcurrent ($pos5+1) $pos6])
:set megsupcurrent ($bytesupcurrent / 1048576)
:set bytesdownsaved ([:pick $content ($pos3+5) $pos4])
:set bytesdowntotal ($bytesdowncurrent + $bytesdownsaved)
:set megsdowncurrent ($bytesdowntotal / 1048576)
Begin calculating usage percentage
:set percentage ( ( $bytesdowntotal * 100 ) / ( $gigs * 1073741824 ) )
:log info "$sitename: $percentage%"
:if ([$email] != "" ) do={
/tool e-mail send to=$email from=mikrotik@kleinkarootoyota.co.za server=192.168.0.51 subject="$sitename: Monthly Report" body="This message is to inform you of the full monthly usage for $sitename
In this month this site has downloaded $megsdowncurrent MB, which is $percentage% of the $gigs GB monthly download allowance.
This is an Automatically generated E-mail that is sent out at the end of each month.
Traffic Monitor System,
mikrotik@kleinkarootoyota.co.za"
}
Send email to support/accounts also
/tool e-mail send to="emile@kleinkarootoyota.co.za" from="mikrotik@kleinkarootoyota.co.za" server="192.168.0.51" subject="$sitename: Monthly Report" body="Full monthly usage for $sitename
In this month this site has downloaded $megsdowncurrent MB, which is $percentage% of the $gigs GB monthly download allowance.
Traffic Monitor System,
accounts@example.com
Please report any errors in this message to emile@kleinkarootoyota.co.za"
:log info "Sent monthly report for $sitename to $email"
Set warning level on queue name back to 00 and reset counters
/queue simple set $i name="$sitename!$gigs#$email!00#0000"
/queue simple reset-counters $i
}
}
but it stil does not work. can anyone please help me and tell me what im doing wrong.thanx.