cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted
Level 8

Re: Need a custom SQL report for discovery results

Hi there!

I'd like to bump this post once again as I am searching for the same information...

Maybe the Solarwinds tech staff could hook in and reveal how the new/changed/as-is information is calculated from the tables

Kind regards, Jörg

0 Kudos
Highlighted
Level 7

Re: Need a custom SQL report for discovery results

+1

It would be great to have a solution for this.

0 Kudos
Highlighted
Level 9

Re: Need a custom SQL report for discovery results

Thanks for the report, this is the best thing I have found and this was a post from five years ago!  Has there been any new developments around a built in report for this capability? 

0 Kudos
Highlighted
Level 9

Re: Need a custom SQL report for discovery results

is there a way to ignore any new discoveries that already been mark ignore  on this report ?

0 Kudos
Highlighted
Level 9

Re: Need a custom SQL report for discovery results

Select

DiscoveryProfiles.Name as Discovery_Name,

DiscoveredNodes.SysName as Node_Name,

Discoverednodes.IPAddress,

DiscoveryProfiles.EngineID as Poller,

DiscoveryProfiles.LastRun as LastRun

From DiscoveredNodes

Join DiscoveryProfiles on DiscoveredNodes.ProfileID = DiscoveryProfiles.ProfileID

Where IPAddress NOT IN (Select IP_Address from Nodes) AND

IPAddress Not in (Select IPAddress from NodeIPAddresses)

AND Sysname NOT IN (Select Caption from Nodes)

AND SysName NOT IN (Select DNS from Nodes)

AND IPAddress NOT IN (Select IPAddress from DiscoveryIgnoredNodes)

I was able ignore the ignore list on this report

0 Kudos