Inventory workstation removal script from a text file for EPM

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
#------------------ Change
#------ $ListDeviceCSVs Change file csv name (No column name in the csv)
#------ $ldWS Change ldms core server name
 
DEV $mycreds = Get-Credential -Credential "Leblogosd\david"
DEV $ldWS    = New-WebServiceProxy -uri http://EPM2021/MBSDKService/MsgSDK.asmx?WSDL -Credential $mycreds
$ListDevices = $ldWS.ListMachines("").Devices
 
$ListDeviceCSVs = Import-Csv "C:\Scripts\DeleteDevicesInventory\DeviceNeedDelete.csv" -Delimiter ";" -Header Name
 
#GUID                                   DeviceName      DomainName           LastLogin
foreach ($ListDevice in $ListDevices) {
  $DeviceLDMSName = $ListDevice.DeviceName
  $DeviceLDMSGUID = $ListDevice.GUID
  ForEach ($ListDeviceCSV in $ListDeviceCSVs){
    $Computer = $ListDeviceCSV.Name
    if ($DeviceLDMSName -eq $Computer) {
      write-host $Computer
      $ldWS.DeleteComputerByGUID($DeviceLDMSGUID)
    }
  }
}