sql query mgmtclass of single files

[xthor65]

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

 

[neerajkgupta]

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.

 

[may]

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