Hello Stephen,
I cheked that "select count(distinct) is available in MySQL 5.X versions.
Could you try the bellow?
mysql> select count(distinct MediaId) from Media;
+-------------------------+
| count(distinct MediaId) |
+-------------------------+
| 60 |
+-------------------------+
1 row in set (0.00 sec)
The complete query worked for me (the server has 22 clients):
mysql> select Client.Name, count(distinct Filename.FilenameId) from
Client, Filename, File, Job where Filename.FilenameId=File.FilenameId and
File.JobId=Job.JobId and Job.ClientId=Client.ClientId group by
Client.ClientId;
+------------------+-------------------------------------+
| Name | count(distinct Filename.FilenameId) |
+------------------+-------------------------------------+
| xxxxxx-fd | 6590 |
| yyyyyy-fd | 222632 |
| zzzzzzz-fd | 441730 |
...
+------------------+-------------------------------------+
22 rows in set (16 min 42.63 sec)
Best regards,
Ana
On Wed, Oct 7, 2015 at 12:13 PM, Stephen Thompson <
step...@seismo.berkeley.edu> wrote:
>
>
> Thanks for the help. Though, this is giving me a syntax error.
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to use
> near 'select Client.Name, count(distinct Filename.FilenameId) from
> Client, Filen' at line 1
>
> On 10/7/15 6:23 AM, Ana Emília M. Arruda wrote:
>
>> select Client.Name, count(distinct Filename.FilenameId) from Client,
>> Filename, File, Job where Filename.FilenameId=File.FilenameId and
>> File.JobId=Job.JobId and Job.ClientId=Client.ClientId group by
>> Client.ClientId;
>>
>
> --
> Stephen Thompson Berkeley Seismological Laboratory
> step...@seismo.berkeley.edu 215 McCone Hall #4760
> Office: 510.664.9177 University of California, Berkeley
> Remote: 510.214.6506 (Tue,Wed) Berkeley, CA 94720-4760
>
------------------------------------------------------------------------------
Full-scale, agent-less Infrastructure Monitoring from a single dashboard
Integrate with 40+ ManageEngine ITSM Solutions for complete visibility
Physical-Virtual-Cloud Infrastructure monitoring from one console
Real user monitoring with APM Insights and performance trend reports
Learn More http://pubads.g.doubleclick.net/gampad/clk?id=247754911&iu=/4140
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
