To look at media
resources and the allocated MRGs, use the sql query
run sql
select mrg.name as mrg,d.name as resource from mediaresourcegroup mrg inner
join mediaresourcegroupmember mgm on mgm.fkmediaresourcegroup=mrg.pkid inner join device d on mgm.fkdevice=d.pkid
To filter specific
site
run sql
select mrg.name as mrg,d.name as resource from mediaresourcegroup mrg inner
join mediaresourcegroupmember mgm on mgm.fkmediaresourcegroup=mrg.pkid inner join device d on mgm.fkdevice=d.pkid
where d.name like '%AD1%' or mrg.name like '%A01%'
Use this CLI command to find media resources in the default MRG (no assigned to any created MRG).
admin:run
sql select d.name as resource from device as d full outer join
mediaresourcegroupmember as mgm on mgm.fkdevice=d.pkid where and mgm.pkid is NULL
resource
===========
AD1MTP-G711
AD1XCODER
You look for specific device type such as MTP
admin:run
sql select d.name as resource from device as d full outer join
mediaresourcegroupmember as mgm on mgm.fkdevice=d.pkid where d.name like
'%MTP%' and mgm.pkid is NULL
resource
===========
AD1MTP-G711
