topic Highlighting data in one table that is contained in a separate table? in Dashboards & Visualizations

Highlighting data in one table that is contained in a separate table?

mjande5 — Tue, 31 May 2022 00:20:10 GMT

Hi, rather new to this community, but trying to figure this out. I have table 1 with two fields, (src_ip and dest_ip) and another table 2 with (IP) field. I would like to highlight any IPs in table 2 that are a match to any in table 1 in either field. Is there an easy way to accomplish this? Thanks in advance.

Re: Highlighting data in one table that is contained in a separate table?

gcusello — Tue, 31 May 2022 06:54:26 GMT

Hi @mjande5,

if the results in the second table are less than 50,000, you can use a search like this:

If they are more than 50,000 you need a different solution.

Let me know.

Ciao.

Giuseppe

Re: Highlighting data in one table that is contained in a separate table?

PickleRick — Tue, 31 May 2022 07:14:57 GMT

Since you're asking in the "Dashboards & Visualizations" section - do you mean that you have two separate table widgets on the same dashboard? Or do you simply want to do a "match" for two given searches.

Re: Highlighting data in one table that is contained in a separate table?

mjande5 — Tue, 31 May 2022 10:39:05 GMT

@PickleRick

Sorry, I should have been more clear. I have two separate dashboards that query differing information. One has src_ip and dest_ip columns and the other dashboard has an IP column. I would like to have any IPs in either the src_ip or dest_ip columns to highlight or some way stand out if they match the IPs in the other dashboard with the IP column. I hope this helps clear up what I am trying to do.

-Mike