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

5 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?

  2. Hi, it is always better to use it on a test environment first.
    The impact you may have are on the PM which are meter based, you would need to ensure the PM meters to be aligned, with the assetmeter.

    The same can be applied on the location meter table.

  3. Dear All,

    I have a requirement to load all the meter readings to Maximo along with reset meter readings.
    Using Mxloader to load meter readings , tried passing values to LASTREADINGNEW and LASTREADINGDATENEW non persistent attribute – but reset transaction/meter reading is not getting recorded. (Not throwing any errors also)

    Is there a way to load the reset meter readings into Maximo Via Mxloader.

    Thank you in advance.

    Regards
    Divyani Kulkarni

Leave a Reply

Your email address will not be published.


Scroll to top