MAC Address for Nodes

I would think that this information might be the asset information tables (Maybe). I say this only because if you have your npm gathering asset details on your devices MAC addresses I believe maybe part of it. Not sure exactly what table that would be. Maybe someone else can elaborate a little further here, and help you find the table you need.

Also, I just realized when you say mac address of a node ... do you mean it's serial number? Only MAC addresses I'm familiar with are on the NIC's.

^ this, nodes don't have MAC addresses, network interfaces do, as they are a part of the networking protocol.  Sometimes people treat a device as having only one MAC because in a simple sense a workstation often only has 1 network port built into it so it only has 1 MAC, but most servers have multiple nics, and at the server level you are often even going to have virtual/logical objects on top of those with additional MAC's.

Exactly!! Took me reading this post twice to realize....NIC's have MAC addresses. Systems have Serial numbers. But either way asset inventory should be the best to get either of these data points. Wouldn't you say?

Thank you guys for your insight !! ... I dont see a asset table in my database. I think I should rephrase my question. I am looking to get an inventory of all devices with their IP and Macs. (if they have one)

mesverrum​ correct me if I'm wrong but the table wouldn't be there unless asset inventory is actually checked on the devices being monitored correct?

SWQL:

Select N.Caption, N.IP_Address, N.Interfaces.PhysicalAddress

from orion.Nodes N

SQL:

SELECT N.Caption, N.Ip_Address, I.PhysicalAddress

  FROM [dbo].[Interfaces] I

  Join dbo.nodes N on I.NodeID=N.NodeID

Yeah, asset inventory is optional, but the NodesMacAddress table is pretty reliable even when no inventory is being collected.