Try this:
Where
array.id = disk.array_id
AND array.name = '${FilerName}'
AND role.disk = 'spare'
Mike
