|Applies To||RSA ACE/Server 5.0.1 (no longer supported as of 8-15-2004)|
Microsoft Windows 2000
UNIX (AIX, HP-UX, Solaris)
|Issue||How to report and query data in RSA ACE/Server to create reports|
|Resolution||RSA 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 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.
"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 ID||a12858|