CSV Import devices
HI Gurus.
I would like to import a bulk device list , including username and password, can someone that has done this before help me with the format of the csv please, I have tried ip,displayname,properties but the properties is not working properly, its taking the entire properties as a value
Thanks for any help
Guaro55551
Posted 1 year ago·Last reply 1 year ago
1 comment
Patrick Anderer
·1 year agoWhen creating the CSV files for Netscans, the required headers are as follows
IP,displayname,hostgroup,properties
It may not be immediately clear, but there are only 4 total columns you'll use for these imports and all 4 columns are required. All of the desired properties you want to apply to a given device must exist in that 4th "properties" column.
In our netscan documentation here https://www.logicmonitor.com/support/creating-netscans we even have some examples of lines. You'll notice that the properties entries are encased in double quotes with the format of the "prop.one=firstproperty prop.two=secondproperty" with each pair being space delimited.
Depending on the spreadsheet editor you're using, you can combine the columns beyond the 4th into that singular column using a CONCATENATE or similar function. For MS Excel they document it here https://support.microsoft.com/en-us/office/concat-function-9b1a9a3f-94ff-41af-9736-694cbd6b4ca2 . This will allow you to format that "properties" column with multiple properties and values as well as including the needed double quotes around here.