[ca_itrm].[rep_view_sw_inv

[ca_itrm].[rep_view_sw_inv_R00000F]

(local) > mdb > Views > ca_itrm.rep_view_sw_inv_R00000F

Properties
Columns
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	2:19:03 PM Wednesday, March 14, 2007
Last Modified	2:19:03 PM Wednesday, March 14, 2007

Columns

Name
company_name
sw_name
sw_version_label
asset_source_uuid
dis_sw_uuid

SQL Script

create view ca_itrm.rep_view_sw_inv_R00000F as SELECT ca_company.company_name,ca_software_def.name as sw_name,ca_software_def.sw_version_label, asset_source_uuid, dis_sw_uuid FROM ca_discovered_software , (ca_software_def left outer join ca_company on manufacturer_uuid=company_uuid) WHERE ca_discovered_software.sw_def_uuid=ca_software_def.sw_def_uuid AND (ca_software_def.source_type_id=1 OR ca_software_def.source_type_id=2)
GO

Uses

[dbo].[ca_company]
[dbo].[ca_discovered_software]
[dbo].[ca_software_def]
ca_itrm