Power tools: 2002 audit software usage survey; three avid users talk about how they use top-rated software products to automate their most important tasks. Plus, the results from the IIA's annual poll of members' application preferences are revealed

Internal Auditor, August, 2002 by Christy Chapman

To comment on the survey data, contact Internal Auditor's Senior Editor, David Salierno, at dsalierno@theiia.org.

Data Extraction and Ana1ysis Software

WHICH PRODUCT DO YOU USE MOST? *

EXTRACTION


Internally developed software   3%
SAP                             3%
Oracle                          4%
Monarch                         3%
IDEA                            9%
Excel                          14%
AS/400 Query                    7%
ACL                            24%
Access                          9%
Other **                       24%

Note: Table made from pie chart
ANALYSIS


Internally developed software   1%
Monarch                         1%
IDEA                           10%
Hyperion                        1%
Excel                          43%
Crystal Reports                 1%
AS/400 Query                    2%
ACL                            24%
Access                         10%
Other ***                       7%

* Extraction chart reflects the 82 percent of respondents who
indicated they are using this type of software; analysis chart
reflects 88 percent of respondents.

** Includes BancAudit, Business Objects, Cognos, Crystal Reports,
DSS Auditron, Easytrieve Plus Report Writer, Epicor Report Wizard,
Focus, Hyperion, IQ Objects, ITI Prime, JH&A Report Writer,
PeopleSoft, QueryCalc, SAS, Showcase, SQL, TQL, TrendStar, Vislmage,
and VISION:Results.

*** Includes BancAudit, Business Objects, CaseWare, Cognos, DSS
Auditron, Easytrieve Plus Report Writer, Focus, Impromptu, IQ Objects,
ITI Prime, Lotus 1-2-3, Oracle, SAP, SAS, SQL, TrendStar, and Vislmage.

Note: Table made from pie chart

[GRAPH OMITTED]

[GRAPH OMITTED]

[GRAPH OMITTED]

[GRAPH OMITTED]

[GRAPH OMITTED]

[GRAPH OMITTED]

Fraud Detection/Prevention Software

WHICH PRODUCT DO YOU USE MOST? *


Access                          3%
ACL                            51%
DATAS                           2%
Excel                           1%
IDEA                           24%
Internally developed software  10%
other **                        9%

* Chart reflects the 40 percent of respondents who indicated they are
using this type of software.

** Includes 4/Detection, AccessData, AS/400 Query, ASSIST, DSS Auditron,
Easytrieve, QueryCalc, SAS, Showcase, TrendStar, WizRule, and XBR.

Note: Table made from pie chart

[GRAPH OMITTED]

[GRAPH OMITTED]

[GRAPH OMITTED]

E-Commerce Control Software

WHICH PRODUCT DO YOU USE MOST? *


CyberCop                      2%
Enterprise Security Manager   6%
Firewall software            63%
Kane Security Analyst         4%
ISS Internet/System Scanner  13%
Other **                     12%

* Chart reflects the 32 percent of respondents who indicated they are
using this type of software.

** Includes BindView, Cisco Secure Scanner, ISS RealSecure, MDamon,
Nessus, PentaSafe, Snort, and SuperScout.

Note: Table made from pie chart

[GRAPH OMITTED]

Network Security Assessment Software

WHICH PRODUCT DO YOU USE MOST? *


BindView                        6%
Cisco Secure Scanner            3%
CyberCop Scanner                7%
Enterprise Security Manager    11%
ISS Internet Scanner           21%
Kane Security Analyst           7%
Nessus                          2%
NetRecon                        1%
Internally developed software  17%
Other **                       25%

* Chart reflects the 24 percent of respondents who indicated they are
using this type of software.

** Includes Ecora, ISS RealSecure, Linux Port Sentry, MDamon,
MIMEsweeper, PentaSafe, Security Analyzer, SuperScout, VirusScan, Vscan,
and WebShield.

Note: Table made from pie chart