declare @i int
declare @identifier uniqueidentifier
declare @uuid uniqueidentifier
declare @productname nvarchar(max)
declare @protectflag bit
declare @name nvarchar(max)
declare @managedstatus int
declare @summarystatus int
declare @location nvarchar(max)
declare @substanceflag bit
declare @type int
declare @path nvarchar(max)
declare @managedsubstatus int
declare @lastupdatedate datetime
declare @threadid nvarchar(max)
declare @managerid uniqueidentifier
declare @managerid1 uniqueidentifier
declare @managerid2 uniqueidentifier
set @i = 1
while @i < 3000
begin
set @managerid = 'a9b47402-ada9-e311-a64d-782bcb92e944'
set @i =@i +1
set @identifier = newid()
set @uuid = newid()
set @productname = 'vmware virtual machine 10'
set @protectflag = 0
set @name = right('vm-test' + cast(@i as nvarchar(max)),20)
set @managedstatus = 2
set @summarystatus = 32
set @location = 'storage_1.82t'
set @substanceflag = 1
set @type = 1114112
set @path = right('[storage_1.82t] vm1_byvmclone/vm-test.vmx' + cast(@i as nvarchar(max)), 50)
set @managedsubstatus = 1
set @threadid ='4'
set @lastupdatedate = cast('2014-03-12 14:10:56.660' as datetime)
set @managerid1 = '4deb2d12-ada9-e311-a64d-782bcb92e944'
set @managerid2 = 'e1f45d47-b7bf-e311-a9c7-782bcb92e944'
insert into [dbo].[tbl_machine]
([identifier]
,[uuid]
,[productname]
,[protectflag]
,[name]
,[managedstatus]
,[summarystatus]
,[location]
,[substanceflag]
,[operatingsystemstatus]
,[type]
,[path]
,[managedsubstatus]
,[threadid]
,[lastupdatedate])
values
(@identifier,
@uuid,
@productname,
@protectflag,
@name,
@managedstatus,
@summarystatus,
@location,
@substanceflag,
1,
@type,
@path,
@managedstatus,
@threadid,
@lastupdatedate)
insert into [dbo].[tbl_managerrelation]
([managerid]
,[targetid]
,[managementkey]
,[threadid]
,[lastupdatedate])
values
(@managerid,
@identifier,
@name,
@threadid,
@lastupdatedate
)
insert into [dbo].[tbl_managerrelation]
([managerid]
,[targetid]
,[managementkey]
,[threadid]
,[lastupdatedate])
values
(@managerid1,
@identifier,
@name,
@threadid,
@lastupdatedate
)
insert into [dbo].[tbl_managerrelation]
([managerid]
,[targetid]
,[managementkey]
,[threadid]
,[lastupdatedate])
values
(@managerid2,
@identifier,
@name,
@threadid,
@lastupdatedate
)
end