Here is the SQL query that reports on all subnets and show IP address status delta before and after subnet scan.
Customer can select specific subnet by name (uncomment last row or create more sophisticated condition). You can copy this into “custom SQL report” of ReportWriter.
NOTE: Suggest add there condition i.e. to filter that looks for scan performed in last 7 days as maximum history milestone:
..WHERE… subnet.[LastDiscovery] BETWEEN DATEADD(DAY, -7, GETDATE()) AND GETDATE()
