Discovery option to ignore existing hosts

mcam

One big pain point we have with scheduled discovery is that an automated subnet scan will refind all of the disks, network interfaces etc that we have already disabled - then renable the D*&^#$ed things.

Please allow scheduled discoveries to IGNORE EXISTING HOSTS

In its current form we have banned the use of subnet discoveries - its causes days of work to go back and re-disable all the disks and interface again.

This was a request a few years ago but got nowhere.

Feature Request - Delete Node and/or Interface with Discovery Ignore Option

michael.fusco

After each Discovery Scan, make an SQL Job that runs automatically with these three Steps.

IT will go thru the discovery results and automatically add interfaces and volumes to the "ignore list"

leaving ONLY the NEW interfaces and volumes.

Things to Change for YOUR database, EngineID (ours is 2, make yours based on Engine Table)

If you want to Add/Remove Interface/Volume Types, then you need to update BOTH Steps 1 and Step 2 or 3 where clauses.

Step1: Discovery Ignore Nodes

INSERT INTO DiscoveryIgnoredNodes (EngineID,IPAddress,Caption,IsIgnored,DateAdded)

select Distinct 2 as EngineID, IPAddress, DiscoveredNodes.SysName as Caption, 0 as IsIgnored, getDate() as DataAdded

From DiscoveredNodes

Inner Join DiscoveredInterfaces

On DiscoveredNodes.NodeID = DiscoveredInterfaces.DiscoveredNodeID and DiscoveredNodes.ProfileID = DiscoveredInterfaces.ProfileID

Where Not IPAddress In (Select IPAddress from DiscoveryIgnoredNodes) and not DiscoveredNodes.SysName is null

and NOT DiscoveredInterfaces.InterfaceType in (6,53,54,56,135,161,224,258) and DiscoveredInterfaces.Virtual = 1

or (DiscoveredInterfaces.InterfaceName like '%QoS%'

   or DiscoveredInterfaces.InterfaceName like '%WFP%'

   or DiscoveredInterfaces.InterfaceName like '%WAN%'

   or DiscoveredInterfaces.InterfaceName like '%NDIS VBD Client%'

   or DiscoveredInterfaces.InterfaceName like '%Bluetooth Device%'

   or DiscoveredInterfaces.InterfaceName like '%Lightweight Filter Driver%'

   or DiscoveredInterfaces.AdminStatus = 2

   or DiscoveredInterfaces.InterfaceType = 24)

INSERT INTO DiscoveryIgnoredNodes (EngineID,IPAddress,Caption,IsIgnored,DateAdded)

Select DISTINCT 2 as EngineID, IPAddress, DiscoveredNodes.SysName as Caption, 0 as IsIgnored, getDate() as DataAdded

From DiscoveredNodes

Inner Join DiscoveredVolumes

On DiscoveredNodes.NodeID = DiscoveredVolumes.DiscoveredNodeID and DiscoveredNodes.ProfileID = DiscoveredVolumes.ProfileID

where Not IPAddress In (Select IPAddress from DiscoveryIgnoredNodes) and not DiscoveredNodes.SysName is null

and ( DiscoveredVolumes.VolumeType IN (0,1,5,7)

   or DiscoveredVolumes.VolumeDescription like '%Swap Space%'

   or DiscoveredVolumes.VolumeDescription like '%Random Access Memory%'

   or DiscoveredVolumes.VolumeDescription like '%Real Memory%'

   or DiscoveredVolumes.VolumeDescription like '%Page%'

   or DiscoveredVolumes.VolumeDescription like '%Printer HDD%')

UPDATE DiscoveredNodes

SET IgnoredNodeID = DiscoveryIgnoredNodes.ID

FROM DiscoveryIgnoredNodes

Where DiscoveryIgnoredNodes.IPAddress = DiscoveredNodes.IPAddress and DiscoveredNodes.IgnoredNodeID is Null

Step 2: Discovery Ignored Interfaces

INSERT INTO DiscoveryIgnoredInterfaces (IgnoredNodeID, PhysicalAddress, Description, Caption, Type, IfxName, DateAdded)

Select DiscoveredNodes.IgnoredNodeID, DiscoveredInterfaces.PhysicalAddress, DiscoveredInterfaces.InterfaceName as Description, (DiscoveredInterfaces.InterfaceName + ' - ' + DiscoveredInterfaces.IfName) as Caption, DiscoveredInterfaces.InterfaceType as Type, DiscoveredInterfaces.IfName as IfxName, getdate() as DateAdded

From DiscoveredNodes

Inner Join DiscoveredInterfaces

On DiscoveredNodes.NodeID = DiscoveredInterfaces.DiscoveredNodeID and DiscoveredNodes.ProfileID = DiscoveredInterfaces.ProfileID

where not DiscoveredNodes.IgnoredNodeID is Null and DiscoveredInterfaces.IgnoredInterfaceID is null

and NOT DiscoveredInterfaces.InterfaceType in (6,53,54,56,135,161,224,258) and DiscoveredInterfaces.Virtual = 1

or (DiscoveredInterfaces.InterfaceName like '%QoS%'

   or DiscoveredInterfaces.InterfaceName like '%WFP%'

   or DiscoveredInterfaces.InterfaceName like '%WAN%'

   or DiscoveredInterfaces.InterfaceName like '%NDIS VBD Client%'

   or DiscoveredInterfaces.InterfaceName like '%Bluetooth Device%'

   or DiscoveredInterfaces.InterfaceName like '%Lightweight Filter Driver%'

   or DiscoveredInterfaces.AdminStatus = 2

   or DiscoveredInterfaces.InterfaceType = 24)

UPDATE DiscoveredInterfaces

SET IgnoredInterfaceID = Source.IgnoredInterfaceID

FROM

(SELECT DI.ProfileID, DI.DiscoveredNodeID, DI.InterfaceIndex, Di.InterfaceSubType, DII.ID as IgnoredInterfaceID

FROM DiscoveryIgnoredInterfaces as DII

JOIN DiscoveredNodes as DN

ON DII.IgnoredNodeID = DN.IgnoredNodeID

JOIN DiscoveredInterfaces as DI

ON DII.IFxName= DI.IfName and DII.Description = DI.InterfaceName and DN.ProfileID = DI.ProfileID and DN.NodeID= DI.DiscoveredNodeID

where DI.IgnoredInterfaceID is null) as Source

WHERE DiscoveredInterfaces.ProfileID = Source.ProfileID

and DiscoveredInterfaces.DiscoveredNodeID = Source.DiscoveredNodeID

and DiscoveredInterfaces.InterfaceIndex = source.InterfaceIndex

and DiscoveredInterfaces.InterfaceSubType = Source.InterfaceSubType

Step 3: Discovery Ignored Volumes

INSERT INTO DiscoveryIgnoredVolumes (IgnoredNodeID, Description, Type, DateAdded)

Select DiscoveredNodes.IgnoredNodeID, DiscoveredVolumes.VolumeDescription as Description, DiscoveredVolumes.VolumeType as Type, getdate() as DateAdded

From DiscoveredNodes

Inner Join DiscoveredVolumes

On DiscoveredNodes.NodeID = DiscoveredVolumes.DiscoveredNodeID and DiscoveredNodes.ProfileID = DiscoveredVolumes.ProfileID

where not DiscoveredNodes.IgnoredNodeID is Null and DiscoveredVolumes.IgnoredVolumeID is null

and ( DiscoveredVolumes.VolumeType IN (0,1,5,7)

   or DiscoveredVolumes.VolumeDescription like '%Swap Space%'

   or DiscoveredVolumes.VolumeDescription like '%Random Access Memory%'

   or DiscoveredVolumes.VolumeDescription like '%Real Memory%'

   or DiscoveredVolumes.VolumeDescription like '%Page%'

   or DiscoveredVolumes.VolumeDescription like '%Printer HDD%')

UPDATE DiscoveredVolumes

SET IgnoredVolumeID = Source.IgnoredVolumeID

FROM

(SELECT DI.ProfileID, DI.DiscoveredNodeID, DI.VolumeIndex, DII.ID as IgnoredVolumeID

FROM DiscoveryIgnoredVolumes as DII

JOIN DiscoveredNodes as DN

ON DII.IgnoredNodeID = DN.IgnoredNodeID

JOIN DiscoveredVolumes as DI

ON DII.Type = DI.VolumeType and DII.Description = DI.VolumeDescription and DN.ProfileID = DI.ProfileID and DN.NodeID= DI.DiscoveredNodeID

where DI.IgnoredVolumeID is null) as Source

WHERE DiscoveredVolumes.ProfileID = Source.ProfileID

and DiscoveredVolumes.DiscoveredNodeID = Source.DiscoveredNodeID

and DiscoveredVolumes.VolumeIndex = source.VolumeIndex