Welcome to OCS Inventory NG community support, where you can ask questions and receive answers from other members of the community.

Please ask questions only in English or French.

Release 2.6 available

The official documentation can be found on http://wiki.ocsinventory-ng.org. Read it before asking your question.

identified peripherals duplicated

Dear Guys,

when I identify peripheral devices it shows correctly at IpDiscover screen, however it shows duplicated when I click that number. Attached screenshot to clarify what I am saying

Debug mode:

MariaDB [ocsweb]> SELECT SQL_CALC_FOUND_ROWS n.ID,n.TYPE,n.DESCRIPTION,a.IP,a.MAC,a.MASK,a.NETID,a.NAME,a.date,n.USER from network_devices n LEFT JOIN netmap a ON a.mac=n.macaddr where netid='10.10.0.0' order by TYPE asc limit 0 , 10;

+----+--------+---------------+------------+-------------------+-------------+-----------+------------+---------------------+-------+
| ID | TYPE   | DESCRIPTION   | IP         | MAC               | MASK        | NETID     | NAME       | date                | USER  |
+----+--------+---------------+------------+-------------------+-------------+-----------+------------+---------------------+-------+
|  1 | SWITCH | 3Com 5500G-EI | 10.10.5.20 | 00:1A:C1:41:10:01 | 255.255.0.0 | 10.10.0.0 | 10.10.5.20 | 2016-04-13 08:52:14 | admin |
|  2 | SWITCH | 3Com 5500G-EI | 10.10.5.20 | 00:1A:C1:41:10:01 | 255.255.0.0 | 10.10.0.0 | 10.10.5.20 | 2016-04-13 08:52:14 | admin |
+----+--------+---------------+------------+-------------------+-------------+-----------+------------+---------------------+-------+
2 rows in set (0.00 sec)

Helio Paixao

in OCS Inventory NG server for Unix by (380 points)
edited by

2 Answers

0 votes
Hi,

If you can add your informations about this bug here it would be nice : https://github.com/OCSInventory-NG/OCSInventory-ocsreports/issues/73

Regards, Gilles Dubois.
by (2.9k points)
0 votes

Dear guys,

I have tryed to delete an item and have found that it is not deleted because mac and macaddr has additional text " (IBM)"

DELETE FROM netmap WHERE mac='40:F2:E9:63:3C:44 (IBM)'
DELETE FROM network_devices WHERE macaddr='40:F2:E9:63:3C:44 (IBM)'

errodelete

I think the correct should be

DELETE FROM netmap WHERE mac='40:F2:E9:63:3C:44'
DELETE FROM network_devices WHERE macaddr='40:F2:E9:63:3C:44'

Helio Paixao

by (380 points)
Hi,

This has been fixed on the 2.2 master -> https://github.com/OCSInventory-NG/OCSInventory-ocsreports/issues/44

Regards,

Gilles Dubois.
 
Powered by Question2Answer
...