08-13-2018 01:05 AM
I need help with SQL query to get the Device and Device Pool information. What I need is Device Name, Model name, Description, Product and Pool name. I am using the following query but it's returning only device and device pool name.
select a.name as device, b.name as pool from device as a left join devicepool as b on a.fkdevicepool = b.pkid
Solved! Go to Solution.
08-13-2018 05:19 PM
Here you go
admin:run sql select d.name,d.description,dp.name as devicepool,m.name as devicemodel,p.name as product,c.name as class from device as d inner join devicepool as dp on d.fkdevicepool = dp.pkid inner join typemodel as m on m.enum = d.tkmodel inner join typeproduct as p on p.tkmodel = d.tkmodel inner join typeclass as c on c.enum = d.tkclass name description devicepool devicemodel product class ============================================== ============================================= =========== ======================================= ======================================= ========================== Sample Device Template with TAG usage examples #FirstName# #LastName# (#Product# #Protocol#) Default Universal Device Template Universal Device Template Phone Auto-registration Template #FirstName# #LastName# (#Product# #Protocol#) Default Universal Device Template Universal Device Template Phone
08-13-2018 03:55 AM
Try below SQL Query
admin:run sql select d.name,d.description,dp.name as devicepool,m.name as devicemodel,p.name as product from device as d inner join devicepool as dp on d.fkdevicepool = dp.pkid inner join typemodel as m on m.enum = d.tkmodel inner join typeproduct as p on p.tkmodel = d.tkmodel name description devicepool devicemodel product ============================================== ============================================= =========== ======================================= ======================================= Sample Device Template with TAG usage examples #FirstName# #LastName# (#Product# #Protocol#) Default Universal Device Template Universal Device Template Auto-registration Template #FirstName# #LastName# (#Product# #Protocol#) Default Universal Device Template Universal Device Template
08-13-2018 05:49 AM
Thanks, the query worked for me. Just want one quick addition, I also need the Class_type information, but not able to figure out the table name.
08-13-2018 05:19 PM
Here you go
admin:run sql select d.name,d.description,dp.name as devicepool,m.name as devicemodel,p.name as product,c.name as class from device as d inner join devicepool as dp on d.fkdevicepool = dp.pkid inner join typemodel as m on m.enum = d.tkmodel inner join typeproduct as p on p.tkmodel = d.tkmodel inner join typeclass as c on c.enum = d.tkclass name description devicepool devicemodel product class ============================================== ============================================= =========== ======================================= ======================================= ========================== Sample Device Template with TAG usage examples #FirstName# #LastName# (#Product# #Protocol#) Default Universal Device Template Universal Device Template Phone Auto-registration Template #FirstName# #LastName# (#Product# #Protocol#) Default Universal Device Template Universal Device Template Phone
08-13-2018 09:38 PM
Thanks for the quick reply.It's working
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: