Are you doing an upgrade? If yes, try to remove old versions of NetXMS libraries before compilation.
Best regards,
Victor
Best regards,
Victor
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts Menu
Буду дальше разбираться...
SELECT n.primary_ip IP,
o.name NAME,
n.uname MODEL,
n.snmp_sys_name SNMP_DESCR,
n.bridge_base_addr MAC_ADDR,
i.description VLAN,
r.transformed_value SERIAL
FROM nodes n
LEFT JOIN object_properties o ON n.id = o.object_id
LEFT JOIN interfaces i ON n.id = i.node_id AND i.description like '%vlan%'
LEFT JOIN items t ON t.node_id=n.id AND T.NAME='.1.3.6.1.2.1.1.1.0'
LEFT JOIN raw_dci_values r ON r.item_id=t.item_id
ORDER BY n.primary_ip;