ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Bulk Edit - Asset Purchase or Lease change
Article ID: 200465
Client Management SuiteAsset Management Solution
Unable to bulk edit the "Purchase or Lease" information for a few hundred machines.
First of all, all the needed machines must be managed and have a registry/entry in the ITMS. That is because we will use the machine's Name and GUID to effectuate the change.
Create a filter/report that will provide you the machine's name and GUID for the machines that you want to change the "Purchase or Lease" information.
Export that information (Name/GUID) to a .csv file
Place the file inside the NS - on a folder/path created by you, and of your choice.
Open the file using any text editor (Ex.: Notepad)
Check if the file is following the below example/pattern
Open the NS Console and go to:
Settings > All Settings > Notification Server > Connector > Data Source
Right-click on the above folder and select New > CSV File Data Source
Give a name to the newly created Data Source
Configure the new Data Source as the following image:
The field "Import from file" might be different on your system.
Save all the changes.
Settings > All Settings > Notification Server > Connector > Import/Export Rules
Right-click on the above folder and select New > Resource Import Export Rule
Give a name to the newly created Resource Import Export Rule
Configure the new Resource Import Export Rule as the following image:
The "Data Source" to be used is the one that you created above
Save all the changes made and click on "Test Rule"
Check the outcome and if the result is what you were looking for.
W e recommend running it for a small number of machines and checking if that worked as expected and didn't cause any issue (it is recommended to have a database backup in case you need to revert the changes) .