I've heard couple of times that you - our users - would like to run a report that can show you IP Addresses that have been "added" recently.
This report is not out of the box built in default installation of IPAM, but you can add it via custom SQL report query:
This SQL query will show you all IP addresses in last three dates that were changed from the status "available" to "used" or "reserved". You can change time period in highlighted part below.
Note: remove comment last row, if you want to see also IP addresses that were never scanned in case you want to see user or reserved IP addresses added manually (like import) - edge case, but could be useful.
SELECT
record.[IPAddress] AS 'IP Address',
subnet.[FriendlyName] AS 'Subnet',
record.[change] AS 'Time',
record.[time] AS 'Last Scan'
FROM
(
SELECT
ip.[SubnetId],
ip.[IPAddress],
ip.[LastSync] AS [time],
(
SELECT MAX(h.[Time])
FROM [dbo].[IPAM_IPHistory] h
WHERE h.[HistoryType]=1 AND h.[IntoValue] IN ('Used', 'Reserved') AND h.[IPNodeId]=ip.[IPNodeId]
) AS [change]
FROM [dbo].[IPAM_Node] AS ip
WHERE ip.[Status] IN (1, 4) -- Status => Used or Reserved
) AS record
LEFT JOIN [dbo].[IPAM_Group] subnet ON record.[SubnetId] = subnet.[GroupId]
WHERE record.[change] BETWEEN DATEADD(DAY, -3, GETDATE()) AND GETDATE()
-- OR record.[change] IS NULL -- (uncomment for never scanned IP addresses)
