NetXMS Support Forum

Hello

Has anybody used osquery and get results into NetXms ?

Its supposed to work like SQLLite (but actually uses rocksdb) database with system info in it for easy query. but not sure how to query it with netxms.

Egert

Hello

What would be good way to alert on condition when some node suddenly starts responding to ping or to tcp port for example and normal status would be down. Usually monitoring it other way around.

Egert

nxagent-3.8.262-x64.exe size is 6,84MB

First time using that tool, so hope i did it correctly.

Command i ran: "nxupload TargetIP Path\nxagent-3.8.262-x64.exe". It stops with "Upload: 7178488" and then "error: 408: Request timeout".

Egert

Hello

Reviving old topic.

With version 3.8.0, agent 3.8.262 (old agent version trying to upgrade 3.5.90) package manager update still fails when target cpu is 100% usage or very near to it (showing security camera feeds). Can i assist with logs or something to get this issue resolved?

Egert

Thanks for the reply. Is there any reference in database for example when node went down/up ? Maybe i could extract it with another app and build statistics and link it back with tool menu. Currently one way i can think of is to parse event logs and look for specific events.

For example node would have tool lets call it uptime and it would show latest x amount of downtimes and durations and then more general uptime info for month/year etc.

Hello

Is it possible to do currently or is there plans to add support for Node uptime statistics. Basically possibility to list nodes ordered by most down time or sort them by site and see what site has most issues with uptime.

Egert

Hello

When polling MS Sql database with agent, what shoud be written in database name as the query is generic and not specific to single database ?

Database = id=db3;driver=mssql.ddr;server=x.x.x.x;dbname=????;login=xxxx;password=xxxxx
Query = query:db3:300:SELECT Count(name) From sys.databases WHERE database_id > 4 AND group_database_id IS not NULL

Hello

What would be the best way to create dci, that check two other dcie values?

For example Router version and firmware and alert when they dont equal each other.

Egert

Hello

This happen with old java version.

Egert

Many thanks, had to adjust script litle bit, but got it working.

m = $1 match "(.+)\[.+\]";

if (m) {

  return %(true, $2, m[1]);
 
}
else
{
  return false;
}

Hello

When creating DCi with instance discovery how can i parse the name to remove text between "[" and "]" inlcuding brackets also?

Example name: Camera - Name a - b - c [4a613e60-77f3-4e32-8d8e-d4723d945b98]


Egert

Created Web Service Definition with name and url, also checked "verify the peer's SSl certificate" + "verify the certificate's name against host". Then created DCI with parameter "name:version", origin: web service, type: string and result is unsupported. What should i change ?

Edit: Seems like sometimes the poll is succesful and othertimes it fails.

if (!$node->isAgent)
return false;


if ( $node->platformName ~= "windows")
{
table = AgentReadTable($node, "System.InstalledProducts");
if ( table == null ) return null;
colName = table->getColumnIndex("NAME");
for (currentRow = 0; currentRow < table->rowCount; currentRow++)
{
if ( table->get(currentRow, colName) ~= "Program name" ) return true;
}
}
return false;

Hello

Is it possible to extract data with web service from this sample data (its returned in webpage):

{"py/object": "detector.api.Snapshot", "time": 1607485618.4846845, "version": "v1.2.3", "detections": [], "antenna_gps": {"py/tuple": [01.12343455, 02.45542]}, "antenna_gps_locked": true, "antenna_temp": -6.816406250000001, "antenna_yaw": 354.90458852191114, "jamming": false, "is_battery_powered": false, "battery_percent": 0, "suspended": false}

if yes, is it enought to fill in only name and url? Also in dci settings what is the correct parameter for example to get version info ?

Egert