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
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?
DiscoveryProfiles.Name as Discovery_Name,
DiscoveredNodes.SysName as Node_Name,
DiscoveryProfiles.EngineID as Poller,
DiscoveryProfiles.LastRun as LastRun
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.