More Music for the Holidays

For today’s audit carol, a song from the Broadway hit “The Sound of Auditing” which has become an auditing carol classic.

 
I Found Weak Controls
 
Unsecured credit and duplicate payments,
Escheated checks that had too many claimants,
Auditees’ stories full of gaping holes.
These were some times when I found weak controls.
 
Key information free and unrestricted,
E-mail and texts that were all unencrypted,
Fudging statistics to meet foolish goals.
These were some times when I found weak controls.
 
When the banks fail,
When the stocks flail,
When all trading’s banned,
I simply remember the findings I’ve found
And know I’ve done all I can.
 
Lack of direction, approvals backdated,
Critical duties still unsegregated,
Trusted employees just out on parole.
These were the times when I found weak controls.
 
When the cops come,
When the deeds done,
When the crooks are canned,
I simply remember the findings I’ve found
And know I’ve done all I can.
 
Tomorrow, more auditing carols for your enjoyment.

 

Posted on Dec 20, 2011 by Mike Jacka

Share This Article:    

  1. Hi Abhi, I thought I reeilpd to your latest questions, but I don't see it. Duration is in seconds, I believe. If it is empty, I am not really sure why that would be, please try a refresh that you know takes at least a few seconds and then look later for the auditing record for that refresh.Peak Usage, hmm from the top of my head how about this:SELECT TRUNC(ae.start_timestamp,'HH24'), COUNT(1)FROM Audit_Event ae, Event_Type etWHERE ae.event_type_id = et.event_type_id AND et.event_type_description = 'Document Refreshed' AND ae.start_timestamp > TRUNC(SYSDATE,'DDD') - 30GROUP BY TRUNC(ae.start_timestamp,'HH24')ORDER BY TRUNC(ae.start_timestamp,'HH24') ASCThat would give you the count of reports for each hour of the day looking back at that last 30 days.I have not tested that query, please do test and report back. Also, I should state that this query will work with XI 3.1. The refresh description would need to be something else that escapes me right now. This query won't work at ALL in BI 4.0. The auditing data model changes quite a bit in BI 4.0 (a.k.a. XI 4.0). I should write an article about both XI and BI auditing data models.

Leave a Reply