BusinessObjects Board

getting a list of scheduled reports?

I need to get a list of all reports that are scheduled out of business objects. How does one go about that?


jennifer.troyer (BOB member since 2016-05-17)

[Moderator Note: Moving to Server Administration - MichaelWelter]

Welcome to B:bob:B!

Are you familiar with Query Builder? You can use it to query the system database.

I believe this will get all instances:

select SI_NAME, SI_KIND from CI_INFOOBJECTS where SI_INSTANCE=1

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Unfortunately I do not even know what query builder is. I have very basic knowledge with Business objects and am just learning.


jennifer.troyer (BOB member since 2016-05-17)

OK, no worries. What version are you using?


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

SAP Business Objects Desktop XI


jennifer.troyer (BOB member since 2016-05-17)

Query builder should be available at http:///AdminTools/querybuilder/ie.jsp

would be replaced by your BusinessObjects Server.


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

THANK YOU!!!


jennifer.troyer (BOB member since 2016-05-17)

Is there a way to also pull destination and frequency? Thanks in advance.


jennifer.troyer (BOB member since 2016-05-17)

You will have to check the sub-properties of the query provided.


ambarishkunte (BOB member since 2018-11-19)

Is there a way to do this through an ODBC connection to, say, Microsoft Access?

I’m on BI4 4.1 SP7, in the process of migrating to 4.2, and it would be super-helpful to create a checklist.

While I’m at it, has anyone ever done this and also brought over folders, universes, and/or user security details?


Crazy_About_BO :us: (BOB member since 2015-01-20)

Hi,
You may find useful Excel macros under BOBJ Downloads section.


SuKA (BOB member since 2018-10-20)

Wow, that’s an incredible resource!

Thank you!


Crazy_About_BO :us: (BOB member since 2015-01-20)

Since posting this question, I learned about the the new CMS data access driver, introduced in BI4 4.2 SP3, to accomplish the same thing using a universe and Web Intelligence to query the metadata:

https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2

This article was published September 2019.

It doesn’t help me for 4.1, but hey…


Crazy_About_BO :us: (BOB member since 2015-01-20)