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 #
_________________ Server Info: running on a CentOS 7 vm OA Version: 2.0.6 @ 500 devices
|