Jump to content

SQL update to records


Recommended Posts

We imported all our old data from SupportWorks in Service Manager but the way we were using SupportWorks we didn't often resolve calls we used to just close them instead

We've now changed the way we're handling calls and we set them to resolved and then let the customer close them or let them auto close after x days

In need to report on the resolved date for the calls which is ok for anything we've closed within Service Manager but the h_dateresolved field is blank for thousands of records

Would it cause any issues to run an update query to set h_dateresolved to use the data in h_dateclosed for closed and resolved calls where h_dateresolved is blank?

Is this the SQL I would need to use?

UPDATE h_itsm_requests
SET h_itsm_requests.h_dateresolved = h_itsm_requests.h_dateclosed
WHERE h_status = 'status.closed' AND h_dateresolved IS NULL

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
  • Create New...