I'd like to be able to enhance DB Connect results with details in a lookup table file.
For some reason, the lookup is not working. I know the host field exists both in my dbquery results and my lookup table file. Here is the syntax I am using:
| dbquery "myconnection" "mysqlquery" | fields host interestingvalue | lookup hostdetails.csv host OUTPUT interestinghostdetail
Anyone have any ideas why this isn't working / wouldn't work?
I would do it differently and using subsearches and inputlookup:
| inputlookup hostdetails | search [| dbquery "myconnection" "mysqlquery" | table host interestingvalue]