cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays

How to find unassigned Media Resources (No MRG)?

509
Views
0
Helpful
1
Comments
Mohammed al Baqari
VIP Advisor

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

1 Comment
vn
Beginner
Beginner

I am getting 'A syntax error has occurred'. May I know why?

 

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
A syntax error has occurred.

Content for Community-Ad

Spotlight Awards 2021

This widget could not be displayed.