CA Service Management

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

12-05-2016 05:28 PM


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.nameca_owned_resource.resource_name
Hardware.Workstation NBK65320
Software.Application CA SERVICE DESK
Hardware.ServerWIN-838HLOP36MO
Hardware.Workstation workstationMy DELL

Statistics
0 Favorited
4 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.