topic Re: Blank rows in table in Splunk Search

Blank rows in table

DonDandrea — Thu, 18 Sep 2014 12:32:49 GMT

I am creating a table and simply reordering the fields from events. When I view the table there are random blank rows. How can I eliminate those rows?

index=mainframe sourcetype=dalystat INTVCICS | eval _time = strptime(time,"%m/%d/%y ;%H:%M") | table System TranName APPLID TranCount AvgRespTm AvgCPUtm DB2Requests AvgDB2waitTime MQRequests AvgMQwaitTime AdabasRequests AvgADABASwaitTime

Re: Blank rows in table

theouhuios — Thu, 18 Sep 2014 12:35:40 GMT

Those fields might not have data.

Eg: Lets say you have System= ABC and there is no corresponding data for other fields for that system in an event, then the table command will just list System and give blank result for the rest.

Re: Blank rows in table

DonDandrea — Thu, 18 Sep 2014 12:47:10 GMT

All of the fields are blank. There is nothing to match. When I click on the blank events to drill in and figure out what the events are I get no results found.

Re: Blank rows in table

martin_mueller — Thu, 18 Sep 2014 13:12:45 GMT

What does the table look like before reordering the columns?

Re: Blank rows in table

DonDandrea — Thu, 18 Sep 2014 13:27:29 GMT

This problem worked itself out. I added time to the table and there are no longer any blank rows.

Re: Blank rows in table

arihant16cse — Wed, 06 Feb 2019 07:33:43 GMT

in the above case you can do this steps......
1. write your query
2. then write this |dedup "column name",. . . . .
3.then run your query

Re: Blank rows in table

arihant16cse — Thu, 07 Feb 2019 07:02:34 GMT

.....|dedup ,....