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/ |