JAquino Posted November 6, 2020 Share Posted November 6, 2020 Hi We have noticed an error in our asset data that was originally imported in to our system, which is ow causing issues with reporting. The field is h_company_id in the h_cmdb_assets table. A number of our imported records have a space in the company IDs which we need to remove. Is there any way to amend this without exporting and reimporting the data again? I would have used Database direct to run and update command, but it looks like this is locked down to select queries only now. Boo Cheers Link to comment Share on other sites More sharing options...
Deen Posted November 6, 2020 Share Posted November 6, 2020 @JAquino Not from what I can see, it may be the case that you will need to carry out another import with the amended data and the import set to update the existing asset records. Link to comment Share on other sites More sharing options...
JAquino Posted November 9, 2020 Author Share Posted November 9, 2020 ok thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now