'[get $i active-host-name]' only when I add this part; 'input does not match any value of value-name'

RouterOS Scripting
1

Hello

I am getting an error as ‘input does not match any value of value-name’.
My script is as below
’
:foreach i in=[find] do={:put ([get $i block-access].‘,’.[get $i address].‘,’.[get $i mac-address].‘,’ .[get $i client-id].‘,’.[get $i server].‘,’.[get $i active-address].‘,’.[get $i active-mac-address].’ ,'.[get $i active-host-name]) }
’
‘[get $i active-host-name]’ only when I add this part;
‘input does not match any value of value-name’

I get this error.

2

From which menu? Are you sure that this parameter even exist in the menu you are trying to get it from?

3

I am absolutely sure.
I took a screenshot. attached.
Ekran Alıntısı.JPG

4

no there isn’t,

write in the terminal “get 0” and press tab to see all the valid parameter names.

5

It also brings only 1000 thread lists in the terminal.
I have a list of 1500 threads.
How can I get them all?

Or I can export to an excel sheet or csv or txt.

6

I did not understand or could not do this.

Could you give an example, please.

7

Maybe if you pay atteNtioN to how you write … oN the forum you wrote one thiNg, in the screeNshot there is aNother !!!

active-host-name do not exist, you must use host-name

try to avoid morse code ‘.’.‘.’.‘.’ …

:foreach i in=[find] do={
    :put "$[get $i block-access],$[get $i address],$[get $i mac-address],$[get $i client-id],$[get $i server],$[get $i active-address],$[get $i active-mac-address],$[get $i host-name]"
}
8

Teşekkürler

9

:slight_smile:

10

:slight_smile:

11

My friend;

It also brings only 1000 thread lists in the terminal.
I have a list of 1500 threads.
How can I get them all?

Or I can export to an excel sheet or csv or txt.

12

You have 1500 threads items?

Where you read it?

try

print count-only

and see what number appear

13

It looks like 1260 pieces.

The hotel has a hotspot that’s why it’s so much.

Now I need to extract them somewhere in my cvs txt or xlsx format.

14

MikroTik have 4095 byte for (managed by script) file limit, the list can’t be stored on one unique file from the script

15

So how can I get all of these ip and mac addresses? Is there any other management?

16

I don’t know what to suggest, you can do

/ip dhcp-server lease print terse file=namefile

but then you have to process later the file with the computer

17

Believe me, that’s exactly what I was trying to do. I think it will do my job.

But what I really want to do is actually.
I want to extract the excel file with vba and follow some controls online. Maybe I can.
If I can find a clue an example I can do the rest somehow.
Thank you.