06-24-2014 12:48 PM - edited 03-16-2019 11:12 PM
Has anyone posted the syntax of a SQL query that returns the devices associated to an MoH audio file (Network or User)?
Thanks,
Beau
Solved! Go to Solution.
06-25-2014 01:36 AM
try this
run sql select name,userholdmohaudiosourceid,networkholdmohaudiosourceid from device
this lists all devices and the associated moh id.
06-25-2014 01:36 PM
You can get fancy and also display the names:
run sql select device.name, usersource.name as usersource, networksource.name as networksource from device left join mohaudiosource as usersource on device.userholdmohaudiosourceid=usersource.sourceid left join mohaudiosource as networksource on device.networkholdmohaudiosourceid=networksource.sourceid
Also don't forget to check the lines as they take precedence over device:
run sql select np.dnorpattern as extension,partition.name as partition, usersource.name as UserSource,networksource.name as NetworkSource from numplan as np left join routepartition as partition on np.fkroutepartition=partition.pkid left join mohaudiosource as usersource on np.userholdmohaudiosourceid=usersource.sourceid left join mohaudiosource as networksource on np.networkholdmohaudiosourceid=networksource.sourceid
06-25-2014 01:36 AM
try this
run sql select name,userholdmohaudiosourceid,networkholdmohaudiosourceid from device
this lists all devices and the associated moh id.
06-25-2014 01:36 PM
You can get fancy and also display the names:
run sql select device.name, usersource.name as usersource, networksource.name as networksource from device left join mohaudiosource as usersource on device.userholdmohaudiosourceid=usersource.sourceid left join mohaudiosource as networksource on device.networkholdmohaudiosourceid=networksource.sourceid
Also don't forget to check the lines as they take precedence over device:
run sql select np.dnorpattern as extension,partition.name as partition, usersource.name as UserSource,networksource.name as NetworkSource from numplan as np left join routepartition as partition on np.fkroutepartition=partition.pkid left join mohaudiosource as usersource on np.userholdmohaudiosourceid=usersource.sourceid left join mohaudiosource as networksource on np.networkholdmohaudiosourceid=networksource.sourceid
06-26-2014 08:12 AM
Thank you both.
Mark - it works as expected pulling devices with user & network hold file names.
Brian - this too works to pull the pattern's associated MoH file name.
I've used them both and verified the syntax.
10-01-2018 01:12 PM
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: