CA Service Management

View Only

CA ITAM/SDM - SQL Query Select Asset-Configuration Item & Family

Recommend

Dec 05, 2016 05:28 PM

TMACUL

select f.name, nr.resource_name
from ca_owned_resource as nr
left join ca_resource_family as f on f.id = nr.resource_family

ca_resource_family.name	ca_owned_resource.resource_name
Hardware.Workstation	NBK65320
Software.Application	CA SERVICE DESK
Hardware.Server	WIN-838HLOP36MO
Hardware.Workstation workstation	My DELL

Statistics

0 Favorited

5 Views

0 Files

0 Shares

0 Downloads