Bad Data in "resourcemacip" Table

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