000019846 - How to report and query data in RSA ACE/Server to create reports

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000019846
Applies ToRSA ACE/Server 5.0.1 (no longer supported as of 8-15-2004)
Microsoft Windows 2000
UNIX (AIX, HP-UX, Solaris)
IssueHow to report and query data in RSA ACE/Server to create reports
ResolutionRSA ACE/Server uses Progress for its database and has two databases: a server (sdserv) and a log (sdlog) database. There are several ways to query data:

1. RSA ACE/Server Database Administration (Host Mode or Remote Mode) - the ACE/Server Administration Manual provides information on using Database Administration (admin.pdf found on the ACE/Server CD-ROM)

2. RSA ACE/Server Report Creation Utility - the ACE/Server Administration Manual provides information on using the Report Creation Utility with Windows and UNIX

3. Using the Administration Toolkit (SDK) and build a custom program - a reference for developing programs to administer an ACE/Server is found in the "Customizing Your ACE/Server Administration" guide (cust_admin.pdf found on the ACE/Server CD-ROM). Part 2 of the "Customizing Your RSA ACE/Server Administration" guide provides information on Accessing ACE/Server databases.

NOTE: The Administration Toolkit provides the best portability between ACE/Server versions. The C and TCL API interfaces provide a layer of abstraction from the database schema so the same report can be used after upgrading the ACE/Server software.

4. Writing SQL queries in Windows or UNIX - an example of a SQL script which creates a report counting the different administration tasks done on a site called "North Sydney" today, where today is 12th September 2002:


output to "report.txt".
select sdle.chSiteName,sdle.dtLocalDate,sdle.iMessageNum,sdlm.chShortMessage,COUNT(*) from SDLogEntry sdle join SDLogMessage sdlm on sdlm.iMessageNum = sdle.iMessageNum where (sdle.dtLocalDate = today) and (sdle.chSiteName = "NorthSydney") group by sdle.chSiteName,sdle.dtLocalDate,sdle.iMessageNum,sdlm.chShortMessage with export.
output close.

Output results to a file called "report.txt". Those results are the site name, todays date, event number, short task description, and the count of the task.

Example results:

"North Sydney" 09/12/02 5522 "Added agent host to site" 1
"North Sydney" 09/12/02 6009 "Edited site" 2

Database has a site called "North Sydney". The site has been administered 3 times; once to add an agent host, and twice to edit the site.

5. Using a ODBC driver for Progress from OpenLink Software or DataDirect Technologies - an example of using the ODBC driver: Microsoft Excel can get data from an external data source using the ODBC driver, and can import data from the ACE/Server database.
Legacy Article IDa12858