Do you need select CA Service Desk Family and class?
Maybe, this SQL command can be helps.
select f.name, c.namefrom ca_resource_class cleft join ca_resource_family f on c.family_id = f.id
RESULTS EXAMPLE:
Summary CA SDM MS SQL Querys - TSQL
CA ITAM/SDM - SQL Query Select Model, Manufacturer, Family and Class
CA SDM Loading model pdm_load
Summary CA Service Management Community
CA SDM Comandos
Technical Reference Guide Release 12.9.00