Given the table below:
VIP Group State
Primary_VIP Group1 Down
Backup_VIP Group1 Down
Primary_VIP Group3 Down
Backup_VIP Group4 Down
How can I filter the results to show only the events where both Primary and Backup VIPs are down in same group?
e.g.
I'd like to keep just:
VIP Group State
Primary_VIP Group1 Down
Backup_VIP Group1 Down
... View more