[dbo].[tng_add_managedobject]
CREATE procedure dbo.tng_add_managedobject (
@uuid UUID,
@name varchar(255) =null,
@label varchar(255) =null,
@address varchar(255) =null,
@address_type int=null,
@class_name varchar(30),
@interface_type int =null,
@hidden tinyint=null,
@propagate_status tinyint=null,
@status_no int =null,
@severity int =null,
@autoarrange_type int=null,
@posted tinyint=null,
@acknowledge tinyint=null,
@ip_address_hex binary(4)=null,
@mac_address varchar(12) =null,
@subnet_mask binary(4)=null,
@date_ins datetime=null,
@date_modify datetime=null,
@alarmset_name varchar(30)=null,
@override_imagelarge varchar(64)=null,
@override_imagesmall varchar(64)=null,
@override_imagedecal varchar(64)=null,
@override_imagetintbool tinyint=null,
@override_model varchar(64)=null,
@background_image varchar(64) =null,
@source_repository varchar(64) = null
)
as
select @source_repository = (@@servername + ':ODBC')
INSERT INTO tng_managedobject ( uuid, name, label, address,
address_type, class_name, interface_type, hidden, propagate_status, status_no, severity, posted,acknowledge,autoarrange_type ,ip_address_hex, mac_address, subnet_mask, date_ins, date_modify,
alarmset_name,override_imagelarge, override_imagesmall, override_imagedecal,override_imagetintbool, override_model,background_image,source_repository)values( @uuid,@name,@label,@address,@address_type,@class_name,@interface_type,@hidden,
@propagate_status,@status_no,@severity,@posted,@acknowledge,@autoarrange_type,
@ip_address_hex,@mac_address,@subnet_mask,@date_ins,@date_modify,
@alarmset_name,@override_imagelarge,@override_imagesmall,@override_imagedecal,
@override_imagetintbool,@override_model,@background_image,@source_repository)
if @@error !=0
raiserror ('MSG:(90031) Insert tng_managedobject error,@name=%s, @label=%s, @class_name=%s. @ip_address_hex=%x',16, -1, @name, @label,@class_name, @ip_address_hex )
return
GO
GRANT EXECUTE ON [dbo].[tng_add_managedobject] TO [uniadmin]
GRANT EXECUTE ON [dbo].[tng_add_managedobject] TO [wvadmin]
GO
