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.

sql query mgmtclass of single files

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

  1. xthor65

    xthor65 ADSM.ORG 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 ADSM.ORG 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 ADSM.ORG Senior Member

    Joined:
    Aug 5, 2004
    Messages:
    1,074
    Likes Received:
    1
    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