1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

unused mgmt classes

Discussion in 'Backup / Archive Discussion' started by JonRoenick, Apr 20, 2017.

  1. JonRoenick

    JonRoenick ADSM.ORG Member

    Joined:
    Feb 18, 2008
    Messages:
    157
    Likes Received:
    2
    Occupation:
    Systems Engineer
    Location:
    Maryland, US
    I have certain management classes that aren't used. The problem is that i don't know all of the ones that are not being used. Is there a way to query which ones ARE used and then by process of elimination i'd find out the ones that AREN'T?

    Just trying to tidy up for spring.
     
  2.  
  3. marclant

    marclant ADSM.ORG Moderator

    Joined:
    Jun 16, 2006
    Messages:
    2,462
    Likes Received:
    346
    Occupation:
    Accelerated Value Specialist for Spectrum Protect
    Location:
    Canada
    You can see which one are used:
    Code:
    select distinct n.domain_name,b.class_name from backups b,nodes n where n.node_name=b.node_name
    
    select distinct n.domain_name,a.class_name from archives a,nodes n where n.node_name=a.node_name
     
  4. moon-buddy

    moon-buddy ADSM.ORG Moderator

    Joined:
    Aug 24, 2005
    Messages:
    6,791
    Likes Received:
    355
    Occupation:
    Electronics Engineer, Security Professional
    Location:
    Somewhere in the US
  5. JonRoenick

    JonRoenick ADSM.ORG Member

    Joined:
    Feb 18, 2008
    Messages:
    157
    Likes Received:
    2
    Occupation:
    Systems Engineer
    Location:
    Maryland, US
    This great! thank you very much
     
  6. JonRoenick

    JonRoenick ADSM.ORG Member

    Joined:
    Feb 18, 2008
    Messages:
    157
    Likes Received:
    2
    Occupation:
    Systems Engineer
    Location:
    Maryland, US
    This webpage is really useful. Bookmarking now.
     

Share This Page