I am finding a dearth of information on IPAM, which I find odd as I consider IP address space management to be an essential aspect of network management. At any rate I find myself doing a lot of work right now to extract relevant information so we can better manage our address space effectively, as it has been a bit neglected. I find one of the most prevalent issue are IPAM Reservations that never get used. Note that I am only working with IPAM reservations here, not DHCP reservations.
I created this report to capture manual IP status changes from the past 90 days as a first pass on getting a handle on this issue. I have used an export of this report as an import source to track these changes within IPAM; specifically, assigning the User and Timestamp to custom properties assigned directly to the IP address. I may ultimately make a few changes, like dropping those addresses that are currently set to 'Available' and only grabbing the most recent entry for an address so there isn't any duplication. I already have a SWQL script that includes these changes, but here I was interested to see what I could do from directly inside the report editor.
I would love to automate this process; I already have tested extracting the information via the API, but I don't think there is a way to import the data into the custom properties via API; at least, I haven't found it. If someone wants to show their brilliance by enlightening me on that aspect, I would be very happy. :)
