I have a Lookup Table the returns data from all 32 columns, but many times data that is confirmed good in the assetlist.csv file comes back as "unknown". Here is a snippet of my header in assetlist.csv:
logicalname,building,cabinet,cabinetslot,customerfacing,deploystatus
Along with a snippet of the next line under the header:
albia,e,ell_mfrm ax031,02,non-customer,production
Something as simple as asking for the "building" or "cabinet" is returned as "unknown". Here is my search string:
earliest=-1m | lookup assetlist logical_name OUTPUT building | stats count by building
and from this search it returns "building 'unknown' count=55129
Any ideas or thoughts behind why some of the data populates but other data doesn't?
I get the same incorrect results when I run this type of search:
earliest=-1m | table building cabinet
PS. When building the Lookup Table using the UI I checked the "automatic lookups" option so I get all the fields, all the time. Here is the first six columns from that part of the installation:
assetlist logical_name AS host OUTPUTNEW building AS building cabinet AS cabinet cabinet_slot AS cabinet_slot customer_facing AS customer_facing deploy_status AS deploystatus
This setup is as generic as possible and nothing tricked out to do anything fancy so I would think it would work "all the time".
MasterOogway
... View more