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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

Audit Universe Folder Path


 
Search this topic... | Search Auditor... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Auditor  Previous TopicPrint TopicNext Topic
Author Message
zulu1900
Principal Member
Principal Member



Joined: 27 Jul 2005

Posts: 280



PostPosted: Tue Apr 02, 2019 7:01 pm 
Post subject: Audit Universe Folder Path

Hello,
I've installed Oracle Audit universe. I've configured it in CMC, took default configuration and also selected the following Event details:
1. User Group Details
2. Folder Path Details

However, when I create a report off of Audit universe selecting "Object Folder Path", it does not return anything other than "Auditing" folder path.
I want to see all the folders from /Public/; I've about 40 folders within /Public/.

I'm running it on BO 4.2 SP4.

What I'm missing?

Thanks for your help!
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19261
Location: Bratislava


flag
PostPosted: Wed Apr 03, 2019 1:22 am 
Post subject: Re: Audit Universe Folder Path

Hi,

Check in CMC\Auditing whether the 'Folder Path Details' setting is checked. If it's not then this type of information has not been collected by your Auditing yet.

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
zulu1900
Principal Member
Principal Member



Joined: 27 Jul 2005

Posts: 280



PostPosted: Wed Apr 03, 2019 6:11 am 
Post subject: Re: Audit Universe Folder Path

Does it take time (a day may be?)?
or should I restart SIA?
or do I've to open and refresh report from each folder to get it written to Audit?
or do I've to import universe refresh it and publish it back?

I selected those two options and that's about it. I thought the folder name would then be immediately available to create report.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19261
Location: Bratislava


flag
PostPosted: Wed Apr 03, 2019 6:19 am 
Post subject: Re: Audit Universe Folder Path

zulu1900 wrote:
should I restart SIA?
Yes

zulu1900 wrote:
do I've to open and refresh report from each folder to get it written to Audit?
Yes

zulu1900 wrote:
do I've to import universe refresh it and publish it back?
No
_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
zulu1900
Principal Member
Principal Member



Joined: 27 Jul 2005

Posts: 280



PostPosted: Wed Apr 03, 2019 6:42 am 
Post subject: Re: Audit Universe Folder Path

oops... in that case, I've to manually browse through the folder to find out the total empty folder icon_sad.gif This sounds really a bad design.
I was trying to get my empty folder lists.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6535
Location: Connecticut, USA


flag
PostPosted: Wed Apr 03, 2019 10:49 am 
Post subject: Re: Audit Universe Folder Path

If you just recently checked off the "Folder Path Details" option, then you'll only see auditing data with paths from that point forward. You're probably only seeing "audit" because that's the only folder you've accessed recently.

With that said, if you're trying to find empty folders, auditing won't do it for you. Auditing records events, and there won't be any events for empty folders. You could look for specific folders that have no events, but you won't be able to distinguish between empty folders and folders with reports that haven't been accessed.

You can find empty folders via a CMS query, however:
Code:
select si_name,si_path from ci_infoobjects where si_kind = 'folder' and si_children = 0 and si_ancestor = 23
Back to top
zulu1900
Principal Member
Principal Member



Joined: 27 Jul 2005

Posts: 280



PostPosted: Wed Apr 03, 2019 12:05 pm 
Post subject: Re: Audit Universe Folder Path

hmm.... got it.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Auditor  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.0313 seconds using 17 queries. (SQL 0.0028 Parse 0.0009 Other 0.0275)
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