NetXMS Support Forum

Hi,

I'm trying to build dynamic Dashboards in Grafana using the integrated Web-API, but unfortunately with limited success...

First Question: Is the integrated Web-API complete with all NetXMS-API-Endpoints, or is the integrated one (enabled by including `Module = webapi` in netxmsd.conf) only a lighter version, in which case I should probably switch to the Full-API (netxms-websvc-VERSION.war)?

Second Question: Is there a Bug in the API with user-provided query values?
When querying the Endpoint '/v1/grafana/infinity/object-query' and providing query values, those user-provided query values are not used within object-query.
I've modified my Object-Query to output a debug-column with a serialization of the `$INPUT`-Hashmap, when querying via the NetXMS-Client, I see my Input, but when querying via the API, there is no Input to be seen (see Example in Attachments).

Best regards and Merry Christmas,
Manuel

Hi,

I just installed a fresh Microsoft SQL Express 2017 Server, created the database "NetXMS" and a correspondign user "NetXMS". Then I installed the NetXMS Server Core (Version 2.2.1) and run the Server Configuration Wizard, which finished succesfully.

After that I tried to start the "NetXMS Core" Service, which failed.
In the Logs I can see a failed SQL-Query "SELECT snmp_oid,description,flags FROM snmp_trap_pmap WHERE trap_id=? ORDER BY parameter"...
...when I execute this Query against the Database through the SQL Server Management Studio (logged in as user "NetXMS"), I get the following error:

Meldung 102, Ebene 15, Status 1, Zeile 1
Falsche Syntax in der Nähe von "?".

Translation: Wrong Systax near "?"

I did the installation on a freshly installed Windows 10 PC (Drivers are up-to-date, Windows Updates are installed).

I've got no idea whats going wrong in my setup...
...any ideas?

Best regards,
Manuel Schneider