Open-AudIT
https://www.open-audit.org/phpBB3/

list computer by mac address
https://www.open-audit.org/phpBB3/viewtopic.php?f=5&t=3117
Page 1 of 1

Author:  little_crazzy [ Fri Jan 09, 2009 5:39 am ]
Post subject:  list computer by mac address

Hi users! this is a great open source software! The better!!
I need to add a column in the "list all system" that show me the mac address and permit to search by a mac address.
Someone know how to do it ???
THZ

Author:  shanimal [ Fri Jun 19, 2009 11:42 pm ]
Post subject:  Re: list computer by mac address

I'm not sure how to change the PHP code to display this on the site, but this is how I would accomplish the task:

Using MySQL Query Browser 1.2.17 I connect to the openaudit schema and run the following query:

[code]SELECT n.`net_dns_host_name`, n.`net_mac_address` FROM network_card n;[/code]

Now: File --> Export resultsset --> Save as CSV file

This CSV file will have 2 columns, one with the computers' DNS name, and one with the MAC addresses of that computer.

with the CSV file you can sort and search with Excel. I create files like this for the finance department occasionally.
They are always interested in the serial #'s which they can match up to invoices which usually include the system serial #

Page 1 of 1 All times are UTC + 10 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/