If i have events like below,
domain=abc, sever=abc_s1,status=running
domain=abc, server=abc_s2,status=shutdown
domain=xyz, sever=xyz_s1,status=running
domain=xyz, server=xyz_s2,status=shutdown
I want to create a table like below with new fields instance1 and instance2 , where instance1 should have the value of status for ($domain)_s1 . and instance2 should have the value of status for $domain_s2
can be this achievable?
domain instance1 instance2
abc running shutdown
xyz running shutdown
... View more