NetXMS Forum

Hello. There are no out of the box solution for that. I'd write some kind of script which will connect to mikrotik (over ssh or telnet), parse "ip hostspot active" command and produce per-user output in format of external parameter provider (https://wiki.netxms.org/wiki/ExternalParametersProvider) I also suggest to create second script, which will return only customer names, this way you'll be able to setup instance discovery (https://www.netxms.org/forum/configuration/create-agent-list-for-instance-discovery/)

You need to create all required tables and load initial configuration. This can be done with "nxdbmgr init path_to_sql_file" command, for example: nxdbmgr init /opt/netxms/share/netxms/sql/dbinit_pgsql.sql You need to change path (/opt/netxms/share/netxms/sql/) to conform your installation, and please note, that file name is different for different database types: AirAlk:~() $ ls -l /opt/netxms/share/netxms/sql/dbinit_*.sql -rw-r--r-- 1 alk admin 120673 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_db2.sql -rw-r--r-- 1 alk admin 119910 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_mssql.sql -rw-r--r-- 1 alk admin 112856 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_mysql.sql -rw-r--r-- 1 alk admin 120498 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_oracle.sql -rw-r--r-- 1 alk admin 117540 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_pgsql.sql -rw-r--r-- 1 alk admin 118248 Jun 22 22:17 /opt/netxms/share/netxms/sql/dbinit_sqlite.sql In your case, most likely command will be nxdbmgr init /usr/share/netxms/sql/dbinit_sqlite.sql NB! We strongly suggest not to use SQLite for anything than testing or development