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.
You can do this by using a routine similar to the following one:
DECLARE Client_Cursor CURSORFOR 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 ENDCLOSE Client_CursorDEALLOCATE Client_Cursor
Retrieving data ...