I didn't realize that my question was so difficult. I will add some additional input here to try and clarify my issue. Lets say I have my lookup table and it looks something like this:
Location, Vendor, dns_name, host-ip, host-short-name
Location-A, Vendor-Bob, hostA.networkA.com, 1.1.1.1, hostA
Location-B, Vendor-Bob, hostB.networkB.com, 2.2.2.2, hostB
Location-C, Vendor-Bob, hostC.networkC.com, 3.3.3.3, hostC
Now, in the code above, I use the host-ip from the lookup table to search an index for records based on the dvc field. As long as there is a match, I get output in a table. In the example below I match on 1.1.1.1 and 3.3.3.3, but not 2.2.2.2. My output table looks like this;
Line added to the code above:
| table Vendor Location short-name dvc clean_since
OUTPUT:
Vendor-Bob Location-A hostA 1.1.1.1 4567
Vendor-Bob Location-C hostC 3.3.3.3 789
What I need is the output table to include all the host-ips in the lookup table even is there is no match. The "clean_since" field will default to some default value. It should look something like this:
OUTPUT:
Vendor-Bob Location-A hostA 1.1.1.1 4567
Vendor-Bob Location-B hostB 2.2.2.2 10000
Vendor-Bob Location-C hostC 3.3.3.3 789
I hope this clears up some things. I really need some kind of solution soon.
... View more