CA SDM - SQL Query Select Family and Class

Document created by TMACUL Champion on Aug 25, 2016Last modified by TMACUL Champion on Mar 9, 2017
Version 2Show Document
  • View in full screen mode

Do you need select CA Service Desk Family and class?

 

Maybe, this SQL command can be helps.

 

SQL COMMAND

select f.name, c.name
from ca_resource_class c
left join ca_resource_family f on c.family_id = f.id

 

RESULTS EXAMPLE:

 

FamilyClass
HardwareHardware descoberto
SoftwareLicenciado
ServiçoComponente
ServiçoDocumento
ServiçoPessoa
ServiçoPrática
ServiçoProcesso
ServiçoFunção
ServiçoServiço
Hardware.WorkstationEstação de trabalho
Hardware.ServerServidor
Hardware.ServerAIX
Hardware.ServerHP UX
Hardware.ServerLinux
Hardware.ServerOutro sistema operacional

 

know_more.png

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 

 

2 people found this helpful

Attachments

    Outcomes