Solved

Adding devices to logpoint with CSV

  • 25 September 2021
  • 4 replies
  • 215 views

Hi

I have 70+ devices  to add to logpoint for monitoring.     The version of Logpoint is 6.7.4.

I dont want to key them in with the GUI (takes too long, risks of mistakes).   I have the device details in a spreadsheet - extracting to a csv and loading the csv into logpoint with the UI is the best way.

 

The device uses a proxy

 

I have followed the documentation  - but perhaps I’ve misread something.

 

The CSV line below gives the error “Exception, Nonetype object has no attribute split”

 

device_name,device_ips,device_groups,log_collection_policies, distributed_collector,confidentiality,integrity,availability,timezone,uses_proxy, proxy_ip, hostname, processpolicy
device1,10.0.0.1,linux,,,,,,Europe/London,TRUE,192.168.1.1,10.0.0.1,Linux

 

 

 

 

I can add devices without issue if I remove the last 4 fields from the csv  (i.e. uses_proxy, proxy_ip, hostname, processpolicy),  but i do want to add the syslog collector details.

Does anyone know if the add devices with a csv actually works when you want to also add the syslog collector ?

 

Thanks

Patrick Kelly

 

Note: my question doesnt fit into any of the predefined categories, I have to put it into Operations Monitoring.

 

icon

Best answer by HansHenrikMoerkholt 27 September 2021, 11:08

View original

4 replies

Userlevel 2
Badge +1

Hi

Have you added the device which you want to use as syslog proxy and selected the ‘use as proxy’ for this device ??

 

Thanks Hans

Yes absolutely  -    the device i want to use as a syslog proxy is indeed set up “use as proxy”

 

We have no problem setting our devices with the UI.

It’s only when we try to use the CSV that we run into problems.

 

I think the problem perhaps could be really fundamental, perhaps the header is not quite right or something

 

device_name,device_ips,device_groups,log_collection_policies, distributed_collector,confidentiality,integrity,availability,timezone,uses_proxy, proxy_ip, hostname, processpolicy
 

It looks right according to the documentation

 

Perhaps other customers don’ t use this csv interface   ?  Could it be that it just doesn’t work an nobody cares ?

The interface does work when you remove the last 4 fields,  but I want the last 4 fields !

 

thanks

Patrick

 

 

 

 

Userlevel 2
Badge +1

Hi Patrick

inspecting the 2 lines:

device_name,device_ips,device_groups,log_collection_policies,distributed_collector,confidentiality,integrity,availability,timezone,uses_proxy,proxy_ip,hostname,processpolicy
device1,10.0.0.1,linux,,,,,,Europe/London,TRUE,192.168.1.1,10.0.0.1,Linux
 

I could see that there was some inconsistency, as for some fields there were a ‘space’ after the comma, and for others there were not.

Please ensure that there is no space.

another thing unless you use the fields confidentiality, integrity and availability you do not need to have them in the import file

 

Hans is correct.

 

The problem was that the logpoint code does not like whitespace in the header line of the csv.

I should have guessed this !

I think if I was programmer I might have the code ignore whitespace in the csv header line,  although if I had time constraints, I might not bother !

 thanks

Reply