Re^3: using perl for arp collection

I will be happy to share the Database structure, and related perl module with you - the Database is SQLServer, and the module handles the ODBC interface to a table named "ARP". I am not sure if this is appropriate for your environment.

There is anothere script which scans the WINS database and populates device Names.

Please /msg me with your e-mail address, so I can send it to you.

Here is the layout of the ARP table:

Table: dbo_ARP                                                        
+                               Page: 1



Properties

Attributes:               Linked                      Connect:        
+          ODBC;DSN=
                                                                      
+          HardwareDB;
                                                                      
+          APP=Microso
                                                                      
+          ft Office
                                                                      
+          2003;WSID=
DateCreated               11/17/2004                  DefaultView:    
+          Datasheet

GUID:                     {guid                       LastUpdate      
+          11/17/2004
                          {76707E89-
NameMap:                  Long binary                 OrderByOn:      
+          False
Orientation:              Left-to-Right               RecordCoun      
+          -1

SourceTabl                dbo.ARP                     Updatable:      
+          False



Columns

         Name                                                  Type   
+                     Size

         ID                                                    Long In
+teger                             4
         Mac                                                   Text   
+                                 12
         IP                                                    Text   
+                                 15

         User                                                  Text   
+                                 16
         HostName                                              Text   
+                                 25
         SwitchName                                            Text   
+                                 15

         SwitchPortIdx                                         Long In
+teger                             4
         SwitchPortName                                        Text   
+                                 10
         HostType                                              Text   
+                                 25

         Notes                                                 Text   
+                                255
         UpstreamID                                            Long In
+teger
[download]

Earth first! (We'll rob the other planets later)

Comment on Re^3: using perl for arp collection Download Code