Hi.
I created this script to delete computers from a txt file (one computer pr line). Modify as needed.
' Migration - remove computers from old Altiris, when using new solution
' Written october 2012 by Torbjørn Remmen Syscom
On Error Resume Next
' Database connection
set db_new = createObject("adodb.connection")
db_new.open "provider=sqloledb;data source=databaseserver;initial catalog=symantec_cmdb;user id=SQLUser;password=SQLpasswod"
' Loop Windows XP
Set objFileToRead = CreateObject("Scripting.FileSystemObject").OpenTextFile("C:\temp\windowxp.txt",1)
Dim strLine
do while not objFileToRead.AtEndOfStream
strLine = objFileToRead.ReadLine()
sql = "select guid from vCMDBComputer where name like '" & strLine & "' "
set rs_new = db_new.execute(sql)
db_new.execute("insert into itemtodelete(guid) values('" & rs_new(0) & "') ")
loop
msgbox "Done"