Mikrotik Script - all table columns

Question

I'm trying to have a script run daily that would email the list of recently activated users. I cannot find a command that would list what i see in userman 'Users' screen.

I need to fire a script daily of the couple of users that got activated last night. Those are clearly obvious in user-manager however if in the terminal you type "/tool user-manager user print" it only shows the admin user connected to winBox!! not the end users in user-manager. On the other hand, if you type "/ip hotspot active " but this only shows me the active users now not the view i want. QUESTION: What is the proper command/script to show users in user-manager with all the good info like Profile, start-time etc??

score 0 · Accepted Answer · answered Oct 09 '15 at 16:07

0

After much research, the columns in the table are not accessible through the api or the mikrotik terminal command. One has to access the SQL directly using drivers suc has SQLite3 or such .

answered Oct 09 '15 at 16:07

devsahem

83
3
15

Hi devsahem are you still working with the mikrotik? – Neil Aug 24 '16 at 08:43

score 0 · Answer 2 · answered Nov 08 '15 at 23:14

First print the content of the Users screen to a file:

/ip hotspot user print file="users.txt"

Then e-mail it to whatever mail you want:

/tool e-mail send file="users.txt" to=xxx@xxx.com subject="user list" body="hello\nthis is an automated message"

score 0 · Answer 3 · answered Aug 13 '17 at 10:50

you can use the detail flag:

/ip hotspot user  print detail

You can use the where closure for filter content:

/ip hotspot user  print detail where profile=users-x limit-uptime>20m

Saving in a file:

/ip hotspot user  print file="info_users-x.txt" detail where profile=users-x

Mikrotik Script - all table columns

3 Answers3