topic Re: Join 2 query based on common column in All Apps and Add-ons

Join 2 query based on common column

priya0709 — Tue, 18 Aug 2020 06:52:57 GMT

How can i join two query table based on common column ( host), but i want to display all columns from 1st table but just 1 column ( Incident column) from 2nd table??

Re: Join 2 query based on common column

to4kawa — Tue, 18 Aug 2020 06:56:05 GMT

What's the two queries and logs?

Re: Join 2 query based on common column

priya0709 — Tue, 18 Aug 2020 07:04:06 GMT

Query 1 displays ( Host, Time, Eventcode, Message)

Query 2 displays ( subject, Host, Incident)

i want to all match hosts in both column and based on that join the querys to display ( Host, Time, Eventcode, Message, incident)

Re: Join 2 query based on common column

to4kawa — Tue, 18 Aug 2020 07:18:26 GMT

query 1
| join Host [ query2]
| table Host, Time, Eventcode, Message, Incident

this is too slow , but it will work.

Re: Join 2 query based on common column

priya0709 — Tue, 18 Aug 2020 08:06:03 GMT

This worked but it is not displaying Host from query 1 even if it doesnt find any host in query 2??

my requirment is to match host but also display all output fro. Query 1??

Re: Join 2 query based on common column

to4kawa — Tue, 18 Aug 2020 08:08:14 GMT

please modify join option.