nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter out data with one unique field and some equal fields

hubba900 · 2016-06-29T13:58:03+00:00

Hello, I have some events, for example: sourceip, application, time 1.1.1.1, ****, 2016-06-29 22:22:10 1.1.1.1, yyy, 2016-06-29 22:22:10 1.1.1.1, ****, 2016-06-29 22:22:20 2.2.2.2, yyy, 2016-06-29 22:22:10 I need receive this: …

hubba900

Hello,
 
I have some events, for example:
 
sourceip, application, time
 
1.1.1.1, ****, 2016-06-29 22:22:10
1.1.1.1, yyy, 2016-06-29 22:22:10
1.1.1.1, ****, 2016-06-29 22:22:20
2.2.2.2, yyy, 2016-06-29 22:22:10
 
I need receive this: 
 
1.1.1.1, ****, 2016-06-29 22:22:20
2.2.2.2, yyy, 2016-06-29 22:22:10
 
How I can filter out from table / chart date with unique application and same sourceip and time?

Find more posts tagged with

Comments

jfranken

Could you please provide a more detailed description of what you are trying to do?

hubba900

I try filter out data where time field is same and other fields are different.
Now I found solution for my SQL request. I made group by and the having count actions like:
 
<div>GROUP BY sourceip, application, time</div>
<div>HAVING COUNT(*) = 1</div>
<div> </div>
<div>This is gave me only rows where time field is different.</div>