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)  

General Notice: No events within the next 45 days.

how to track Detail_Type_Id = 8 in Audit_Detail table


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



Joined: 28 Dec 2005

Posts: 229



PostPosted: Wed Feb 28, 2007 12:55 pm 
Post subject: how to track Detail_Type_Id = 8 in Audit_Detail table

Hello to all BOB Members,
I have crystal reports and I want to track Detail_type_Id = 8 event to run some auditing reports. I have enabled Auditing option in CMS, Cache Server and RAS. Now can anyone tell me which action I need to perform to get Detail_Type_Id = 8 value. Detail_type_Id = 8 is Document Name in Detail_Type table. I opened so many reports to get detail_type_id =8. Can auditing log View Latest Instance action also? If yes then what event_type_id?
Thank you in advance.

_________________
Trans business objects
Back to top
jsanzone
Forum Associate
Forum Associate



Joined: 12 Sep 2006

Posts: 936
Location: Washington, DC


flag
PostPosted: Thu Mar 01, 2007 11:17 am 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

Wack_Jack:

I am including to this post the complete (or at least I am fairly sure that I've built the complete) view of all the tables in the Auditor DB and their relationship to each other. If you're wondering what tool I used to do this, it was via Access. I imported the 6 Auditor tables into an Access DB, then using the query design wizard and GUI view I linked all of the applicable tables/columns to each other, then captured the SQL code and turned it into a view.

So using the view below that I propose, you can perform: "select * from auditor_view where detail_type_id=8".

Lately I've been meaning to build for myself a view of this DB in order to remove the complexity of using this database so here it is for you and I. This method may seem like a brute force approach, especially when dealing with millions of rows of data, thus causing a long runtime and could possibly crash your server, so I must caveat that as we move forward (i.e. no implied guarantee that this will work in all situations and take caution, etc, etc). If you want to be cautious you can write your own SQL code against Auditor using the required tables and joining appropriately, but now you can look at the joins used in this view and make your process go a bit easier.

Thanks,
John

P.S. the syntax is geared towards SQL server, so for other DB vendors you may need to adjust slightly....

Code:

create view AUDITOR_View as
SELECT        server_process.application_type_id as [Application_Type_ID],
              cast(application_type.application_type_description as varchar(50)) as [Application_Type_Description],
              audit_detail.detail_id as [Detail_ID],
              audit_detail.detail_text as [Detail_Text],
              detail_type.detail_type_id as [Detail_Type_ID],
              cast(detail_type.detail_type_description as varchar(50)) as [Detail_Type_Description],
              audit_event.Duration as [Duration],
              audit_Event.Error_Code as [Error_Code],
              cast(audit_event.Event_ID as varchar(32)) as [Event_ID],
              audit_event.Event_Type_ID as [Event_Type_ID],
              cast(event_type.event_type_description as varchar(50)) as [Event_Type_Description],
              cast(audit_event.Object_CUID as varchar(32)) as [Object_CUID],
              audit_event.Start_Timestamp as [Start_Timestamp],
              cast(audit_event.User_Name as varchar(50)) as [User_Name],
              cast(audit_detail.server_cuid as varchar(32)) as [Server_CUID],
              cast(server_process.server_name as varchar(50)) as [Server_Name],
              cast(server_process.server_fullname as varchar(50)) as [Server_Fullname],
              cast(server_process.server_version as varchar(50)) as [Server_Version]
FROM APPLICATION_TYPE INNER JOIN
             (SERVER_PROCESS INNER JOIN (
                 (AUDIT_DETAIL INNER JOIN (
                      AUDIT_EVENT INNER JOIN
                          EVENT_TYPE ON
                              AUDIT_EVENT.Event_Type_ID =
                              EVENT_TYPE.Event_Type_ID) ON (
                                  AUDIT_EVENT.Server_CUID =
                                  AUDIT_DETAIL.Server_CUID) AND
                                     (AUDIT_DETAIL.Event_ID =
                                      AUDIT_EVENT.Event_ID)) INNER JOIN
                                          DETAIL_TYPE ON
                                              AUDIT_DETAIL.Detail_Type_ID =
                                              DETAIL_TYPE.Detail_Type_ID) ON
                                                  SERVER_PROCESS.Server_CUID =
                                                  AUDIT_DETAIL.Server_CUID) ON
                                                      APPLICATION_TYPE.Application_Type_ID =
                                                      SERVER_PROCESS.Application_Type_ID


Note: this posting was edited on 2 Mar 2007/1132 (EST) to control some of the view's column lengths from excorbitant inherited column lengths from the source table to a more manageable size (for instance, the column Application_Type_Description defaults to nvarchar(510), however, I've re-created the view to establish as varchar(50)) ... this type of activity has been done throughout the view on columns that were getting established with over 100-type length.
Back to top
wack_jack
Principal Member
Principal Member



Joined: 28 Dec 2005

Posts: 229



PostPosted: Wed Mar 07, 2007 7:16 pm 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

Thanks for your reply jsanzone,
But there is no record in Audit_Detail table with Detail_type_Id = 8. Can you please tell me which action I can do so BOXI will insert Detail_type_Id = 8 into Audit_Detail table. I understand your query but still it does not return Detail_type_Id = 8.

_________________
Trans business objects
Back to top
jsanzone
Forum Associate
Forum Associate



Joined: 12 Sep 2006

Posts: 936
Location: Washington, DC


flag
PostPosted: Thu Mar 08, 2007 12:06 pm 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

Wack_jack:

You'll need to go into the admin console
(http://localhost/businessobjects/enterprise115/admin/en/admin.cwr)
and navigate to the Servers section. Ensure that the resulting list coming back to you is sorted by "Server Name". Now, starting with "destinationjobserver", click on it, then go to the audit tab, then enable auditing and select all the underlying auditing details. Continue doing this going down the list of servers (in our case we've omitted any server-type that has "Crystal Reports" listed under the "type" column because we don't have any Crystal reports going through Infoview at this time). Once you've got all of these audit items turned on, you might have to wait a couple of days of online activity before trying to get a report on the code "8" group that you're after.

Good luck.

Thanks,
John
Back to top
wack_jack
Principal Member
Principal Member



Joined: 28 Dec 2005

Posts: 229



PostPosted: Sat Mar 10, 2007 11:11 am 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

jsanzone,
I have enabled all servers but still I haven;t got Detail_Type_Id = 8. Can you please give me corresponding Event_Type_ID. So I will figure out quickly.
Thanks for your time.

_________________
Trans business objects
Back to top
jsanzone
Forum Associate
Forum Associate



Joined: 12 Sep 2006

Posts: 936
Location: Washington, DC


flag
PostPosted: Tue Mar 13, 2007 7:21 am 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

Trans...:

When I run my homegrown view (boe_audit_view) on Detail_Type_ID=8 the unique event_type_id is as follows:
11
19
22

Thanks,
John
Back to top
Farhan Jaffery
Forum Enthusiast
Forum Enthusiast



Joined: 27 Aug 2005

speaker.gif
Posts: 1014
Location: Houston, TX


flag
PostPosted: Wed Sep 26, 2007 4:42 pm 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

detail_type_id 8 is only for Web Intelligence Document. To get the Report Name for a Crystal report, look at detail_type_id 3.
_________________
Farhan Jaffery
SAP Certified - BOE 3.x
J.P. Morgan Chase
Houston, Texas
Back to top
interactive
Senior Member
Senior Member



Joined: 28 Apr 2005

Posts: 87
Location: USA


flag
PostPosted: Fri May 20, 2011 4:21 pm 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

Hi,

Do you know what the ID would be for Dashboards. I would appreciate it if you can tell me that.
We are running BO 3.1 with SP3 and FP 3.3
Back to top
Farhan Jaffery
Forum Enthusiast
Forum Enthusiast



Joined: 27 Aug 2005

speaker.gif
Posts: 1014
Location: Houston, TX


flag
PostPosted: Fri May 20, 2011 5:32 pm 
Post subject: Re: how to track Detail_Type_Id = 8 in Audit_Detail table

Don't know if anything has changed in SP2 or SP3 but XI 3.1 SP1 does not audit dashboard activity (SWF files). If you are using LiveOffice on your dashboards to load data from Web Intelligence or Crystal reports, then you can track audit activity of those reports to measure dashboard usage. That is the mechanism we use.
_________________
Farhan Jaffery
SAP Certified - BOE 3.x
J.P. Morgan Chase
Houston, Texas
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.0465 seconds using 17 queries. (SQL 0.0030 Parse 0.0339 Other 0.0096)
CCBot/2.0 (http://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