Client Management Suite

 View Only
  • 1.  Delete/retire a computer via VBS

    Posted Nov 12, 2012 07:26 PM

    Hello, 

    Is there a VBS script out there to automatically delete or retire a computer from Altiris 7.1.  Long term thinking would be the ability to massively delete multiple computers at a time.   This would be used for computers that were set to be recycled.     

    I have purging maintenance set up, what I looking for is a "on demand" solution.   

     

     



  • 2.  RE: Delete/retire a computer via VBS

    Posted Nov 13, 2012 07:39 AM

    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"



  • 3.  RE: Delete/retire a computer via VBS

    Posted Nov 13, 2012 09:46 AM


  • 4.  RE: Delete/retire a computer via VBS



  • 5.  RE: Delete/retire a computer via VBS

    Posted Dec 12, 2012 01:19 PM

    Anyone have a retire computers from file script...

     

    NS 7.1.8280