Views [dbo].[al_bi_disc_software_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnNo
Created7:00:37 PM Tuesday, April 26, 2011
Last Modified7:00:37 PM Tuesday, April 26, 2011
Columns
Name
manufacturer
product_name
drcs_content_type_id
release_name
host_name
serial_number
company_uuid
product_uuid
release_uuid
dis_hw_uuid
dis_sw_uuid
sw_def_uuid
asset_source_uuid
license_id
license_instance
license_block_id
covered_by_nf
creation_date
SQL Script
SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW al_bi_disc_software_view
AS
SELECT     manufacturer, product_name, drcs_content_type_id, release_name, host_name, serial_number, company_uuid, product_uuid, release_uuid,
                      dis_hw_uuid, dis_sw_uuid, sw_def_uuid, asset_source_uuid, license_id, license_instance, license_block_id, covered_by_nf, CONVERT(varchar,
                      dbo.SECS2DATE(creation_date), 101) AS creation_date
FROM         al_discovered_software_view
GO
Uses