Hi All,
How to Filter Null Records in Report.
Please find the Below Search and Report.
sourcetype="informatica" Instancename="[TO1_HR_APP_ASSIGNMENTS1]" | table Instancename,OutputRows,AffectedRows,AppliedRows
Instancename OutputRows AffectedRows AppliedRows
[TO1_HR_APP_ASSIGNMENTS1] [5497] [5497] [5497]
[TO1_HR_APP_ASSIGNMENTS1]
[TO1_HR_APP_ASSIGNMENTS1]
[TO1_HR_APP_ASSIGNMENTS1] [5497] [5497] [5497]
[TO1_HR_APP_ASSIGNMENTS1]
[TO1_HR_APP_ASSIGNMENTS1]
Please Reply ASAP.
Thanks and Regards
Kiran Kumar
Well if you're not interested in the cases where OutputRows,AffectedRows,AppliedRows don't contain anything, just add it to the search?
sourcetype="informatica" Instancename="[TO1_HR_APP_ASSIGNMENTS1]" OutputRows="*" AffectedRows="*" AppliedRows="*" | ...