I recently ran a discovery using a list of 367 IP addresses. The discovery yielded 295 responding IPs. How can I create a report that will show me scanned IPaddresses that did not respond to polling?
Thanks for the assistance.
-
-
-
Hello,
The easiest solution would be create table with list of your ipadresses under SolarwindsDatabase.
You can use MSSQL managment studio, it is free and you can use UI. After creating IP table you can create SQL report under webbased reporting or in Report writer.
1. Create Table for example: Myips
2. Via Managment Studio import your list of IPs to "MyIps" table (Right click to database > importdata -> go through wizard)
3. Run your discovery.
4. Create SQL report with this query:
SELECT I.[ip_adress]
FROM [dbo].[myips] as I LEFT JOIN DiscoveredNodes as D on i.ip_adress=D.IPAddress
WHERE D.IPAddress is NULL
5. You will see all IPs which are not discovered by NPM.
If you have any question don't hesitate to ask.