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
What dialect of SQL is that? It looks strange to me.
It is standard SQL (ANSI). It should work on all database kinds.
https://www.w3schools.com/sql/sql_delete.asp
https://www.w3schools.com/sql/sql_update.asp
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?
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.
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