CA Service Management

CA ITAM/SDM - SQL Query Select CORA tables

Recommend

Sep 22, 2016 04:58 PM

TMACUL

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

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

Statistics

0 Favorited

8 Views

0 Files

0 Shares

0 Downloads