Push data to AST:AssetPeople form and make sure Asset Instance ID = Reconciliation Identity of asset
Thanks I think it will work, but currently I got Asset Instance ID = Reconciliation Identity of asset value from "BMC.CORE:BMC_BaseElement" Form.
Actually my problem is that I have to create thousands CI which part is already done by me using Data Import Tool on Ast:BusinessService form. I have to assign this CI to Peoples so that people can see CI in their CI tab on CTM:People form. For mapping I have to one by one collect Reconciliation Identity for all CI which all I have created and then perpare CSV data to update inside the people Correct!.
If you have any other way so please suggest to me.
Sorry, It is not working, because I did push data, data pushed successfully but it does not show inside the user' CI Tab on CTM;People form:
Pushed data field names are given below:
IndividualOrGroup,Status,Form Type,PersonRole,Full Name,Login Name,Contact Company,PeopleGroup Form Entry ID,AssetClassId,AssetInstanceId,z1G_Global_AST_ProductionDataSetID
DMT with Transactional_Asset.xlsm spreadsheet should be an option.
How to use DMT with Transactional_Asset_xlsm spreadsheet can you please provide me steps to do this.
There is some information in the documentation: Populating the dataload spreadsheets - Documentation for BMC Remedy IT Service Management Suite 9.1 - BMC Documentation
Basically you need to download the .xlsm and enter the data, in your case the AST_LoadAssetPeople Sheet should be sufficient.
Then you create a new job using the transactional asset template and provide the .xlsm with the data and start the job.