IT Service Desk

As part of the new asset creation process, the team will be contacted by the Asset Management Team to update the asset characteristics for any new assets that have been created. 

They will provide the Asset Reference for the New Asset and the Asset Reference for the Parent Asset.

In the CX Live Database you will need to run the following script:

NOTE: You will need to run the following Select statement first in order to obtain the Asset IDs for each Asset.

SELECT * FROM Asset WHERE AssetReference = 'INSERT ASSET REFERENCE'

Once the Asset IDs are obtained, paste them into the below query:

BEGIN TRAN

    INSERT INTO AssetCharacteristic (AssetId, CharacteristicTypeId, TextValue, DateValue, IntValue, DecimalValue, BitValue, EffectiveFromDate)

    SELECT 'INSERT ASSETID OF NEW ASSET', CharacteristicTypeId, TextValue, DateValue, IntValue, DecimalValue, BitValue, getdate()

    FROM AssetCharacteristic

    WHERE AssetId = 'INSERT ASSET ID TO COPY FROM'

ROLLBACK TRAN

--COMMIT

Once that is complete, respond to the Asset Management Team to let them know the asset characteristics have been updated.