Reset all meter readings

On a development/test environment today I had to reset all meter readings. Maximo is storing the last readings in a set of fields of the ASSETMETER table and the reading history in the METERREADING table.

Here are the SQL statements I have used.

delete from meterreading;

update assetmeter
set lastreading=0, lastreadingdate=null,
sincelastrepair=0, sincelastoverhaul=0, sincelastinspect=0,
sinceinstall=0, lifetodate=0, average=0,
lastreadinginspctr=null;
Reset all meter readings

3 thoughts on “Reset all meter readings

  1. Was this just done in a test environment? Would you advise if there would be any knock on effects in a production environment to completely reset the meters and life to date?

Leave a Reply

Your email address will not be published. Required fields are marked *

Scroll to top