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

Document created by TMACUL Champion on Dec 5, 2016
Version 1Show Document
  • View in full screen mode


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

Attachments

    Outcomes