Knowledge Base Article
Was this article helpful?
Grest Post,
I need tape base policy & other details.
I need below column,
Media ID, Media barcode, Media Volume Pool, Policy Name (If Map to Policy), Storage Unit Name (If Staging to Media), Schedule to backup on media,
but i am unable to do get data becuase it's only showing media id which bind to policy,
unable to do join query. I am running below query.
select
domain_media.id as "id",
domain_media.deleted as "is delete",
domain_media.barcode as 'Media Barcode',
domain_media.volumePoolName as 'Media Pool',
nb_VolumePool.name as "V Pool",
nb_Policy.name as "Policy",
(select max (nb_Policy.versionno) as "Version")
from domain_media, nb_Policy, nb_VolumePool
where domain_media.volumePoolName = nb_Policy.volumePoolName
and domain_media.volumePoolName = nb_VolumePool.name
and domain_media.id <> 'A00000'
and domain_media.id <> 'A00001'
and domain_media.id <> 'A00002'
group by domain_media.id, domain_media.deleted, domain_media.barcode, domain_media.volumePoolName, nb_VolumePool.name, nb_Policy.name
order by domain_media.id