Send Netdot-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://osl.uoregon.edu/mailman/listinfo/netdot-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Netdot-users digest..."
Today's Topics:
1. prune_db.pl (Chip Pleasants)
2. Re: prune_db.pl (Carlos Vicente)
3. Re: prune_db.pl (Chip Pleasants)
4. Re: prune_db.pl (Carlos Vicente)
----------------------------------------------------------------------
Message: 1
Date: Tue, 4 Feb 2014 10:15:37 -0500
From: Chip Pleasants <[email protected]>
Subject: [Netdot-users] prune_db.pl
To: [email protected]
Message-ID:
<cajq5atqfdaa2jfiy1k1o7bs56kfqb76bbjoc7uzab4c5cyy...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hoping someone could provide some helpful tips. Is there a way see what IP
address blocks would get pruned using the script or any other way? I ran
the command below, but it didn't provide the information I was expecting. I
was expecting network 10.0.x.0/24 is older than 90 days therefore it would
get pruned. I looked at using the advanced sql commands but i'm not really
knowledgeable in sql commands. I appreciate any assistance.
/usr/local/netdot/bin/prune_db.pl -H -F -A -M -I -p -g -d 90
DEBUG - NUM_DAYS(90) ago was : 2013-11-06 10:05:33
DEBUG - Checking in backbonecable_history
DEBUG - Checking in cablestrand_history
DEBUG - Checking in circuit_history
DEBUG - Checking in contact_history
DEBUG - Checking in device_history
DEBUG - Checking in entity_history
DEBUG - Checking in interface_history
DEBUG - interface_history record 91 has 101 history items. Deleting records
from before 2013-11-06 10:05:33
DEBUG - interface_history record 740 has 102 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 3109 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 3691 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 4995 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 6043 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 6146 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 6498 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 9001 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 9562 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 9860 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 11374 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 13323 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 13366 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 13677 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 14408 has 102 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 15341 has 216 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 15343 has 216 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 15808 has 129 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 15809 has 129 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 15975 has 158 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16151 has 158 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16233 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16314 has 159 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16376 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16429 has 101 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16466 has 158 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16477 has 158 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16504 has 158 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16965 has 317 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16971 has 306 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 16976 has 317 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17260 has 307 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17261 has 192 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17262 has 192 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17263 has 307 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17434 has 311 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17473 has 192 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17645 has 194 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17723 has 310 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17814 has 307 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17816 has 307 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17819 has 194 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - interface_history record 17821 has 200 history items. Deleting
records from before 2013-11-06 10:05:33
DEBUG - Checking in person_history
DEBUG - Checking in product_history
DEBUG - Checking in site_history
DEBUG - Checking in sitelink_history
DEBUG - Checking in vlangroup_history
INFO - Deleting Forwarding Tables older than 2013-11-06 10:05:33
DEBUG - Freeing deleted space in fwtableentry
INFO - Deleting ARP Caches older than 2013-11-06 10:05:33
DEBUG - Freeing deleted space in arpcacheentry
INFO - /usr/local/netdot/bin/prune_db.pl total runtime: 8 sec
Thanks,
Chip
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140204/50f1de83/attachment-0001.html
------------------------------
Message: 2
Date: Tue, 4 Feb 2014 10:17:41 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] prune_db.pl
To: Chip Pleasants <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=iso-8859-1
Hi Chip,
The script today does not remove IP blocks, only addresses.
cv
On Feb 4, 2014, at 10:15 AM, Chip Pleasants <[email protected]> wrote:
> Hoping someone could provide some helpful tips. Is there a way see what IP
> address blocks would get pruned using the script or any other way? I ran
> the command below, but it didn't provide the information I was expecting. I
> was expecting network 10.0.x.0/24 is older than 90 days therefore it would
> get pruned. I looked at using the advanced sql commands but i'm not really
> knowledgeable in sql commands. I appreciate any assistance.
>
> /usr/local/netdot/bin/prune_db.pl -H -F -A -M -I -p -g -d 90
------------------------------
Message: 3
Date: Tue, 4 Feb 2014 11:03:44 -0500
From: Chip Pleasants <[email protected]>
Subject: Re: [Netdot-users] prune_db.pl
To: Carlos Vicente <[email protected]>
Cc: [email protected]
Message-ID:
<cajq5atrh5josozpmoahcljkaapokezpcx72cgm2sgufuubz...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
To make sure I understand. Addresses are pruned within IP blocks, that have
not been updated/reached after updatedevices.pl in 90 days or some amount
of time? Do does it matter if they are Static or Discovered addresses?
Thanks for the quick response!
-Chip
On Tue, Feb 4, 2014 at 10:17 AM, Carlos Vicente <[email protected]>wrote:
> Hi Chip,
>
> The script today does not remove IP blocks, only addresses.
>
> cv
>
> On Feb 4, 2014, at 10:15 AM, Chip Pleasants <[email protected]> wrote:
>
> > Hoping someone could provide some helpful tips. Is there a way see what
> IP address blocks would get pruned using the script or any other way? I
> ran the command below, but it didn't provide the information I was
> expecting. I was expecting network 10.0.x.0/24 is older than 90 days
> therefore it would get pruned. I looked at using the advanced sql commands
> but i'm not really knowledgeable in sql commands. I appreciate any
> assistance.
> >
> > /usr/local/netdot/bin/prune_db.pl -H -F -A -M -I -p -g -d 90
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://osl.uoregon.edu/pipermail/netdot-users/attachments/20140204/3c9a96d0/attachment-0001.html
------------------------------
Message: 4
Date: Tue, 4 Feb 2014 13:52:58 -0500
From: Carlos Vicente <[email protected]>
Subject: Re: [Netdot-users] prune_db.pl
To: Chip Pleasants <[email protected]>
Cc: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=windows-1252
Correct. Addresses (not blocks) are deleted if they have not been ?seen?, which
means, not found in ARP tables nor created/modified in the given number of days.
Both ?Discoverd? and ?Static? addresses are considered.
cv
On Feb 4, 2014, at 11:03 AM, Chip Pleasants <[email protected]> wrote:
> To make sure I understand. Addresses are pruned within IP blocks, that have
> not been updated/reached after updatedevices.pl in 90 days or some amount of
> time? Do does it matter if they are Static or Discovered addresses? Thanks
> for the quick response!
>
> -Chip
>
>
>
> On Tue, Feb 4, 2014 at 10:17 AM, Carlos Vicente <[email protected]> wrote:
> Hi Chip,
>
> The script today does not remove IP blocks, only addresses.
>
> cv
>
> On Feb 4, 2014, at 10:15 AM, Chip Pleasants <[email protected]> wrote:
>
> > Hoping someone could provide some helpful tips. Is there a way see what IP
> > address blocks would get pruned using the script or any other way? I ran
> > the command below, but it didn't provide the information I was expecting. I
> > was expecting network 10.0.x.0/24 is older than 90 days therefore it would
> > get pruned. I looked at using the advanced sql commands but i'm not really
> > knowledgeable in sql commands. I appreciate any assistance.
> >
> > /usr/local/netdot/bin/prune_db.pl -H -F -A -M -I -p -g -d 90
>
>
------------------------------
_______________________________________________
Netdot-users mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-users
End of Netdot-users Digest, Vol 63, Issue 1
*******************************************
