CA ITAM/SDM - SQL Query Select CORA tables

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

Solving CORA problems

 

Sometimes we have many information problems, it's exactly what happens with CA CMDB, for some reason or by somebody happens.

 

What can we do?

 

Troubleshooting using MS SQL Command

 

Header 1
/*
select * from ca_asset_subschema
select * from ca_discovered_hardware --ITCM - Client Automation
select * from tng_managedobjects
select * from pd_machine
select * from ci_ambiguity_twaci
*/
declare @uuid binary(16), @source binary(16), @logical binary(16), @asset binary(16)
set @uuid = 0x1F2BE9E1EBF0AE44A23B27FF02217BA2
select @source = asset_source_uuid from ca_owned_resource where own_resource_uuid = @uuid
select 'ca_owned_resource', * from ca_owned_resource where own_resource_uuid = @uuid
select @logical = logical_asset_uuid from ca_asset_source where asset_source_uuid = @source
select 'ca_asset_source', * from ca_asset_source where asset_source_uuid = @source
select 'ca_logical_asset_property',* from ca_logical_asset_property where logical_asset_uuid = @logical
select @asset = asset_uuid from ca_logical_asset where logical_asset_uuid = @logical
select 'ca_logical_asset', * from ca_logical_asset where logical_asset_uuid = @logical
select 'ca_asset', * from ca_asset where asset_uuid = @asset
--CA SDM table
select 'usp_owned_resource', * from usp_owned_resource where owned_resource_uuid = @uuid
select 'ci_ambiguity_ci', * from ci_ambiguity_ci where id = @uuid
select 'ci_superseded', * from ci_superseded where id = @uuid

 

 

Summary CA SDM  MS SQL Querys - TSQL 

Attachments

    Outcomes