I'm trying to find the documentation for extracting data from the database from Mikrotik. Unfortunately, this is what I get on the date 12 April 2022.
Thanks to sergejs from MikroTik Support posting way back in the year 2005. Most of the variables are still usable. Hopefully, this will help you do your customization.
_username - Username
u_password - Password
u_firstName - First name
u_lastName - Last name
u_phone - Phone
u_location - Location
u_comment - Comment
u_email - Email
u_ipAddr - IP address
u_callerId - Caller ID
u_shared_users - Shared users
u_usedUpload - Upload Used
u_usedDownload - Download Used
u_usedUptime - Uptime Used
u_lastIpAddr - Last used IP
u_lastMAC - Last used MAC
u_tillTime - Till time
u_timeLeft - Total time left
u_actualProfileName - Actual profile
u_actualProfileStart - Start time
u_actualProfileEnd - End time
u_actualProfileLeft - Time left
u_limitDownload - Download limit
u_limitUpload - Upload limit
u_limitDownload - Transfer limit
u_limitUptime - Uptime Limit
u_actualRateLim - Rate limit
u_moneyPaid - Money paid
u_moneyUsed - Money used
u_moneyLeft - Money left
u_wirelessPsk - Preshared key
u_wirelessEncKey - Encryption key
u_wirelessEncAlgo - Encryption algorithm
u_firstName - First name
u_lastName - Last name
u_phone - Phone
u_location - Location
u_comment - Comment
u_email - Email
u_ipAddr - IP address
u_callerId - Caller ID
u_shared_users - Shared users
u_usedUpload - Upload Used
u_usedDownload - Download Used
u_usedUptime - Uptime Used
u_lastIpAddr - Last used IP
u_lastMAC - Last used MAC
u_tillTime - Till time
u_timeLeft - Total time left
u_actualProfileName - Actual profile
u_actualProfileStart - Start time
u_actualProfileEnd - End time
u_actualProfileLeft - Time left
u_limitDownload - Download limit
u_limitUpload - Upload limit
u_limitDownload - Transfer limit
u_limitUptime - Uptime Limit
u_actualRateLim - Rate limit
u_moneyPaid - Money paid
u_moneyUsed - Money used
u_moneyLeft - Money left
u_wirelessPsk - Preshared key
u_wirelessEncKey - Encryption key
u_wirelessEncAlgo - Encryption algorithm
If there are any updates from the list above, let me know ok.
No comments:
Post a Comment