cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1434
Views
10
Helpful
4
Replies

Getting Device and Device Pool information

AR7
Beginner
Beginner

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
1 Accepted Solution

Accepted Solutions

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                     

View solution in original post

4 Replies 4

Mohammed Khan
Cisco Employee
Cisco Employee

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

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.

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                     

Thanks for the quick reply.It's working

Getting Started

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: