This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Dear Maximo Experts,
Does anyone know how to retrieve asset downtime data through SQL or Mbo? since it's in non persistent table. (asset application -> Select Action -> Manage downtime history)
Thank you..
Best Regards,
Tommy
Asset downtime is calculated in the assetstatus table for SQL.
I am not sure where downtime is in mbo but I found the function calculateDowntime in the Asset mbo. It would be a good starting point.
>> Does anyone know how to retrieve asset downtime data through SQL or Mbo?
since it's in non persistent table. (asset application -> Select Action ->
Manage downtime history)
If the mbo is non-persistent then from a java/mbo perspective you should be
able to instantiate it and reference the data as with any other mbo, the
only difference being that it will calculate the data for you rather than
persisting it to the database. If you want to determine the downtime using
another algorithm or via SQL you'll need to determine what approach you
desire, one way would be to trace how Maximo calculates it then replicate
that via SQL.
As has been mentioned it appears that Maximo calculates the downtime using
calculateDownTime() from the ASSET mbo, I think the easy way however is to
use the non-persistent MBO, that is afetr all what it is for :)
Chris.
On Wed, Nov 19, 2014 at 11:52 AM, krosemanp@ci.superior.wi.us [MAXIMO] <
MAXIMO@yahoogroups.com> wrote:
>
>
> Asset downtime is calculated in the assetstatus table for SQL.
>
> I am not sure where downtime is in mbo but I found the function
> calculateDowntime in the Asset mbo. It would be a good starting point.
>
>
>
>
>