Search

Discussion Thread 14

Data Partition based on owner ca_owned_resource

Library Entry

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

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...