Skip navigation

Log in to create and rate content, and to follow, bookmark, and share content with other members.

Automation of machines removal

Discussion created by kishan.pant@chemtrolsinfotech.com

on Dec 2, 2019
Latest reply on Dec 3, 2019 by Samuel

Like • Show 0 Likes0
Comment • 1

We can automate machines removal from AD, SCCM and Antivirus by using command line after machine decommission.

As same way above, we need to remove machines from (SLM & SIS) after assets decommission.

Is above feasible? OR any way to achieve.

Outcomes

1 Reply

Samuel Dec 3, 2019 12:20 PM
Hi Kishan,
You can do this by using a routine similar to the following one:
DECLARE Client_Cursor CURSOR
FOR
SELECT DISTINCT c.ComputerID FROM tblComputer c
[put your JOIN and WHERE filters here]
OPEN Client_Cursor
FETCH NEXT FROM Client_Cursor INTO @ComputerID
WHILE (@@FETCH_STATUS = 0)
  BEGIN
   EXEC ComputerDelete @cidvalue, @ComputerID, 'Automatic deletion of old computers by custom routine'
   FETCH NEXT FROM Client_Cursor INTO @ComputerID
  END
CLOSE Client_Cursor
DEALLOCATE Client_Cursor
2 people found this helpful
Like • Show 1 Like1
Actions

Recommended Content