Send Netdot-devel mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        https://osl.uoregon.edu/mailman/listinfo/netdot-devel
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-devel digest..."


Today's Topics:

   1. interface number='0' (Karl Putland)


----------------------------------------------------------------------

Message: 1
Date: Mon, 10 Sep 2012 14:02:48 -0600
From: Karl Putland <[email protected]>
Subject: [Netdot-devel] interface number='0'
To: [email protected]
Message-ID:
        <ca+exwsz7p5sgjdijzwuflx+9k9zdvtpgsmxmowhztf4htxr...@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

I don't have a cause yet, but I get a lot of interface number='0' and have
to delete them.
The updatedevices.pl has issues with the excessive number, or creates
them...

I did it by hand once :/

postgres=# \c netdot
You are now connected to database "netdot" as user "postgres".
netdot=# delete from interface_history where interface_id in (select id
from interface where number = '0' and doc_status = 'removed');
DELETE 376
netdot=# delete from interface where number = '0' and doc_status =
'removed';
DELETE 188
netdot=#



--Karl

Karl Putland
Senior VoIP Engineer

*SimpleSignal*
3600 S Yosemite, Suite 150
Denver, CO 80237
One Number Rings All My Phones: 303-242-8608

SimpleSignal.com <http://www.simplesignal.com/> |
Blog<http://www.simplesignal.com/blog>
 | Facebook <http://www.facebook.com/SimpleSignal?ref=ts> |
Twitter<http://twitter.com/simplesignal>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://osl.uoregon.edu/pipermail/netdot-devel/attachments/20120910/e72f604c/attachment-0001.html
 

------------------------------

_______________________________________________
Netdot-devel mailing list
[email protected]
https://osl.uoregon.edu/mailman/listinfo/netdot-devel


End of Netdot-devel Digest, Vol 66, Issue 8
*******************************************

Reply via email to