Search .mdb files

[rulan]

Hi
I am trying to run a query on the TSM database to find the .mdb files in the active versions of the currently being backed client ( not retired clients). Below is the query i wrote -- but it giving me output of all the clients -- retired and currently being backed.

select node_name, left(hl_name,99), ll_name from backups where state='ACTIVE_VERSION' and ll_name like '%.MDB' > /home/rpatel1/search.txt
Output of command redirected to file '/home/rpatel1/search.txt'

Please help me with the correct syntax

[ad283m]

Hi,
If you know the node name, then you could do it like this:

select node_name, left(hl_name,99), ll_name from backups where state='ACTIVE_VERSION' and ll_name like '%.MDB' and node_name='nameofyournode' > /home/rpatel1/search.txt
Output of command redirected to file '/home/rpatel1/search.txt'

Also, you could use the time and put a 24 hours limit like timestamp-24

Best regards.

[rulan]

Thanks for the response, but I am not quite familiar with SQL and so am having trouble. I cannot put single node --- since we are trying to find it for all the servers that are currently being backed. Basically we are troubleshooting on all the access database files on difference servers(client) that users put too.
Could you please help me with the time stamp command. I think that will greatly help.

Thanks again for helping

[ad283m]

Regardin SQL, well I'm no expert, but here is a page that is great http://thobias.org/tsm/sql/#toc104

And on the timestamp, here is an example from the page:
Objects backed up of a specific node in the last 24 hours

tsm: SERVER1> SELECT backup_date,filespace_name,type,hl_name,ll_name,ow ner, class_name FROM backups -
WHERE node_name='MY_NODE' AND backup_date>=current_timestamp-24 hours
See the backup_date uses te current_timestamp-24hours because the current ts is the current time.

And dont use the node_name parameter.

I guess you could try to see the result first and then refine the query.

[rulan]

Running the query now

[rulan]

Thanks ad283m, the query worked. It took more than 24 hours to run but I did get the results.

[ad283m]

Great!!! Glad to be of help

Read the queries in the link they are great to the daily monitoring and day to day work.