Question:
Any idea how to identify all webi documents containing query(ies) sourced from OneDrive?
Details:
We're using SAP Business Objects Version : 14.3.3.4562.3 (4.3 SP3 P3) in a multi-node/clustered environment. We've enabled the tokens for saving/sourcing data to/from OneDrive. This has worked well for about 90 days and we're finding tokens are beginning to expire. A SAP KB article has indicated multi-node environments this can occur and requires a config change to ensure the excel services run on the same node as the AuthToken saved (See Note https://me.sap.com/notes/3117434). However, the next patch we are moving to doesn't appear to have this issue. We're in a period of lockdown where we will not make updates to a production environment due to increased risk exposure of outages. Therefore we're wanting to check to see how big of a problem we may have. For this period we may take preventative steps by having users Delete/Re-add their Auth Tokens ever 30-60 days. But to do so I need to identify all webi documents, schedules, publications which make use of resources from OneDrive.
The following Query Builder query looks like it identifies all the times OneDrive is used as as a "Destination".
SELECT TOP 10000 SI_SCHEDULEINFO.SI_DESTINATIONS, *
FROM CI_INFOOBJECTS
WHERE SI_SCHEDULEINFO.SI_DESTINATIONS LIKE '%Microsoft%'
However I'm struggling with identifying all the times oneDrive is used as a "source"
I created a new webi document with a known Excel data source and evaluated the CI_INFOOBJECTS to see if I could find any attribute which would indicate oneDrive as a source. I found nothing aside from the SI_WEBI_DOC_PROPERTIES indicating the document was sourced from a .xlsx; but there's nothing to say that isn't on the webserver itself.
Any idea how to identify all webi documents containing query(ies) sourced from OneDrive?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.