Views [dbo].[al_aud_owned_resource_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:37:14 PM Thursday, February 10, 2011
Last Modified10:37:14 PM Thursday, February 10, 2011
Columns
Name
own_resource_uuid
inactive
asset_type_id
resource_name
resource_description
resource_family
resource_class
resource_status
manufacturer_uuid
responsible_vendor_uuid
maintenance_org_uuid
responsible_org_uuid
org_bought_for_uuid
resource_contact_uuid
resource_owner_uuid
location_uuid
floor_location
room_location
cabinet_location
shelf_location
slot_location
model_uuid
host_name
mac_address
ip_address
resource_tag
operating_system
product_version
serial_number
acquire_date
installation_date
cost_center
gl_code
resource_quantity
requisition_id
purchase_order_id
ufam
creation_user
creation_date
last_update_user
last_update_date
version_number
supply_vendor_uuid
maintenance_vendor_uuid
company_bought_for_uuid
resource_capacity_unit
resource_capacity
resource_alias
asset_source_uuid
license_uuid
exclude_registration
delete_time
department
status_date
license_information
resource_subclass
audit_date
exclude_reconciliation
dns_name
alternate_host_name
discovery_last_run_date
previous_resource_tag
processor_count
processor_speed
processor_speed_unit
processor_type
reconciliation_date
total_disk_space
total_disk_space_unit
total_memory
total_memory_unit
billing_contact_uuid
support_contact1_uuid
support_contact2_uuid
support_contact3_uuid
disaster_recovery_contact_uuid
backup_services_contact_uuid
network_contact_uuid
tenant
license_id
resource_deployment_status
is_asset
is_ci
lifecycle_status
lifecycle_status_date
audit_trail_id
audit_trail_user
audit_trail_type
audit_trail_date
audit_trail_product
SQL Script
CREATE VIEW dbo.al_aud_owned_resource_view AS select audittable.* from dbo.aud_ca_owned_resource audittable WITH(READPAST) left outer join dbo.al_aud_owned_resource_potr audpointer on (audittable.own_resource_uuid = audpointer.own_resource_uuid ) where ( audpointer.audit_trail_id is null or  ( audittable.audit_trail_id >= audpointer.audit_trail_id and audpointer.is_deleted != 1 ))
GO
Uses