Views [dbo].[arg_OA39A7D5A1C03D7B42B98_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:13:05 AM Wednesday, February 17, 2010
Last Modified10:13:05 AM Wednesday, February 17, 2010
Columns
Name
own_resource_uuid
item_name
item_abrev
asset_source_uuid
mac_address
dns_name
resource_capacity
alt_asset_id
alias
operating_system
serial_number
host_name
contact_name
contact_uuid
vendor
manufacturer
capacity_units
subclass
class
dis_hw_uuid
external_sys_name
model_uuid
subschema_id
resource_name
floor_location
room_location
cabinet_location
shelf_location
slot_location
purchase_order_id
resource_family
location_name
department
cost_center
exclude_reconciliation
alternate_host_name
discovery_last_run_date
previous_resource_tag
processor_count
processor_speed
processor_speed_units
processor_type
reconciliation_date
total_disk_space
total_disk_units
total_memory
total_memory_units
mac_host
company_bought_for
portfolio_status
Permissions
TypeActionOwning Principal
GrantSelectuapmadmin
GrantSelectuapmbatch
GrantSelectuapmreporting
SQL Script
CREATE VIEW dbo.arg_OA39A7D5A1C03D7B42B98_view AS SELECT DISTINCT "rvf".* FROM dbo.arg_reconcile_view "rvf" WHERE ((("rvf".class = 'Desktop'))) OR ((("rvf".manufacturer = 'Dell Inc.')))
GO
GRANT SELECT ON  [dbo].[arg_OA39A7D5A1C03D7B42B98_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_OA39A7D5A1C03D7B42B98_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_OA39A7D5A1C03D7B42B98_view] TO [uapmreporting]
GO
Uses