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

Document created by TMACUL Champion on Aug 26, 2016Last modified by TMACUL Champion on Oct 6, 2016
Version 3Show Document
  • View in full screen mode

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

 

 

Field Level Reference Mapping for ca_company - CA Service Management - 14.1 - CA Technologies Documentation 

Field Level Reference Mapping for ca_resource_family - CA Service Management - 14.1 - CA Technologies Documentation 

Field Level Reference Mapping for ca_resource_class - CA Service Management - 14.1 - CA Technologies Documentation 

 

 

Summary CA SDM  MS SQL Querys - TSQL 

4 people found this helpful

Attachments

    Outcomes