CREATE VIEW ARG_ASSET_CHANGE_VIEW
AS
  SELECT dh.dis_hw_uuid                 discHWUuid,
           dh.discovery_changes_switch    discChangesSwitch,
    dh.host_name                   discHostName,
    dh.tenant_id                   discTenantUuid,
    ag.last_run_date               discLastRunDate,
    ap.genTotMemory                discTotalMemory,
    ap.genTotDisk                  discTotalDiskSpace,
    ap.genOS                       discOpSys,
    ap.genNumProcs                 discProcessorCount,
    ap.genProcType                 discProcessorType,
    ap.genProcSpeed                discProcessorSpeed,
    owned.own_resource_uuid        ownedAssetUuid,
    owned.asset_type_id            ownedAssetTypeId,
    owned.model_uuid               ownedModelUuid,
    owned.resource_class           ownedAssetClassId,
        owned.resource_subclass        ownedAssetSubclassId,
        owned.resource_family          ownedAssetFamilyId,
    owned.resource_name            ownedAssetName,
    owned.host_name                ownedHostName,
    owned.discovery_last_run_date  ownedLastRunDate,
    owned.total_memory             ownedTotalMemory,
    owned.total_disk_space         ownedTotalDiskSpace,
    owned.processor_count          ownedProcessorCount,
    owned.processor_speed          ownedProcessorSpeed,
    owned.processor_type           ownedProcessorType,
    owned.operating_system         ownedOpSysId,
    owned.total_memory_unit        ownedTotalMemoryUnitId,
    owned.total_disk_space_unit    ownedTotalDiskSpaceUnitId,
    owned.processor_speed_unit     ownedProcessorSpeedUnitId,
    owned.version_number           ownedVersionNumber,
    owned.tenant                   ownedTenantUuid,
    opsys.name                     ownedOpSys,
    memunit.name                   ownedTotalMemoryUnits,
    diskunit.name                  ownedTotalDiskSpaceUnits,
    procunit.name                  ownedProcessorSpeedUnits
FROM    ca_discovered_hardware dh
INNER JOIN arg_reconcile_links link
        ON dh.dis_hw_uuid = link.dis_hw_uuid
INNER JOIN ca_owned_resource owned
    ON link.own_resource_uuid = owned.own_resource_uuid and owned.inactive = 0 and (owned.exclude_reconciliation = 0 or owned.exclude_reconciliation is null)
INNER JOIN ca_agent ag
    ON ag.object_uuid = dh.dis_hw_uuid
INNER JOIN ca_agent_prop ap
    ON ap.object_uuid = dh.dis_hw_uuid
LEFT OUTER JOIN ca_resource_operating_system opsys
    ON owned.operating_system = opsys.id
LEFT OUTER JOIN ca_disk_space_units memunit
    ON owned.total_memory_unit = memunit.id
LEFT OUTER JOIN ca_disk_space_units diskunit
    ON owned.total_disk_space_unit = diskunit.id
LEFT OUTER JOIN ca_processor_speed_units procunit
    ON owned.processor_speed_unit = procunit.id
GO