CSV File for import

[lhoyle]

I don't know if this has been discussed, but the File Import feature is actually a lot of work. I mean, I can create a CSV of my IP addresses by exporting from a third party monitoring tool, but I can't get the SN's with it. Why can't this "feature" be done with just IP addresses without SN's? After all, the discovery feature from a seed router gets the serial number for the devices; why do we need the SN as part of the import?

[npicard]

Hello, 

The device Product ID and Serial Numbers are the unique identifiers required to correlate your device data to the back-end Cisco databases that will return contract, warranty and alerts.

[Chris Camplejohn · Accepted solution]

Perhaps you have confused two topics.  The CSPC collector can take a list of IP Addresses and do discovery of the devices on your network, collect inventory and upload to the SNTC portal.  That gets you the most amount of data.  But for customers who cannot do that or want to add to their inventory additional devices, you can use the CSV import in the SNTC portal to add devices to your inventory.  Because that CSV import is the only information we would know about those devices, we need Serial Number.

[lhoyle]

OK, I see what you are talking about.

My problem is all of my remote switches (1000+) are set IP addresses in the local network (10.x.x.5, 10.x.x.6, 10.x.x.7, and 10.x.x.8). I can create a CSV file with all of those addresses, but I guess I cannot import that file into the Collector anywhere.

[D Kendz · Accepted solution]

The collector can still use the list of IPs garnered from your monitoring tool in order to make discovery and collection faster and more efficient.  This discovery method is preferred for most administrators over using a seed device and protocols, or allowing a sweep of the network. 

[lhoyle]

How do I import the CSV list of IP's into the collector? I don't see that option anywhere.

[Lynden Price · Accepted solution]

Go to Management > Discover and Manage Devices

Select the first option "Discover by known IP addresses"

Copy the column of IP addresses in Excel

Paste the IP addresses in the entry box. (It looks small but can hold all of the IPs)

Click the Add button

Click "Next", change your settings to the appropriate SNMP version and click "Finish"

Please let me know if that doesn't work of if you have any other questions.

Thanks,

Lynden

[lhoyle]

Thank you SO MUCH!

[Lynden Price]

You're welcome. Glad I could help!

-Lynden

[D Kendz]

I believe there is a limit to the number of IPs you can paste, but it is into the thousands. 

[Lynden Price]

You are correct, it's a very large number, although I'm not sure what that is off the top of my head.