Solved

How can I delete a computer from SCCM using VB.NET (2010)

Posted on 2010-09-23
5
3,543 Views
Last Modified: 2013-11-25
Hi there,

I would like to delete a computer from SCCM (completely delete the record) using VB.NET (2010).  Currently, I use a VB Script and pass arguments to it.  Can anyone tell me how to put this in VB.NET 2010 please?  VBS attached.

Thanks :)
Set args = WScript.Arguments

strSMSServer = args.Item(0)
strSMSSiteCode = args.Item(1)
strUserName =  args.Item(2)
strPassword =  args.Item(3)
strComputer = args.Item(4)

Set lLocator = CreateObject("WbemScripting.SWbemLocator")  
Set gService = lLocator.ConnectServer(strSMSServer,"root\sms\site_" & strSMSSiteCode, strUserName, strPassword)  
Set ResIDs = gService.ExecQuery("SELECT * from SMS_R_System where NetbiosName = '" & strComputer & "'")  

for each oResID in ResIDs
 	oResID.Delete_
Next
Wscript.Quit

Open in new window

0
Comment
Question by:jamie77777
  • 3
  • 2
5 Comments
 
LVL 31

Expert Comment

by:merowinger
ID: 33805637
Hi, i've created a very simple example for you. There no much error handling in, but i think it's a good start.
I've solved it with Textboxes where you've to define you SCCM Site, the credentials and the pc to delete form the database
Untitled.png
0
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 33805641
And here's the matching vb.net code for this:
Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim strComputer = TextBox1.Text
        Dim strSMSServer = TextBox2.Text
        Dim strSMSSiteCode = TextBox3.Text
        Dim strUserName = TextBox4.Text
        Dim strPassword = TextBox5.Text
        Dim ResIDs

        Try
            Dim lLocator = CreateObject("WbemScripting.SWbemLocator")
            Dim gService = lLocator.ConnectServer(strSMSServer, "root\sms\site_" & strSMSSiteCode, strUserName, strPassword)
            ResIDs = gService.ExecQuery("SELECT * from SMS_R_System where NetbiosName = '" & strComputer & "'")

        Catch ex As Exception
            MsgBox("Could not connect to SCCM Server - ErrorDescription:" & Err.Description)
            End
        End Try

        Try
            For Each oResID In ResIDs
                oResID.Delete_()
            Next
            MsgBox("Deletion successfully")
        Catch ex As Exception
            MsgBox("Could not delete " & strComputer & " - ErrorDescription:" & Err.Description)
        End Try
    End Sub

End Class

Open in new window

0
 

Author Comment

by:jamie77777
ID: 33818496
Cool thanks, will test...
0
 

Author Comment

by:jamie77777
ID: 33818605
Thanks, worked perfectly!  Have changed it to a function and attached here in case others wanted it.  Thank you very much!
Public Function DeleteFromSCCM(ByVal strComputer As String, _
                                       ByVal strSCCMServer As String, _
                                       ByVal strSCCMSiteCode As String, _
                                       ByVal strUserName As String, _
                                       ByVal strPassword As String)
        Dim oResID
        Dim ResIDs

        Try
            Dim lLocator = CreateObject("WbemScripting.SWbemLocator")
            Dim gService = lLocator.ConnectServer(strSCCMServer, "root\sms\site_" & strSCCMSiteCode, strUserName, strPassword)
            ResIDs = gService.ExecQuery("SELECT * from SMS_R_System where NetbiosName = '" & strComputer & "'")
        Catch ex As Exception
            MsgBox("Error: " & Err.Number & ": " & Err.Description)
            Return False
            End
        End Try

        Try
            For Each oResID In ResIDs
                oResID.Delete_()
            Next
            MsgBox("Successfully deleted computer: " & strComputer & " from SCCM!")
            Return True
        Catch ex As Exception
            MsgBox("Error: " & Err.Number & ": " & Err.Description)
            Return False
        End Try

    End Function

Open in new window

0
 

Author Closing Comment

by:jamie77777
ID: 33818608
Complete.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Exit the loop 4 42
How to resolve user quota error? 13 65
Variable Event ? 3 27
Disable extension 8 36
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now