Maximo Open Forum

 View Only
  • 1.  How to identify delta data (Insert,Upadate,Delete) from two snapshots

    Maximo Certified
    Posted 22 days ago
    Hello Experts,
    Please let me know if i have 2 data base snapshots and i want to identify changes made between a specific date range like Insert , Update and Delete, How can i query this?
    I know Maximo has an attribute called Changedate which holds the cahnge information but this attribute s not present in most of the related objects.
    For example in SPAREPART object there is no changedate information so whenever a new sparepart added to Asset how can i identify and track this change.
    Similarly if something gets removed from sparepart how can i track .

    FYI i need this information to prepare data migration SYNC approach.
    #Architecture
    #Assets
    #Integrations

    ------------------------------
    Pradeep Rout
    TCSL
    ------------------------------


  • 2.  RE: How to identify delta data (Insert,Upadate,Delete) from two snapshots

    Solution Provider
    Posted 20 days ago
    Hi Pradeep, Usually, this is something you would pre plan prior to requiring the information for diff'ing a db. What do you mean snapshot? If that's two full db backup's, there are tools that can diff your db...

    ------------------------------
    keith simmons
    Aquitas Solutions
    ------------------------------



  • 3.  RE: How to identify delta data (Insert,Upadate,Delete) from two snapshots

    Maximo Certified
    Posted 20 days ago
    Hi Keith,
    Thanks for your response.
    Yes snapshot means two full db backup's taken on different intervals.

    Regards,
    Pradeep

    ------------------------------
    Pradeep Rout
    TCSL
    ------------------------------



  • 4.  RE: How to identify delta data (Insert,Upadate,Delete) from two snapshots

    Solution Provider
    Posted 20 days ago
    so, the question becomes, what is the db vendor and are you comparing the schema, the data or both? There are tools available for MS SQL. I seem to remember there are more generic tool sets too. I'm not clear if this is an on going dynamic update requirement (in which case you might use the MIF), or a point in time where there are two dissimilar schemas where you would like to sync the underlying data...

    ------------------------------
    keith simmons
    Aquitas Solutions
    ------------------------------



  • 5.  RE: How to identify delta data (Insert,Upadate,Delete) from two snapshots

    Maximo Certified
    Posted 18 days ago
    Hi Pradeep,

    The simple answer is ROWSTAMP.  However, that does not tell you what was changed only that there was a change.  Good luck with your efforts.

    ------------------------------
    Regards,
    Craig Kokay
    ISW
    Maximo Practice Manager
    eMail: ckokay@isw.net.au
    Phone: +61-411-682-040

    #IBMChampion2022
    ------------------------------



  • 6.  RE: How to identify delta data (Insert,Upadate,Delete) from two snapshots

    Solution Provider
    Posted 17 days ago
    So, you could simply write procedures in what ever db(s) your using, or you could use a tool like SQL Examiner, or the tools provided with MS SQL Server, however, if this is a Maximo application db, there are other considerations regarding the data that is the application meta data definitions and possibly corresponding static and transactional data. There isn't enough information in your messages to ascertain the scope of what you want to do, so the assumption that simply copying data from A to B is optimistic at best. But that's just me...

    ------------------------------
    keith simmons
    Aquitas Solutions
    ------------------------------