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

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,607
    Likes Received:
    370
    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,849
    Likes Received:
    363
    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