[dbo].[arg_DA39A7D5A1C03D7B42B98

[dbo].[arg_DA39A7D5A1C03D7B42B98_view]

(local) > mdb > Views > dbo.arg_DA39A7D5A1C03D7B42B98_view

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	10:13:05 AM Wednesday, February 17, 2010
Last Modified	10:13:05 AM Wednesday, February 17, 2010

Columns

Name
dis_hw_uuid
discovery_asset_name
dis_asset_serial_num
primary_mac_address
asset_tag
label
discovery_changes_switch
domain_uuid
external_sys_name
discovery_id_1
discovery_id_2
discovery_id_3
discovery_id_4
discovery_id_5
discovery_changed_date
asset_source_uuid
subschema_id
own_resource_uuid
serial_number
resource_alias
resource_name
host_name
sys_model
sys_type
sys_vendor
id_of_last_user
total_memory
total_disk_space
operating_sys
bios_asset_tag
mac_host

Permissions

Type	Action	Owning Principal
Grant	Select	uapmadmin
Grant	Select	uapmbatch
Grant	Select	uapmreporting

SQL Script

CREATE VIEW dbo.arg_DA39A7D5A1C03D7B42B98_view AS SELECT DISTINCT "rhvf".* FROM dbo.arg_discovered_hw_view "rhvf"
GO
GRANT SELECT ON  [dbo].[arg_DA39A7D5A1C03D7B42B98_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_DA39A7D5A1C03D7B42B98_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_DA39A7D5A1C03D7B42B98_view] TO [uapmreporting]
GO

Uses