|list computer by mac address
|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 ???
|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:
SELECT n.`net_dns_host_name`, n.`net_mac_address` FROM network_card n;
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