Maximo Open Forum

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

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

Original Message:
Sent: 07-23-2022 13:43
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

Hi Keith,
Thanks for your response.
Yes snapshot means two full db backup's taken on different intervals.

Regards,
Pradeep

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

Original Message:
Sent: 07-25-2022 16:52
From: keith simmons
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

Original Message:
Sent: 07-23-2022 13:43
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

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

Original Message:
Sent: 07-26-2022 02:33
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

Hi Keith,
Thanks for your response.
Yes snapshot means two full db backup's taken on different intervals.

Regards,
Pradeep

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

Original Message:
Sent: 07-25-2022 16:52
From: keith simmons
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

Original Message:
Sent: 07-23-2022 13:43
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

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

Original Message:
Sent: 07-23-2022 13:43
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

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

Original Message:
Sent: 07-28-2022 08:20
From: Craig Kokay
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

Original Message:
Sent: 07-23-2022 13:43
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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

If you want to track the delta of spareparts, you can turn on eAudit.

https://bportaluri.com/2016/11/tracking-changes-using-audit-feature.html

This creates an audit table that will track your insert, update, and deletes. Specify what columns you want to track so you limit the data you want to track. 

If you really want to torture yourself with comparing data on the table level feel free, but I don't feel it is an efficient approach since you are separated from the data context. Unless you know how the Maximo data is structured, reviewing the differential may not be so helpful. If the purpose is to reconstruct data during a cut-over period, eaudit could work better for you.


Original Message:
Sent: 07-23-2022 13:43
From: Pradeep Rout
Subject: How to identify delta data (Insert,Upadate,Delete) from two snapshots

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