i have got json data like below. i have a lookup file defined with technology and fields which i would want to display.
it would help even if i can replace the fields from the lookup table in the query
basically i want to add fields to the query based on the lookup file
Query :
index= tech sourcetype=json technology=os [|inputlookup techtable| technology= OS |fields fields]
lookup table:
technology fields
OS host
OS hostname
SAP gw/cpic_timeout
SAP gw/max_conn
Json data:
{
_technology : "OS",
architecture : "x86_64",
domain : "monsanto.com",
facterversion : "1.5.2",
fqdn : "std08a00.monsanto.com",
hardwaremodel : "x86_64",
hostname : "std08a00",
interfaces : "eth1",
ipaddress : "10.30.16.104",
ipaddress_eth1 : "10.30.16.104",
kernel : "Linux",
kernelrelease : "2.6.32.59-0.7-default",
kernelversion : "2.6.32.59",
lsbdistcodename : "n/a",
lsbdistdescription : "SUSE Linux Enterprise Server 11 (x86_64)",
lsbdistid : "SUSE LINUX",
lsbdistrelease : "11",
lsbrelease : "core-2.0-noarch:core-3.2-noarch:core-4.0-noarch:core-2.0-x86_64:core-3.2-x86_64:core-4.0-x86_64:desktop-4.0-amd64:desktop-4.0-noarch:graphics-2.0-amd64:graphics-2.0-noarch:graphics-3.2-amd64:graphics-3.2-noarch:graphics-4.0-amd64:graphics-4.0-noarch",
macaddress_eth1 : "00:0C:29:BC:FD:88",
memoryfree : "26.34 GB",
memorysize : "31.49 GB",
netmask : "255.255.252.0",
netmask_eth1 : "255.255.252.0",
operatingsystem : "SLES",
operatingsystemrelease : "11.1",
processor0 : "Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz",
processor1 : "Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz",
processor2 : "Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz",
processor3 : "Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz",
processor4 : "Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz",
processor5 : "Intel(R) Xeon(R) CPU E7- 2830 @ 2.13GHz",
processorcount : "6",
ps : "ps -ef",
puppetversion : "2.6.17",
rubysitedir : "/usr/lib64/ruby/site_ruby/1.8",
rubyversion : "1.8.7",
sshdsakey : "AAAAB3NzaC1kc3MAAACBAN3D818gre6+WfSiH6YJlxExf/Tmq/f2KLY8oN5bV40on31qt/8VA4ShsARgKSLX2HpoOINU3vv5ENqhpUs3W9pZotOTLaxTUmF4eYgaMsLVCJFYNGfOtDVvKVjxT9vybBkaJ/Ppq4VXajimMt9pGQ0oetx3C3V0drffzM5/gSdRAAAAFQDVVrQM10pD8YX++fuxvxYxZe1UpQAAAIEAuAmCYe1NXqLN9fk7zaXf9eCjW6oGFkNbpnk3rSXX7tlOjuibYQt1xL8jpVc0la/W5Cbt3dwyLB57ZauBoW/6agJTqIoU1X8PYy1qW1q2QsgNLGco9ZDBhKHX3Mo8i/gR7sW6sN3zaAoFWd3T4LF8vebFGyWRoQgmRQlIiFmfMmIAAACBAM4ClRwgdvuZN8JmiYgaf/RcWRcpBJLmhgCS2gZjb2Wu41Msb9ain4lJmEQu5T+hA/9lKo0EG6Sp+vzKIReNOFikEIQwl0Ttj/s9P1wZkba9NplQyZqqR0v/F2Md70SUg+7RiQJ/xTX0IVssW+YMsR3uGuC8Wy+V4V6rp7WeuJRv",
sshrsakey : "AAAAB3NzaC1yc2EAAAABIwAAAIEAtxsvJhJifxCqSKGjYQtXqc29iql+CAS9OK8r+zEM0q+MXEOFikoa2CvbXahwDdXmcWYbq6N11tCNu3q8NYdTpzSA94FPptPfT5akCSzvKcKzPXQ/xmnbnbd28Vh6eRVbeknikjQMvgYhwObDr1AzGvkv1YMd+rBPZTD5Ixj5vwk=",
swapfree : "31.99 GB",
swapsize : "31.99 GB",
virtual : "vmware"
}
... View more