Delete Device(s) from DeviceHub on multiple Litmus Edge

to delete device(s) with litmus excel add ins, you should be familiar with how devices work in devicehub docid\ tgmyvezsra7ydtegxdvv4 on litmus edge as well as the consequences before you begin you have installed the litmus excel add ins extension see install litmus excel add ins docid\ gzdhbj1xzznddthyocuuu for details you have prepared a prepare a new tool file to manage devicehub device(s) on multiple litmus edge docid 0m77drmbjd gybmtiwqwa devices have been add device(s) to devicehub for multiple litmus edge docid\ d abegnsfrz0o2tyvmgnt to devicehub initial preparation open a new device management tool file in excel if prompted, enable content to allow the code to run make sure the the tool is set to multiple le for the connect to option delete device(s) import devices import the device settings for devices defined on litmus edge using the import device(s) wizard docid\ l0cy8amra80rny4x pt3k users can set a filter to reduce the number of devices shown as selection to the user le device ip select or enter the ipv4 of the litmus edge you want to import devices from notes you may need to provide the api key if the litmus edge has not been used with the tool search option select what type of filter is to be used device name mask set the filter to be applied will be ignored if search option is set to all the wizard will show what filter will be applied press the search button to pull the filtered list of devices from litmus edge the user will be shown the filtered list of devices matching their filter select the devices to import and press the import button notes users can choose between press new search to set another filter and search again if the list doesn't show the devices the user wanted to import select all devices using the checkbox in the header row select a group of devices by selecting their respective check box select one device by selecting the respective check box select no device and close the wizard pressing the close button instead the selected device(s) with their settings are imported into the sheet once finished, the user can either p erform another search using the new search button finish the import using the close button the action for each imported device is set to m for modify mark devices for deletion change the action to d for the device(s) you want to delete on litmus edge notes set the action to i for ignore for devices in the sheet you do not want to process executing actions if the tool also includes devices with either the action a or m , it is recommended but not mandatory to verify the configuration first without executing the action by pressing the verify only button this will check that all required device settings are provided and logically correct and provide any finding to the user example below the user did select to have meta data but did not provide any important the tool can not verify if all provided device settings are factually correct for example it can not verify that the network address provided for the plc is the correct ip address the device(s) can be deleted on litmus edge by pressing the verify + execute button the tool will group all the devices based on the litmus edge(s) defined in column target litmus edge ip for each litmus edge this will check that all required device settings are provided and logically correct and provide any finding to the user if no issues have been identified, the tool will verify that the user wants to execute all the actions from the action column for this device a add device(s) m modify device(s) d delete device(s) i ignore device(s) > do nothing to perform all actions for the litmus edge, press the yes button the tool will perform all actions row by row for the litmus edge when finished, a result summary is shown for each litmus edge close the result summary by pressing the x close button to continue with the next litmus edge once all litmus edge have been processed, the tool will ask if the user wants to re compare the device(s) against litmus edge to re compare, press the yes button to not re compare, press the no button if the user selected to press the yes button from aboves messagebox, the tool will pull all the device settings from litmus edge again including the deviceid and also change the action to m for each device with a deviceid or a for devices with no deviceid devices with an action of i will not be updated