Jump to content

Bulk amendment to Asset data


JAquino
 Share

Recommended Posts

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...