CA Service Management

View Only

Back to Library

CA ITAM/SDM - SQL Query Select Model, Manufacturer, Family and Class

Recommend

Aug 26, 2016 11:07 AM

TMACUL

Do you need select CA ITAM CA Service Desk Family and class?

Maybe, this SQL command can be helps.

SQL COMMAND
select m.name as model_name, man.company_name, f.name as family_name, c.name as class_name, m.inactive from ca_model_def as m left join ca_company as man on m.manufacturer_uuid = man.company_uuid left join ca_resource_family as f on m.family_id = f.id left join ca_resource_class as c on m.class_id = c.id

Statistics

0 Favorited

0 Views

0 Files

0 Shares

0 Downloads