Results 1 to 3 of 3
  1. #1

    Default sql query mgmtclass of single files

    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. #2
    Member
    Join Date
    Nov 2005
    Posts
    42
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default

    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.

  3. #3
    Senior Member
    Join Date
    Aug 2004
    Location
    PARIS
    Posts
    1,074
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    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

Similar Threads

  1. Simple SQL query into single-line output?
    By kzw2zx in forum Scripting
    Replies: 10
    Last Post: 02-13-2008, 03:21 PM
  2. Replies: 5
    Last Post: 02-12-2008, 11:33 AM
  3. Recovery of individual SQL database and log files in SQL
    By jonesk@chesterfield.gov in forum TSM Database
    Replies: 4
    Last Post: 02-11-2008, 03:16 PM
  4. Query inactive files - delete specific files
    By xefil in forum Backup / Archive Discussion
    Replies: 5
    Last Post: 11-27-2006, 03:30 PM
  5. Replies: 0
    Last Post: 02-13-2004, 06:24 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •