I'm writing a nifty script that obtains data from the Desktop Central MySQL database, and the table "resourcemacip" seems to have the data I want (mapping MAC addresses back to IP addresses). However, this data looks bad somehow. Check this out:
C:\ mysql -u root -P 23306 desktopcentral -h sentinel
mysql> SELECT * FROM resourcemacip WHERE IP_Address = "192.168.16.121";
RESOURCE_ID |
IP_ADDRESS |
MAC_ADDRESS |
4815 |
192.168.16.121 |
f:4d:a2:db:ea:5c |
1 row in set (0.00 sec)
("sentinel" is the server name on the LAN)
Notice the MAC address: f:4d:a2:db:ea:5c when in fact it should be f0:4d:a2:db:ea:5c -- it dropped the second 0 for some reason. What's weird about that one in particular is that last week I'm pretty sure it didn't drop that zero, and that computer in Desktop Central shows the 0 where it should be.
Now look:
mysql> select MAC_ADDRESS FROM resourcemacip;
MAC_ADDRESS |
:24:e8:2:f:1a |
:24:e8:2:11:a4 |
:24:e8:f:2:aa |
:25:64:9c:2:e9 |
:25:64:9c:2:f1 |
5c:ac:4c:65:25:25,f:4d:a2:7a:1b:3c |
:::f:4:24 |
:4:23:c2:79:82 |
EDIT (for clarification): This is just the top few MAC addresses of a very long list.
Look at those MAC addresses! Some have multiple, which I might understand since a different computer may claim an IP in a DHCP environment (maybe Desktop Central merges them for a while before dropping the old MAC?). But most are just missing digits altogether. They don't seem to be IPv6 addresses, either, so I don't really know what's up.
EDIT: I just went to a PC and compared its MAC address (obtained by "getmac" command in command prompt) to the Desktop Central table; Desktop Central turned 00:1A:A0:6C:ED:02 into :1A:A:6C:ED:2. So it's basically dropping ALL zeroes no matter where they are, which is NOT GOOD! "SHOW COLUMNS" on that table reveals it's storing MAC addresses as type "varchar(255)" so I don't see why it's doing this.
Is there a better table to figure out IP addresses from MAC addresses (or better yet, hostnames from MAC addresses)? Is there a way for me to drop and re-inventory the network to re-populate this table?
EDIT: In case it helps:
Product Information |
Product Name : |
ManageEngine Desktop Central 8 |
Product Version : |
8.0.0 |
Vendor : |
ZOHO Corp. |
Build Number : |
80114 |
Agent Version : |
8.1.13.W |
Mac Agent Version: |
8.1.12.M |
Distribution Server Version : |
8.1.12 |
|
System Information |
Host Name : |
Sentinel |
OS Name : |
Microsoft Windows Server 2008 R2 Standard |
OS Version : |
6.1 |
OS Architecture : |
x86
|
|
|
Database Information |
Database Type : |
mysql |
DataBase Host Name : |
localhost |
Logged-in User Name : |
root |
DataBase Version : |
5.0.44 |
DataBase Edition : |
enterprise-nt-log |
|