Excludes unwanted data

[TaSMania]

When my report comes out,
it includes unwanted data such as:

ANR1687I Output for command 'SELECT' issued against server ISP1 follows:
nodes are sorted between ANR here
ANR1688I Output for command 'SELECT' issued against server ISP1 completed.

ANR1687I Output for command 'SELECT' issued against server ISP2 follows:
nodes are sorted between ANR here
ANR1688I Output for command 'SELECT' issued against server ISP2 completed.

ISP3 and ISP4 and so on.
Rather than sort the whole thing, it only sort per ISP.

I'd already included -dataonly=yes

How can I remove ANR** message that is not part of a table?

 

[marclant]

Missing details here. Not sure how you got those outputs.

 

[TaSMania]

bkp:select filespaces.node_name,filespaces.filespace_name,filespaces.backup_end,occupancy.physical_mb from filespaces,occupancy,nodes where (date(current_date)-date(filespaces.backup_end)>30) and occupancy.node_name=filespaces.node_name and occupancy.filespace_name=filespaces.filespace_name and nodes.node_name=filespaces.node_name order by filespaces.node_name,filespaces.filespace_id

 

[TaSMania]

it has to do with querying multiple servers.
possible to run query on single server and use >> each time?
but still how could I have all sorted.