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.

object name is NULL during logon event


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



Joined: 05 Dec 2018

Posts: 1



PostPosted: Thu Aug 29, 2019 9:35 am 
Post subject: object name is NULL during logon event

Hi All,

We're running SAP BusinessObjects BI Platform 4.2 Support Pack 4 (Version: 14.2.4.2410) and the audit db is on Oracle.

(1) If I run the below query (with the last 2 conditions commented) I get logon/logout event logged for same session
(2) If I run query with the last 2 conditions un-commented, I get prompt/refresh/save event logged for same
session, sometimes modify event with/without prompt/refresh/save is logged

In both the cases the session_id's are different.

Quote:

select Table__9.USER_NAME,
Table__1.SESSION_ID,
Table__11.OBJECT_TYPE_ID,
Table__1.OBJECT_NAME,
'--', Table__4.*
from ADS_EVENT_TYPE_STR Table__4
INNER JOIN ADS_EVENT_TYPE Table__3 ON (Table__4.EVENT_TYPE_ID=Table__3.EVENT_TYPE_ID AND upper(substr(Table__4.LANGUAGE,0,2))='EN')
INNER JOIN ADS_EVENT Table__1 ON (Table__3.EVENT_TYPE_ID=Table__1.EVENT_TYPE_ID)
LEFT OUTER JOIN ADS_USER Table__9 ON (Table__9.USER_ID = Table__1.USER_ID)
LEFT OUTER JOIN ADS_OBJECT_TYPE_STR Table__11 ON (Table__11.OBJECT_TYPE_ID=Table__1.OBJECT_TYPE_ID AND upper(substr(Table__11.LANGUAGE,0,2))='EN')
where Table__1.START_TIME BETWEEN trunc(sysdate) AND trunc(sysdate+1)
and Table__9.USER_NAME NOT IN ( 'QaaWSServletPrincipal','SMAdmin','System Account' )
--and Table__1.OBJECT_NAME Is Not Null
--and Table__11.OBJECT_TYPE_ID IN ( 'AURH1uVOzUZDp8QTF2KnXmk' )


When I run a report (after authentication), I assume the event should be in the order as logon/prompt/refresh/save/logout.
Because the object_name is NULL in logon/logout event, I could not match if these events belong to the same object for
which I've prompt/refresh/save events captured.

I understand during logon the object requested is not known, but when a session created after successful authentication,
the user would run a report under the same session, why session_id changes? Does anyone have any idea about this?
Am not sure what am I missing here.

Any suggestions on this would be highly appreciated.
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.0268 seconds using 17 queries. (SQL 0.0026 Parse 0.0008 Other 0.0234)
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