I have the Analytics and Applications DB's for my Jive users. I would like to know the geographic breakdown of all users based on IP and also to see what other information we gleam from their browser/machine data, such as MAC addresses and any other ID's, perhaps from Jive's cookies.
I see IP in the jivecomments table in the Application Database. Most of those seem to resolve to my own company, so either its not the IP address of the users' computers, or perhaps I just got a bad sample of internal/admin users. Is there any more data like this?