1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

sql query mgmtclass of single files

Discussion in 'Scripting' started by xthor65, Mar 10, 2008.

  1. xthor65

    xthor65 New Member

    Joined:
    Feb 13, 2005
    Messages:
    3
    Likes Received:
    0
    Hi , is possible to run a query, to have the association <file - managment class> ??

    example

    node file mgmtclass

    serv01 /tmp/file01 mc_30


    thankes in advance....

    Ciao
     
  2.  
  3. neerajkgupta

    neerajkgupta New Member

    Joined:
    Nov 3, 2005
    Messages:
    42
    Likes Received:
    2
    Try this for your Backups

    select node_name, hl_name, ll_name, class_name from backups where node_name='Your_Node_Name'

    You can try the same select statement from the Archives table, to grab the info about Archives.
     
  4. may

    may Senior Member

    Joined:
    Aug 5, 2004
    Messages:
    1,074
    Likes Received:
    0
    Location:
    PARIS
    for granular info you can do
    select node_name, hl_name, ll_name, class_name from backups where node_name='Your_Node_Name' and and hl_name='xxx' and ll_name='xxx'

    where hl_name = directory structure
    ll_name = file name
     
: mgmtclass, sql, query

Share This Page