How can I filter the output of any print command in RouterOS?
for example: ip route print - how can I get only the connected, static, etc... it does have embedded filter for BGP and OSPf though - it works.
But how can I flexibly define what I want to be displayed? I'm running full table BGP now and it's really needed.
Is there a nice guide explaining these command options?

                 whitespace
        <value>  literal value that consists only of digits, letters and 
                 characters ._
              !  logical negation
              "  start of quoted string
              $  substitution
              (  start of subexpression
              -  unary minus
              >  quote
              [  start of command substitution
              {  start of array value
              ~  bit inversion
            bgp  Find or not BGP routing protocol
  check-gateway  Whether all nexthops of this route are checking reachability 
                 of gateway by sending arp requests every 10 seconds
        comment  Short description of the item
       disabled  Defines whether item is ignored or used
       distance  Administrative distance of the route
    dst-address  Destination address
           ospf  Find or not OSPF routing protocol
            rip  Find or not RIP routing protocol
   routing-mark  It's used for policy-routing

active                bgp-weight     gateway-status  routing-mark 
bgp                   blackhole      mme             scope        
bgp-as-path           check-gateway  ospf            static       
bgp-atomic-aggregate  comment        ospf-metric     target-scope 
bgp-communities       connect        ospf-type       type         
bgp-ext-communities   disabled       pref-src        unreachable  
bgp-local-pref        distance       prohibit        vrf-interface
bgp-med               dst-address    received-from   
bgp-origin            dynamic        rip             
bgp-prepend           gateway        route-tag       

/ip route print where static=yes

/ip route print where connect=yes

/ip route print where static=yes and active=yes

How can I filter the output of any print command in RouterOS?
for example: ip route print - how can I get only the connected, static, etc... it does have embedded filter for BGP and OSPf though - it works.
But how can I flexibly define what I want to be displayed? I'm running full table BGP now and it's really needed.
Is there a nice guide explaining these command options?

You probably put: "/ip route print where ?" in the console (with question mark) and you got shorter list of options:

Code: Select all

                 whitespace
        <value>  literal value that consists only of digits, letters and 
                 characters ._
              !  logical negation
              "  start of quoted string
              $  substitution
              (  start of subexpression
              -  unary minus
              >  quote
              [  start of command substitution
              {  start of array value
              ~  bit inversion
            bgp  Find or not BGP routing protocol
  check-gateway  Whether all nexthops of this route are checking reachability 
                 of gateway by sending arp requests every 10 seconds
        comment  Short description of the item
       disabled  Defines whether item is ignored or used
       distance  Administrative distance of the route
    dst-address  Destination address
           ospf  Find or not OSPF routing protocol
            rip  Find or not RIP routing protocol
   routing-mark  It's used for policy-routing

Type in the console: "/ip route print where <tab>" (press [TAB] at the end) and you will get full list of options:

Code: Select all

active                bgp-weight     gateway-status  routing-mark 
bgp                   blackhole      mme             scope        
bgp-as-path           check-gateway  ospf            static       
bgp-atomic-aggregate  comment        ospf-metric     target-scope 
bgp-communities       connect        ospf-type       type         
bgp-ext-communities   disabled       pref-src        unreachable  
bgp-local-pref        distance       prohibit        vrf-interface
bgp-med               dst-address    received-from   
bgp-origin            dynamic        rip             
bgp-prepend           gateway        route-tag       

Now you see options you are looking for (connect, static).
To see static routes type:

Code: Select all

/ip route print where static=yes

To see connected routes type:

Code: Select all

/ip route print where connect=yes

You can combine options to filter what you want:

Code: Select all

/ip route print where static=yes and active=yes

[TAB] key will always give you list of possible options.

Thing is, I am trying to make a python script that connects to the router and gets all the ip firewall connection info, but when I run the command from the python script only the first 4 columns get printed out. It's because the terminal window the script opens up isn't big enough to hold all the data so it only prints out the columns that can fit.

I either want to print out only the data I need so it fits inside that window or make the window bigger, which seems impossible. Here is the script:

Code: Select all

import paramiko

client = paramiko.SSHClient()
client.set_missing_host_key_policy(paramiko.AutoAddPolicy())
client.connect('myIP', username='myUsername', password='myPass')
stdin, stdout, stderr = client.exec_command('ip firewall connection print')
for line in stdout:
    print(line.strip('\n'))
    
client.close()

I can't seem to work out any way of solving this, it seems so silly that there is no workaround.

/ip firewall connection print terse without-paging