We are about to migrate (full content copy) & update our SAP BO 4.2 (dev and prod) environment from current servers to newly installed servers with latest version SAP BO 4.3 (we do change also database server, not only SAP BO server). So, both environments will be alive certain time and we basically need to create exact copy.
There is a need to migrate also local instances, but it would be desirable to copy only last X instances. In current environment, no limits are set and FRS is huge (more than 2T). No changes can be made on current environment.
I have reviewed lot of SAP notes, migration best practices etc., but I could not find if there is a way to migrate only last X instances (e.g. last 5).
Is this possible? If so, can you share how that query would look like?
This isn’t the query I was looking for but I can’t find it at the moment. It will demonstrate the basics of how to structure your query. This query will only pull a specific day’s worth of report instances so you would need to modify it to also pull reports without instances and change the SI_CREATION_TIME to a > reference to the date you want.
SELECT TOP 100000 static, relationships, SI_PARENT_FOLDER_CUID, SI_OWNER, SI_PATH FROM CI_INFOOBJECTS,CI_APPOBJECTS,CI_SYSTEMOBJECTS WHERE DESCENDANTS(“SI_NAME=‘Folder Hierarchy’”, “SI_ID in (23)”) And (SI_LAST_SUCCESSFUL_INSTANCE_ID Is Not Null Or SI_INSTANCE = 1) AND NOT (SI_KIND In (‘MON.Probe’, ‘Program’)) and SI_RECURRING = 0 AND SI_CREATION_TIME Between ‘2024-03-24.00.00.00’ And ‘2024-03-25.00.00.00’
Thank you John, your query is based on dates, so I can pull let’s say last 6 months of instances. But I was looking for to pull last e.g. 5 instances. The problem is, this is not date related, some objects can have more instances even within same week and some would go few weeks or even months back. I hope it’s clear what I mean.