Deski reports in auditing data base BOXIR2

[Former Member]

Hi experts

I am trying to get the events for the Deski reports in BOXIR2, I did a report based in the auditing information however I got just Webi events, I have tried with different queries but always I get the same results. I have verified and the auditing option is enable in the CMS properties. How Can I get the events for the Deski reports? I need to know if the reports for a specific universe are using for users, I got the information for Webi reports but I am not able to do it for Deski reports

[sonet_kebede]

Hello,

If there is a plan to update than you should do it on BI4.2 SP4 or SP5.

Also, please review the Supported Platforms. This will help you to coordinate your database and middleware with SAP .

Thanks,

Sonet

[Former Member]

Hi Sonet

Currently we have BO 4.1 SP6 and we are planning to update it on BI 4.2 SP4 but some reports are not working due to incompatibility issues so customer continues using XI R2 but we wan to get the statistics about these Deski reports

[sonet_kebede]

Incompatibility error message from SAP product or incompatibility on your database. If it's on the software then we can help you resolve that.

[denis_konovalov]

As XIR2 has been out of support for years now, it's been a long time since anyone used it, but I think that info should be in the audit DB - can you show your queries ?

p.s.
Why would you be still using XIR2 ???

[Former Member]

Hi, good morning

We still use XIR2 due to there are reports created with FHSQL and our current revision BO 4.1 SP5 does not support it, also we are facing incompatibility issues due to some reports are using Oracle 8 as source and the Oracle driver version 10 is not compatible with our OS (Windows server 2008 R2) currently we are planning the update for BO 4.2 SP2

This is the query

SELECT AUDIT_EVENT.User_Name, EVENT_TYPE.Event_Type_Description, DETAIL_TYPE.Detail_Type_Description, AUDIT_DETAIL.Detail_Text, SERVER_PROCESS.Server_FullName, AUDIT_EVENT.Start_Timestamp, SERVER_PROCESS.Server_Name, DERIVED_UNIVERSE_NAME.Detail_Text, LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'DD'), CHR(0)), 2, '0'), LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'WW'), CHR(0)), 2, '0'), LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'HH AM'), CHR(0)), 5, '0'), LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'MM'), CHR(0)), 2, '0'), LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'YYYY'), CHR(0)), 4, '0'), RTRIM(TO_CHAR(( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'YYYY'), CHR(0)), 4, '0') ) || '-' || ( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'MM'), CHR(0)), 2, '0') )), CHR(0)), RTRIM(TO_CHAR(( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'YYYY'), CHR(0)), 4, '0') ) || '-' || ( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'WW'), CHR(0)), 2, '0') )), CHR(0)), RTRIM(TO_CHAR(( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'YYYY'), CHR(0)), 4, '0') ) || '-' || ( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'MM'), CHR(0)), 2, '0') ) || '-' || ( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'DD'), CHR(0)), 2, '0') )), CHR(0)) FROM AUDIT_EVENT, EVENT_TYPE, DETAIL_TYPE, AUDIT_DETAIL, SERVER_PROCESS, ( select AUDIT_EVENT.Server_CUID, AUDIT_EVENT.Event_ID, RTRIM(TO_CHAR(AUDIT_DETAIL.Detail_Text), CHR(0)) as Detail_Text from AUDIT_EVENT, AUDIT_DETAIL where (AUDIT_EVENT.Server_CUID = AUDIT_DETAIL.Server_CUID) and (AUDIT_EVENT.Event_ID = AUDIT_DETAIL.Event_ID) and (AUDIT_DETAIL.Detail_Type_ID = 2) ) DERIVED_UNIVERSE_NAME WHERE ( SERVER_PROCESS.Server_CUID=AUDIT_EVENT.Server_CUID ) AND ( AUDIT_EVENT.Event_Type_ID=EVENT_TYPE.Event_Type_ID ) AND ( DETAIL_TYPE.Detail_Type_ID=AUDIT_DETAIL.Detail_Type_ID ) AND ( AUDIT_DETAIL.Event_ID=AUDIT_EVENT.Event_ID and AUDIT_DETAIL.Server_CUID=AUDIT_EVENT.Server_CUID ) AND ( AUDIT_EVENT.Event_ID=DERIVED_UNIVERSE_NAME.Event_ID and AUDIT_EVENT.Server_CUID=DERIVED_UNIVERSE_NAME.Server_CUID ) AND ( RTRIM(TO_CHAR(( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'YYYY'), CHR(0)), 4, '0') ) || '-' || ( LPAD(RTRIM(TO_CHAR(AUDIT_EVENT.Start_Timestamp, 'MM'), CHR(0)), 2, '0') )), CHR(0)) = @variable('YYYY-MM') AND DERIVED_UNIVERSE_NAME.Detail_Text LIKE @variable('Universe Pattern') AND DETAIL_TYPE.Detail_Type_Description IN ('Document name') AND EVENT_TYPE.Event_Type_Description = 'Document refresh' )

[denis_konovalov]

simplify - run a deski report refresh, then run a query that shows all events from the time of such refresh and see if any of them deski you refreshed.
Then you'll see what is captured and what is not.

[Former Member]

Hi

No it is not gathering the Deski events just Webi, because I developed 2 reports - 1 for Deski and other for Webi and in the auditing report I just see the Webi report.

I have verified the configuration and in the Deski Report server does not have the auditing option as webi Report server. is it lost an extra configuration?

[denis_konovalov]

To honest, I don't recall if it supposed to be there or not.
But I'm pretty sure Deski report actions were audited in R2. Deski is original BO, so it had to.