1. Please help support our sponsors by considering their products and services.
    Our sponsors enable us to maintain high-speed Internet connection and fast webservers.
    They support this free information and knowledge exchange forum service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions

Excludes unwanted data

Discussion in 'Scripting' started by TaSMania, Feb 6, 2018.

  1. TaSMania

    TaSMania ADSM.ORG Member

    Joined:
    Nov 17, 2015
    Messages:
    75
    Likes Received:
    1
    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?
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,720
    Likes Received:
    377
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    Missing details here. Not sure how you got those outputs.
     
  4. TaSMania

    TaSMania ADSM.ORG Member

    Joined:
    Nov 17, 2015
    Messages:
    75
    Likes Received:
    1
    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
     
  5. TaSMania

    TaSMania ADSM.ORG Member

    Joined:
    Nov 17, 2015
    Messages:
    75
    Likes Received:
    1
    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.
     

Share This Page