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.11.1 available

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

ID unique for export

Are there some way the filter only mac ethernet physical computer, because there are computer a lot network....
in OCS Inventory NG server for Unix by (340 points)

4 Answers

0 votes
i don not get it .. what do you want do to ? filter on mac address? or do you want to filter only on apple computer's ?

Kind regards
by (23.1k points)
0 votes
Hello, Sokatra

Thanks for answer.

I need that each computer to be unique in other software, a field that help me in this is the field mac address, but there are computer with a lot number mac address. How Can I know what mac address ethernet  phisical
by (340 points)
0 votes

hy .. to identify a computer there is a field called Uuid:

But in old ocsinventory version the uui changes sometimes.

To distinguish physical network types from virtual ones, you can refer to the description.
But vmware or hyper-v cards all have a certain beginning in the first octet ... so you can identify the virtual cards too.

But why you don't take the name of a computer ? The name always should be unique in a network.

by (23.1k points)
0 votes

For MAC Address, 

you could get one with Inventory > Search with various criteria and choose 'Local/Networks' table, field 'MAC address'. (But you get only one MAC address ... for me in 2.6.0)

Using SQL, you can look table 'networks' : for example

select h.name, n.description, n.macaddr, n.status, n.ipaddress, n.ipmask

from hardware h, networks n

where h.id=n.hardware_id

With this sql query, you'll get all MAC address for each hardware (and only for hardware having a MAC address).

Please note MAC address could be forged, and maybe non unique (rare but exists for enormous set) ...

(For my company, we use linux firewall with vlan = on each interface (eth1.51 for vlan 51), this is the same MAC address from OCS agent, ... but same hostname. So I'm not sure the MAC address is an unique identifier !)

by (19.6k points)
edited by
Powered by Question2Answer