BOB: Business Objects Board
Not endorsed by or affiliated with SAP
Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

  Index | About
Sponsors | Contact Us | Calendar | FAQ | Rules and Guidelines | Privacy Policy | Search 

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

getting a list of scheduled reports?


  		Search this topic... | Search Server Administration, Installation, Upgrades... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades  Previous TopicPrint TopicNext Topic
Author Message
jennifer.troyer
Forum Member
Forum Member



Joined: 17 May 2016

Posts: 8
PostPosted: Tue May 17, 2016 9:49 am 
Post subject: 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?
Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15035
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way

flag
PostPosted: Tue May 17, 2016 10:34 am 
Post subject: Re: getting a list of scheduled reports?
[Moderator Note: Moving to Server Administration - MichaelWelter]

Welcome to Bicon_mrgreen.gifB!

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

I believe this will get all instances:

Code:
select SI_NAME, SI_KIND from CI_INFOOBJECTS where SI_INSTANCE=1

_________________
Michael Welter, BOCP-BOE, Webi Image link
Ark Analytic Solutions
(909)899-3002
______________________
Follow me on Twitter
Latest Blog Posts
• 2020-01-06 Sum Prior Months into Current Month (Webi)
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
Back to top
jennifer.troyer
Forum Member
Forum Member



Joined: 17 May 2016

Posts: 8
PostPosted: Tue May 17, 2016 11:35 am 
Post subject: Re: getting a list of scheduled reports?
Unfortunately I do not even know what query builder is. I have very basic knowledge with Business objects and am just learning.
Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15035
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way

flag
PostPosted: Tue May 17, 2016 11:39 am 
Post subject: Re: getting a list of scheduled reports?
OK, no worries. What version are you using?
_________________
Michael Welter, BOCP-BOE, Webi Image link
Ark Analytic Solutions
(909)899-3002
______________________
Follow me on Twitter
Latest Blog Posts
• 2020-01-06 Sum Prior Months into Current Month (Webi)
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
Back to top
jennifer.troyer
Forum Member
Forum Member



Joined: 17 May 2016

Posts: 8
PostPosted: Tue May 17, 2016 11:41 am 
Post subject: Re: getting a list of scheduled reports?
SAP Business Objects Desktop XI
Back to top
MichaelWelter
Forum Advocate
Forum Advocate



Joined: 08 Aug 2002
ASUG Icon
speaker.gif*6medal_bronze.gif
Posts: 15035
Location: Rancho Cucamonga, CA, USA, Earth, Milky Way

flag
PostPosted: Tue May 17, 2016 2:07 pm 
Post subject: Re: getting a list of scheduled reports?
Query builder should be available at http://<server>/AdminTools/querybuilder/ie.jsp

<server> would be replaced by your BusinessObjects Server.
_________________
Michael Welter, BOCP-BOE, Webi Image link
Ark Analytic Solutions
(909)899-3002
______________________
Follow me on Twitter
Latest Blog Posts
• 2020-01-06 Sum Prior Months into Current Month (Webi)
• 2019-02-22 Tableau Security Made Easy
• 2018-09-20 Hello, Tableau
Back to top
jennifer.troyer
Forum Member
Forum Member



Joined: 17 May 2016

Posts: 8
PostPosted: Tue May 17, 2016 3:51 pm 
Post subject: Re: getting a list of scheduled reports?
THANK YOU!!!!!!!!
Back to top
jennifer.troyer
Forum Member
Forum Member



Joined: 17 May 2016

Posts: 8
PostPosted: Wed May 18, 2016 8:44 am 
Post subject: Re: getting a list of scheduled reports?
Is there a way to also pull destination and frequency? Thanks in advance.
Back to top
ambarishkunte
Forum Member
Forum Member



Joined: 19 Nov 2018

Posts: 2
PostPosted: Mon Jan 07, 2019 5:53 am 
Post subject: Re: getting a list of scheduled reports?
You will have to check the sub-properties of the query provided.
Back to top
Crazy_About_BO
Forum Member
Forum Member



Joined: 20 Jan 2015

Posts: 10
Location: Indianapolis, IN

flag
PostPosted: Thu Jan 09, 2020 3:17 pm 
Post subject: Re: getting a list of scheduled reports?
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?
Back to top
SuKA
Forum Member
Forum Member



Joined: 20 Oct 2018

Posts: 21
PostPosted: Fri Jan 10, 2020 5:11 am 
Post subject: Re: getting a list of scheduled reports?
Hi,
You may find useful Excel macros under BOBJ Downloads section.
Back to top
Crazy_About_BO
Forum Member
Forum Member



Joined: 20 Jan 2015

Posts: 10
Location: Indianapolis, IN

flag
PostPosted: Mon Jan 13, 2020 6:31 pm 
Post subject: Re: getting a list of scheduled reports?
Wow, that's an incredible resource!

Thank you!
Back to top
Crazy_About_BO
Forum Member
Forum Member



Joined: 20 Jan 2015

Posts: 10
Location: Indianapolis, IN

flag
PostPosted: Wed Jan 15, 2020 4:18 pm 
Post subject: Re: getting a list of scheduled reports?
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...
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0314 seconds using 17 queries. (SQL 0.0028 Parse 0.0010 Other 0.0276)
CCBot/2.0 (https://commoncrawl.org/faq/)		 Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo