What exactly are you trying to produce? An entry for each IP or a single entry containing all the IPs?
I'm looking for an entry for each IP, the Exporter is giving a error for more than one IP for each NetworkInterface. The Export stops first time it meet a NetworkInterface with more than one IP's like this:10.190.111.168, 10.190
A small version of the Query:
interface_name as 'Interface Name',
#InterfaceOfDevice:DeviceInterface:DeviceWithInterface:Host.name as 'Host Name',
#InterfaceWithAddress:InterfaceAddress:IPv4Address:IPAddress.ip_addr as 'Host Name IPv4'
Give this result:
Interface Name Host Name Host Name IPv4 net01 XXXXXX-XXX ['XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX'] net02 XXXXXX-XXX ['XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX'] net03 XXXXXX-XXX ['XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX'] net04 XXXXXX-XXX ['XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX', 'XX.XXX.XXX.XXX']
And this multiple IP's is stopping my Export with the error:
ERROR The mapping exited with an error
com.tideway.integrations.cmdbexport.transform.TransformException: A problem
occurred while transforming: Collection CI's fields have differing numbers of
values. Expected 1 values, but field Host Name IPv4 has 2.
Can anyone help me get one line for each IP ??
2 of 2 people found this helpful
What entries are you trying to generate? A single table with this? If so then adding an explode to the IPv4Address key expression may do what you want.
Thanks, it solved one issues, but now when the interface not have an IP it is dropped. As I understand that’s the way it is, so how can I find for all the interfaces in the Query with "Not set" and the value "No address" when showing the server Network Interfaces:
No name No address XX:b1:XX:b5:XX:XX
I did try different ways to search but not the right result.
So when you said a line for each IP that was not really what you were after at all?
In your export you are just wanting NetworkInterfaces? Just in a single table?
I want a list of all the Network Interfaces for all the servers with or without IP's one entry for each cell due to else Export fail.