Hi Jay
Thanks for the reply. I’ve run the output to file. I realise that I did this on a different table but the results are the same. Interestingly, if I read the output correctly it seems Telegraf is in fact reading the entire table but for some reason only 1 line appears in the InfluxDB. I’ve redacted some info and have not pasted the entire output. It’s pretty much 160 odd lines of the same then it loops again (I assume on the next query run).
aruba_controllers,agent_host=10.255.0.20,host=xxxx.example.com SysExtSwVersion="8.6.0.9",Sys_Name="Aruba7210-xxxxx",CpuUsedPercent=21i,MemoryUsedPercent=45i,Sys_Description="ArubaOS (MODEL: Aruba7210), Version 8.6.0.9 (xxxxxxx)" 1646137111000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPIpAddress="10.196.233.114",wlanAPSerialNumber="xxxxxxx",wlanAPMeshRole=0i,wlanAPActiveUplink=1i,wlanAPSwitchIpAddress="10.255.0.20",wlanAPModel=".1.3.6.1.4.1.14823.1.2.102",wlanAPNumBootstraps=15i,wlanAPHwVersion="A1.0",wlanAPNumWarmReboots=1i,wlanAPStandbyIpAddress="0.0.0.0",wlanAPConnectedAsDatazone=0i,wlanAPNumRadios=2i,wlanAPIpsecMode=2i,wlanAPName="HF4160-13-5",wlanAPGroupName="controller.example.com.",wlanAPBuilding=0i,wlanAPNumReboots=11i,wlanAPRemoteLanIpAddress="10.196.233.114",wlanAPdot11gAntennaGain=0i,wlanAPEnet1Mode=1i,wlanAPUpTime=2455100i,wlanAPConnectedAsStandby=0i,wlanAPdot11aAntennaGain10x=255i,wlanAPModelName="535",wlanAPExternalAntenna=1i,wlanAPSwVersion="8.6.0.9",wlanAPOuterIpAddress="0.0.0.0",wlanAPdot11gAntennaGain10x=255i,wlanAPDual5GMode=3i,wlanAPLocation="Not Available",wlanAPFloor=0i,wlanAPLoc=0i,wlanAPFlexRadioMode=4i,wlanAPActiveIpAddress="10.196.233.114",wlanAPdot11aAntennaGain=0i,wlanAPStatus=1i,wlanAPUnprovisioned=2i,wlanAPMonitorMode=2i,wlanAPSplit5GMode=3i 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPGroupName="controller.example.com",wlanAPFloor=0i,wlanAPNumBootstraps=6i,wlanAPActiveIpAddress="10.196.40.189",wlanAPdot11aAntennaGain=0i,wlanAPSwVersion="8.6.0.9",wlanAPFlexRadioMode=4i,wlanAPdot11aAntennaGain10x=255i,wlanAPdot11gAntennaGain10x=255i,wlanAPIpAddress="10.196.40.189",wlanAPStatus=1i,wlanAPMonitorMode=2i,wlanAPActiveUplink=1i,wlanAPDual5GMode=3i,wlanAPModelName="225",wlanAPUnprovisioned=2i,wlanAPConnectedAsDatazone=0i,wlanAPBuilding=0i,wlanAPRemoteLanIpAddress="10.196.40.189",wlanAPModel=".1.3.6.1.4.1.14823.1.2.59",wlanAPLocation="Not Available",wlanAPNumWarmReboots=0i,wlanAPOuterIpAddress="0.0.0.0",wlanAPConnectedAsStandby=0i,wlanAPSplit5GMode=3i,wlanAPEnet1Mode=1i,wlanAPLoc=0i,wlanAPHwVersion="A1.0",wlanAPSwitchIpAddress="10.255.0.20",wlanAPExternalAntenna=1i,wlanAPNumReboots=2i,wlanAPName="HF4228-3-16",wlanAPSerialNumber="xxxxxxx",wlanAPdot11gAntennaGain=0i,wlanAPNumRadios=2i,wlanAPIpsecMode=2i,wlanAPUpTime=56845100i,wlanAPMeshRole=0i,wlanAPStandbyIpAddress="0.0.0.0" 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPNumWarmReboots=0i,wlanAPActiveIpAddress="10.196.41.251",wlanAPGroupName="example.com",wlanAPNumRadios=2i,wlanAPMeshRole=0i,wlanAPdot11aAntennaGain=0i,wlanAPLoc=0i,wlanAPConnectedAsDatazone=0i,wlanAPdot11aAntennaGain10x=255i,wlanAPUpTime=1037559100i,wlanAPStatus=1i,wlanAPOuterIpAddress="0.0.0.0",wlanAPMonitorMode=2i,wlanAPFlexRadioMode=4i,wlanAPIpAddress="10.196.41.251",wlanAPSerialNumber="xxxxxxxx",wlanAPNumReboots=1i,wlanAPActiveUplink=1i,wlanAPSwitchIpAddress="10.255.0.20",wlanAPStandbyIpAddress="0.0.0.0",wlanAPModel=".1.3.6.1.4.1.14823.1.2.48",wlanAPModelName="135",wlanAPFloor=0i,wlanAPLocation="Not Available",wlanAPSwVersion="8.6.0.9",wlanAPDual5GMode=3i,wlanAPUnprovisioned=2i,wlanAPRemoteLanIpAddress="10.196.41.251",wlanAPdot11gAntennaGain10x=255i,wlanAPName="HF4228-6-7",wlanAPEnet1Mode=1i,wlanAPExternalAntenna=1i,wlanAPNumBootstraps=5i,wlanAPHwVersion="A1.0",wlanAPConnectedAsStandby=0i,wlanAPSplit5GMode=3i,wlanAPdot11gAntennaGain=0i,wlanAPIpsecMode=2i,wlanAPBuilding=0i 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPHwVersion="A1.0",wlanAPActiveUplink=1i,wlanAPNumReboots=1001i,wlanAPModel=".1.3.6.1.4.1.14823.1.2.102",wlanAPdot11gAntennaGain=0i,wlanAPIpsecMode=2i,wlanAPNumBootstraps=7i,wlanAPUnprovisioned=2i,wlanAPNumWarmReboots=1i,wlanAPdot11aAntennaGain10x=255i,wlanAPGroupName="controller.example.com.",wlanAPUpTime=2455100i,wlanAPStatus=1i,wlanAPConnectedAsStandby=0i,wlanAPBuilding=0i,wlanAPLoc=0i,wlanAPOuterIpAddress="0.0.0.0",wlanAPEnet1Mode=1i,wlanAPSplit5GMode=3i,wlanAPSerialNumber="xxxxxx",wlanAPdot11aAntennaGain=0i,wlanAPNumRadios=2i,wlanAPIpAddress="10.196.233.77",wlanAPMonitorMode=2i,wlanAPdot11gAntennaGain10x=255i,wlanAPSwitchIpAddress="10.255.0.20",wlanAPStandbyIpAddress="0.0.0.0",wlanAPConnectedAsDatazone=0i,wlanAPFlexRadioMode=4i,wlanAPDual5GMode=3i,wlanAPModelName="535",wlanAPMeshRole=0i,wlanAPSwVersion="8.6.0.9",wlanAPActiveIpAddress="10.196.233.77",wlanAPExternalAntenna=1i,wlanAPRemoteLanIpAddress="10.196.233.77",wlanAPName="HF4160-4-1",wlanAPLocation="Not Available",wlanAPFloor=0i 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPSerialNumber="xxxxx",wlanAPNumBootstraps=15i,wlanAPNumWarmReboots=1i,wlanAPSwitchIpAddress="10.255.0.20",wlanAPConnectedAsDatazone=0i,wlanAPModel=".1.3.6.1.4.1.14823.1.2.102",wlanAPdot11gAntennaGain=0i,wlanAPModelName="535",wlanAPLocation="Not Available",wlanAPBuilding=0i,wlanAPLoc=0i,wlanAPHwVersion="A1.0",wlanAPActiveIpAddress="10.196.233.132",wlanAPIpAddress="10.196.233.132",wlanAPMonitorMode=2i,wlanAPGroupName="controller.example.com.",wlanAPExternalAntenna=1i,wlanAPSwVersion="8.6.0.9",wlanAPConnectedAsStandby=0i,wlanAPEnet1Mode=1i,wlanAPOuterIpAddress="0.0.0.0",wlanAPStandbyIpAddress="0.0.0.0",wlanAPdot11aAntennaGain10x=255i,wlanAPFloor=0i,wlanAPRemoteLanIpAddress="10.196.233.132",wlanAPActiveUplink=1i,wlanAPSplit5GMode=3i,wlanAPNumReboots=11i,wlanAPUpTime=2455100i,wlanAPStatus=1i,wlanAPUnprovisioned=2i,wlanAPFlexRadioMode=4i,wlanAPNumRadios=2i,wlanAPdot11aAntennaGain=0i,wlanAPIpsecMode=2i,wlanAPMeshRole=0i,wlanAPdot11gAntennaGain10x=255i,wlanAPDual5GMode=3i,wlanAPName="HF4160-10-1" 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPConnectedAsStandby=0i,wlanAPConnectedAsDatazone=0i,wlanAPdot11gAntennaGain10x=255i,wlanAPDual5GMode=3i,wlanAPSplit5GMode=3i,wlanAPFloor=0i,wlanAPdot11gAntennaGain=0i,wlanAPLoc=0i,wlanAPOuterIpAddress="0.0.0.0",wlanAPSwitchIpAddress="10.255.0.20",wlanAPName="HF4228-2-26",wlanAPModelName="225",wlanAPExternalAntenna=1i,wlanAPHwVersion="A1.0",wlanAPdot11aAntennaGain10x=255i,wlanAPNumRadios=2i,wlanAPRemoteLanIpAddress="10.196.40.238",wlanAPStandbyIpAddress="0.0.0.0",wlanAPMonitorMode=2i,wlanAPIpsecMode=2i,wlanAPLocation="Not Available",wlanAPMeshRole=0i,wlanAPActiveIpAddress="10.196.40.238",wlanAPSerialNumber="xxxxxx",wlanAPModel=".1.3.6.1.4.1.14823.1.2.59",wlanAPUpTime=56845300i,wlanAPBuilding=0i,wlanAPUnprovisioned=2i,wlanAPNumWarmReboots=0i,wlanAPFlexRadioMode=4i,wlanAPIpAddress="10.196.40.238",wlanAPEnet1Mode=1i,wlanAPActiveUplink=1i,wlanAPGroupName="controller.example.com",wlanAPStatus=1i,wlanAPNumBootstraps=6i,wlanAPNumReboots=2i,wlanAPSwVersion="8.6.0.9",wlanAPdot11aAntennaGain=0i 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPExternalAntenna=1i,wlanAPUnprovisioned=2i,wlanAPMeshRole=0i,wlanAPConnectedAsStandby=0i,wlanAPdot11aAntennaGain=0i,wlanAPSplit5GMode=3i,wlanAPActiveIpAddress="10.196.41.229",wlanAPModel=".1.3.6.1.4.1.14823.1.2.48",wlanAPNumBootstraps=5i,wlanAPFlexRadioMode=4i,wlanAPdot11aAntennaGain10x=255i,wlanAPdot11gAntennaGain10x=255i,wlanAPFloor=0i,wlanAPStatus=1i,wlanAPOuterIpAddress="0.0.0.0",wlanAPSwitchIpAddress="10.255.0.20",wlanAPDual5GMode=3i,wlanAPName="HF4228-5-3(D)",wlanAPLoc=0i,wlanAPActiveUplink=1i,wlanAPConnectedAsDatazone=0i,wlanAPIpAddress="10.196.41.229",wlanAPNumRadios=2i,wlanAPUpTime=1037552800i,wlanAPModelName="135",wlanAPSwVersion="8.6.0.9",wlanAPStandbyIpAddress="0.0.0.0",wlanAPdot11gAntennaGain=0i,wlanAPEnet1Mode=1i,wlanAPIpsecMode=2i,wlanAPNumReboots=1i,wlanAPMonitorMode=2i,wlanAPNumWarmReboots=0i,wlanAPRemoteLanIpAddress="10.196.41.229",wlanAPGroupName="controller.example.com",wlanAPSerialNumber="xxxxxxx",wlanAPLocation="Not Available",wlanAPBuilding=0i,wlanAPHwVersion="A1.0" 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPDual5GMode=3i,wlanAPSplit5GMode=3i,wlanAPLocation="Not Available",wlanAPExternalAntenna=1i,wlanAPNumBootstraps=6i,wlanAPRemoteLanIpAddress="x.x.x.x",wlanAPFlexRadioMode=4i,wlanAPFloor=0i,wlanAPStatus=1i,wlanAPNumReboots=1i,wlanAPIpAddress="x.x.x.x",wlanAPName="HF4228-O-6",wlanAPdot11aAntennaGain=0i,wlanAPIpsecMode=2i,wlanAPBuilding=0i,wlanAPHwVersion="A1.0",wlanAPSwVersion="8.6.0.9",wlanAPActiveUplink=1i,wlanAPConnectedAsDatazone=0i,wlanAPActiveIpAddress="x.x.x.x",wlanAPEnet1Mode=1i,wlanAPUpTime=1037576900i,wlanAPUnprovisioned=2i,wlanAPMeshRole=0i,wlanAPOuterIpAddress="0.0.0.0",wlanAPGroupName="controller.example.com",wlanAPMonitorMode=2i,wlanAPSwitchIpAddress="10.255.0.20",wlanAPdot11aAntennaGain10x=255i,wlanAPModel=".1.3.6.1.4.1.14823.1.2.64",wlanAPSerialNumber="xxxxxx",wlanAPLoc=0i,wlanAPNumWarmReboots=0i,wlanAPStandbyIpAddress="0.0.0.0",wlanAPConnectedAsStandby=0i,wlanAPModelName="275",wlanAPdot11gAntennaGain10x=255i,wlanAPdot11gAntennaGain=0i,wlanAPNumRadios=2i 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPStatus=1i,wlanAPRemoteLanIpAddress="10.196.233.170",wlanAPConnectedAsStandby=0i,wlanAPConnectedAsDatazone=0i,wlanAPSerialNumber="xxxxxxxx",wlanAPdot11aAntennaGain=0i,wlanAPNumRadios=2i,wlanAPUpTime=2455100i,wlanAPBuilding=0i,wlanAPStandbyIpAddress="0.0.0.0",wlanAPdot11aAntennaGain10x=255i,wlanAPdot11gAntennaGain10x=255i,wlanAPSplit5GMode=3i,wlanAPIpAddress="10.196.233.170",wlanAPGroupName="controller.example.com.",wlanAPIpsecMode=2i,wlanAPNumBootstraps=22i,wlanAPFlexRadioMode=4i,wlanAPActiveIpAddress="10.196.233.170",wlanAPModelName="535",wlanAPNumReboots=16i,wlanAPUnprovisioned=2i,wlanAPMeshRole=0i,wlanAPNumWarmReboots=1i,wlanAPOuterIpAddress="0.0.0.0",wlanAPMonitorMode=2i,wlanAPSwVersion="8.6.0.9",wlanAPDual5GMode=3i,wlanAPModel=".1.3.6.1.4.1.14823.1.2.102",wlanAPdot11gAntennaGain=0i,wlanAPLocation="Not Available",wlanAPExternalAntenna=1i,wlanAPHwVersion="A1.0",wlanAPActiveUplink=1i,wlanAPEnet1Mode=1i,wlanAPLoc=0i,wlanAPName="HF4160-5-3",wlanAPFloor=0i,wlanAPSwitchIpAddress="10.255.0.20" 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPdot11gAntennaGain=0i,wlanAPStatus=1i,wlanAPRemoteLanIpAddress="x.x.x.x",wlanAPSwitchIpAddress="10.255.0.20",wlanAPFlexRadioMode=4i,wlanAPFloor=0i,wlanAPEnet1Mode=1i,wlanAPIpsecMode=2i,wlanAPModelName="135",wlanAPLocation="Not Available",wlanAPdot11gAntennaGain10x=255i,wlanAPDual5GMode=3i,wlanAPActiveIpAddress="x.x.x.x",wlanAPSplit5GMode=3i,wlanAPModel=".1.3.6.1.4.1.14823.1.2.48",wlanAPdot11aAntennaGain=0i,wlanAPLoc=0i,wlanAPNumReboots=761i,wlanAPMeshRole=0i,wlanAPStandbyIpAddress="0.0.0.0",wlanAPUnprovisioned=2i,wlanAPSwVersion="8.6.0.9",wlanAPName="HF4228-3-9",wlanAPNumRadios=2i,wlanAPMonitorMode=2i,wlanAPHwVersion="A1.0",wlanAPdot11aAntennaGain10x=255i,wlanAPOuterIpAddress="0.0.0.0",wlanAPActiveUplink=1i,wlanAPGroupName="controller.example.com",wlanAPSerialNumber="xxxxxxx",wlanAPUpTime=483387800i,wlanAPBuilding=0i,wlanAPExternalAntenna=1i,wlanAPNumWarmReboots=0i,wlanAPConnectedAsDatazone=0i,wlanAPIpAddress="x.x.x.x",wlanAPNumBootstraps=1944i,wlanAPConnectedAsStandby=0i 1646137124000000000
WlanAPTable,agent_host=10.255.0.20,host=xxxx.example.com wlanAPLocation="Not Available",wlanAPFloor=0i,wlanAPLoc=0i,wlanAPSwVersion="8.6.0.9",wlanAPDual5GMode=3i,wlanAPIpAddress="10.196.40.204",wlanAPName="HF4228-4-26",wlanAPGroupName="controller.example.com",wlanAPActiveIpAddress="10.196.40.204",wlanAPNumWarmReboots=0i,wlanAPStandbyIpAddress="0.0.0.0",wlanAPExternalAntenna=1i,wlanAPOuterIpAddress="0.0.0.0",wlanAPSwitchIpAddress="10.255.0.20",wlanAPModel=".1.3.6.1.4.1.14823.1.2.59",wlanAPSerialNumber="xxxxxxx",wlanAPIpsecMode=2i,wlanAPHwVersion="A1.0",wlanAPActiveUplink=1i,wlanAPEnet1Mode=1i,wlanAPModelName="225",wlanAPStatus=1i,wlanAPConnectedAsDatazone=0i,wlanAPFlexRadioMode=4i,wlanAPdot11gAntennaGain10x=255i,wlanAPdot11gAntennaGain=0i,wlanAPBuilding=0i,wlanAPConnectedAsStandby=0i,wlanAPMeshRole=0i,wlanAPNumRadios=2i,wlanAPNumBootstraps=6i,wlanAPUnprovisioned=2i,wlanAPMonitorMode=2i,wlanAPRemoteLanIpAddress="10.196.40.204",wlanAPdot11aAntennaGain10x=255i,wlanAPSplit5GMode=3i,wlanAPdot11aAntennaGain=0i,wlanAPUpTime=56845300i,wlanAPNumReboots=2i 1646137124000000000