Re: [Bacula-users] Query to list volumes available in the pool

2013-05-20 Thread Isamar Maia
Hi Gustavo, The purpose here is to send out by email regular reports to the team and make the management easier. isamar 2013/5/19 LDC - Gustavo El Khoury : > On 19/05/2013, at 07:32 p.m., Isamar Maia wrote: > >> Pretty cool. Thanks. >> >> 2013/5/19 Dan Langille : >>> >>> On May 18, 2013, at 6:3

Re: [Bacula-users] Query to list volumes available in the pool

2013-05-19 Thread LDC - Gustavo El Khoury
On 19/05/2013, at 07:32 p.m., Isamar Maia wrote: > Pretty cool. Thanks. > > 2013/5/19 Dan Langille : >> >> On May 18, 2013, at 6:35 PM, Isamar Maia wrote: >> >>> Hi Folks, >>> >>> I need a SQL query for Bacula to list the volumes available in the >>> pool, including those to be recycled >>> d

Re: [Bacula-users] Query to list volumes available in the pool

2013-05-19 Thread Isamar Maia
Pretty cool. Thanks. 2013/5/19 Dan Langille : > > On May 18, 2013, at 6:35 PM, Isamar Maia wrote: > >> Hi Folks, >> >> I need a SQL query for Bacula to list the volumes available in the >> pool, including those to be recycled >> due to expiration of their retention periods but weren't still recycl

Re: [Bacula-users] Query to list volumes available in the pool

2013-05-19 Thread Dan Langille
On May 18, 2013, at 6:35 PM, Isamar Maia wrote: > Hi Folks, > > I need a SQL query for Bacula to list the volumes available in the > pool, including those to be recycled > due to expiration of their retention periods but weren't still recycled. > > For time being, I am using this query: > > se

[Bacula-users] Query to list volumes available in the pool

2013-05-18 Thread Isamar Maia
Hi Folks, I need a SQL query for Bacula to list the volumes available in the pool, including those to be recycled due to expiration of their retention periods but weren't still recycled. For time being, I am using this query: select count(*) as count from Media where PoolId = X and StorageId = Y