CREATE TABLE [dbo].[arg_reconcile_task]
(
[task_uuid] [binary] (16) NOT NULL,
[task_name] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[task_description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[match_indicator] [smallint] NULL,
[add_assets_indicator] [smallint] NULL,
[asset_changes_indicator] [smallint] NULL,
[own_resource_deletes_indicator] [smallint] NULL,
[own_resource_deactiv_indicator] [smallint] NULL,
[discovery_deleted_indicator] [smallint] NULL,
[undo_match_indicator] [smallint] NULL,
[send_msg_to_queue_switch] [smallint] NULL,
[send_msg_to_event_log_switch] [smallint] NULL,
[send_msg_to_email_switch] [smallint] NULL,
[email_ids] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[watch_os_switch] [smallint] NULL,
[watch_computer_name_switch] [smallint] NULL,
[watch_capacity_indicator] [smallint] NULL,
[load_capacity_indicator] [smallint] NULL,
[set_contact_switch] [smallint] NULL,
[add_item_switch] [smallint] NULL,
[item_translation_list_id] [int] NULL,
[os_translation_list_id] [int] NULL,
[new_asset_status] [int] NULL,
[missing_asset_status] [int] NULL,
[deactivated_asset_status] [int] NULL,
[external_sys_id] [int] NULL,
[locking_flag] [smallint] NULL,
[refresh_interval] [int] NULL,
[last_refresh_date] [datetime] NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__arg_recon__versi__703EA55A] DEFAULT ((0)),
[watch_disk_space_switch] [smallint] NULL,
[watch_memory_switch] [smallint] NULL,
[watch_processor_count_switch] [smallint] NULL,
[watch_processor_speed_switch] [smallint] NULL,
[watch_processor_type_switch] [smallint] NULL,
[watch_last_run_date_switch] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[arg_reconcile_task] ADD CONSTRAINT [XPKarg_reconcile_task] PRIMARY KEY CLUSTERED ([task_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [arg_reconcile_task_idx_01] ON [dbo].[arg_reconcile_task] ([task_name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT INSERT ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT DELETE ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[arg_reconcile_task] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [uapmadmin]
GRANT INSERT ON  [dbo].[arg_reconcile_task] TO [uapmadmin]
GRANT DELETE ON  [dbo].[arg_reconcile_task] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[arg_reconcile_task] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[arg_reconcile_task] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[arg_reconcile_task] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[arg_reconcile_task] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [uapmbatch]
GRANT INSERT ON  [dbo].[arg_reconcile_task] TO [uapmbatch]
GRANT DELETE ON  [dbo].[arg_reconcile_task] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[arg_reconcile_task] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[arg_reconcile_task] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[arg_reconcile_task] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[arg_reconcile_task] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_reconcile_task] TO [uapmreporting_group]
GO