Hello,
I’ve installed Oracle Audit universe. I’ve configured it in CMC, took default configuration and also selected the following Event details:
User Group Details
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/.
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.
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.
oops… in that case, I’ve to manually browse through the folder to find out the total empty folder This sounds really a bad design.
I was trying to get my empty folder lists.
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:
select si_name,si_path from ci_infoobjects where si_kind = 'folder' and si_children = 0 and si_ancestor = 23
(BOB member since 2003-11-27)
(BOB member since 2003-11-27)
This sounds really a bad design.
(BOB member since 2002-08-29)