Views [dbo].[arg_web_owned_asset_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:21 PM Thursday, February 10, 2011
Last Modified10:33:21 PM Thursday, February 10, 2011
Columns
Name
task_id
reconcile_data_id
owned_serial_number
alias
alt_asset_id
item_name
host_name
Permissions
TypeActionOwning Principal
GrantSelectswcmadmin
SQL Script
CREATE VIEW dbo.arg_web_owned_asset_view
AS
SELECT         rd.task_uuid AS task_id,
        rd.reconcile_data_id,
        oa.serial_number AS owned_serial_number,
                oa.resource_alias AS alias,
        oa.resource_tag AS alt_asset_id,
        oa.resource_name AS item_name,
        oa.host_name
FROM             arg_reconcile_data rd
INNER JOIN    ca_owned_resource oa ON rd.own_resource_uuid = oa.own_resource_uuid
                
WHERE         (rd.reconcile_data_type = 3)
GO
GRANT SELECT ON  [dbo].[arg_web_owned_asset_view] TO [swcmadmin]
GO
Uses