Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  mass Workorder deletion

    Posted 03/31/21 03:54 PM
    Our company wants to use their maximo database to copy to another instance which will be used by one of our contract companies. Once copied, we want to delete 'most' of the workorders and related data in the system and leave only workorders that pertain to the contractor. Is there a 'proper' method of doing this?

    ------------------------------
    david spoor
    ------------------------------

    #AssetandFacilitiesManagement
    #Maximo


  • 2.  RE: mass Workorder deletion

    Posted 04/01/21 08:03 AM
    The closest thing to "proper" here is archiving solutions like IBM Optim, though there are third party solutions as well such as Maxis. Deleting WOs have to be done with SQL (there's only a few situations you can delete a WO through MBOs) and because it's the critical function in Maximo, it touches many tables in Maximo. Some (like MATRECTRANS) you may decide to leave as orphaned records in your system but others (like ASSETHIERARCHY) you'd want to purge so it requires some analysis as to what you remove as well.

    ------------------------------
    Steven Shull
    Director of Development
    Projetech Inc
    Cincinnati OH
    ------------------------------



  • 3.  RE: mass Workorder deletion

    Posted 04/01/21 02:10 PM
    I agree with Steve S.  Another option could be to start with an empty Maximo database and use Migration Manager and/or app export/import to move the appropriate data.  The usefulness of this will depend on the amount of configuration as well as how much other data is needed.

    ------------------------------
    Steve Hauptman
    ------------------------------

    Original Message


  • 4.  RE: mass Workorder deletion

    Posted 04/01/21 04:18 PM
    Edited by System Admin 03/22/23 11:44 AM
    Aside from the technical and licensing issues, I have a question for you regarding the work order history against assets going forward.  Presumably the contractor is taking care of some subset of the Assets and or locations for you Org/ Site combination, and it is not all of the Assets and or Locations.  If you segregate the data, how do you propose to put it all back together for consistent and cumulative reporting on your asset reliability and total cost of ownership for your asset management strategy?

    It might be preferable to other tools and techniques to limit access to your database for your contractor.  Application restrictions, data restrictions, security groups, etc.  Perhaps I am missing something here or am reading into your words here.  What is the business objective? Simply separating the data is all well and good but it may introduce other problems and be more difficult to resolve down the road depending on what you are trying to accomplish.

    ------------------------------
    Bradley K. Downing , MBA
    IBM Certified Adv. Deployment Prof. Maximo v7.6.1
    IBM
    Bakersfield CA
    ------------------------------



  • 5.  RE: mass Workorder deletion

    Posted 04/01/21 07:03 PM
    Excellent points.   Maybe Service Provider would be a good fit?

    ------------------------------
    Steve Hauptman
    ------------------------------

    Original Message


  • 6.  RE: mass Workorder deletion

    Posted 04/02/21 10:32 AM
    I agree that using data restrictions and security groups is far easier, and probably a smarter way to go, but I had no input into this executive decision. 



    Original Message


  • 7.  RE: mass Workorder deletion

    Posted 04/02/21 10:47 AM
    Wow!  ouch.. that hurts.... Kinda interesting that Execs would put their Maximo at risk like that.  So decision made and you have to go that way? despite technical costs and challenges?  Any way to point out how expensive it is compared to other technical solutions as well as pointing out license risks?  Just asking...  With no irony and all compassion, good luck with this part of your journey.

    ------------------------------
    Bradley K. Downing , MBA
    IBM Certified Adv. Deployment Prof. Maximo v7.6.1
    IBM
    Bakersfield CA
    ------------------------------

    Original Message


  • 8.  RE: mass Workorder deletion

    Posted 04/05/21 11:55 AM
    There is no licensing risk as all parties already have the appropriate licensing



    Original Message


Related Content