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

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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

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:
Sent: Thu April 01, 2021 08:03 AM
From: Steven Shull
Subject: mass Workorder deletion

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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

#Maximo
#AssetandFacilitiesManagement

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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

Excellent points.   Maybe Service Provider would be a good fit?

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

Original Message:
Sent: Thu April 01, 2021 04:17 PM
From: Bradley Downing
Subject: mass Workorder deletion

Aside from the technical and licenigns 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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

Original Message:
Sent: 4/1/2021 7:03:00 PM
From: Steve Hauptman
Subject: RE: mass Workorder deletion

Excellent points.   Maybe Service Provider would be a good fit?

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

Original Message:
Sent: Thu April 01, 2021 04:17 PM
From: Bradley Downing
Subject: mass Workorder deletion

Aside from the technical and licenigns 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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

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:
Sent: Fri April 02, 2021 10:31 AM
From: david spoor
Subject: mass Workorder deletion

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:
Sent: 4/1/2021 7:03:00 PM
From: Steve Hauptman
Subject: RE: mass Workorder deletion

Excellent points.   Maybe Service Provider would be a good fit?

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

Original Message:
Sent: Thu April 01, 2021 04:17 PM
From: Bradley Downing
Subject: mass Workorder deletion

Aside from the technical and licenigns 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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

Original Message:
Sent: 4/2/2021 10:47:00 AM
From: Bradley Downing
Subject: RE: mass Workorder deletion

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:
Sent: Fri April 02, 2021 10:31 AM
From: david spoor
Subject: mass Workorder deletion

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:
Sent: 4/1/2021 7:03:00 PM
From: Steve Hauptman
Subject: RE: mass Workorder deletion

Excellent points.   Maybe Service Provider would be a good fit?

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

Original Message:
Sent: Thu April 01, 2021 04:17 PM
From: Bradley Downing
Subject: mass Workorder deletion

Aside from the technical and licenigns 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

Original Message:
Sent: Wed March 31, 2021 02:16 PM
From: david spoor
Subject: mass Workorder deletion

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

#Maximo
#AssetandFacilitiesManagement