Jump to content
Dan_PH

Report (or Dataview) showing all NICs and MAC Addresses

Recommended Posts

I'm trying to find a way to export a list of all NICs and their MAC Addresses present on a computer, and the default reports and dataviews only seem to show one for each computer.  Is there an easy way to get this information out of Automate?  If it helps, I have access to the custom Dataview Creator.  Thanks in advance!

Share this post


Link to post
Share on other sites

If you are able to , check MySQL and look at the table inv_networkcard and do a join with table computers.

SELECT
computers.name ,
inv_networkcard.computerID ,
inv_networkcard.mac ,
inv_networkcard.ipaddress ,
inv_networkcard.ipv6 ,
inv_networkcard.description  
FROM inv_networkcard
LEFT JOIN computers ON (computers.computerid=inv_networkcard.computerid)
Where #Insert search criteria here#
ORDER BY computers.name

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...