CA Service Management

CA SDM - SQL Query Select Family and Class 

Aug 25, 2016 04:22 PM

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 

 

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads

Related Entries and Links

No Related Resource entered.