Hi,
On 2/22/2006 2:58 PM, Geir Asle Borgen wrote:
On Wed, 2006-02-22 at 14:39 +0100, Arno Lehmann wrote:
Hi,
On 2/21/2006 8:36 PM, Geir Asle Borgen wrote:
Is it possible to genrate a list of the name of files that are backed up
during a incremental job on a client.
The easiest way would be to use the query "List files for a selected
JobId" and supplying the job ID which is reported in the job results or
can be found out with another query.
OK, but I'm no SQL guru ...
No need to be one - others have already done that work!
I'm capable to get in to query-mode (using
bconsole) ... But any hint om SQL queryes for MySQL is welcome :)
Try Baculas canned queries. Use the command 'query' and not 'sqlquery'.
For example what I get in wxconsole:
#que
Available queries:
1: List Job totals:
2: List where a File is saved regardless of the directory:
3: List where the most recent copies of a file are saved:
4: List last 20 Full Backups for a Client:
5: List all backups for a Client after a specified time
6: List all backups for a Client
7: List Volume Attributes for a selected Volume:
8: List Volumes used by selected JobId:
9: List Volumes to Restore All Files:
10: List Pool Attributes for a selected Pool:
11: List total files/bytes by Job:
12: List total files/bytes by Volume:
13: List Files for a selected JobId:
14: List Jobs stored in a selected MediaId:
15: List Jobs stored for a given Volume name:
16: List last 25 Jobs ordered by start time with long status:
17: List which media bacula thinks is in changer:
18: List media metadata concerning life-time
19: List all backups for a client with FileSet:
20: List all Media
Choose a query (1-20): Unexpected question has been received.
13
Enter JobId: Unexpected question has been received.
5250
+----------------------------------------------------+--------------------------+
| Path | Name
|
+----------------------------------------------------+--------------------------+
| /dev/ | tty10
|
| /dev/ | ttyS1
|
| /etc/ |
|
| /etc/ | ntp.drift
|
| /tmp/ |
|
| /var/account/ | pacct
|
etc.
Arno
--
IT-Service Lehmann [EMAIL PROTECTED]
Arno Lehmann http://www.its-lehmann.de
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
