Get a Handle on Exchange Server
AppAnalyzer helps you keep an eye on server performance.
Everyone has heard complaints from users about slow e-mail, not enough space in their mailboxes or problems connecting to the mail server remotely through Outlook Web Access. Like any other Exchange administrator, you want to know how your Exchange server is handling your applications, how they're performing and what they're being used for so you'll have a ready answer when those questions arise.
NetIQ's AppAnalyzer can help. AppAnalyzer has some unique features to help you better understand how your group is using Exchange and how you can configure your Exchange server for smoother sailing.
The installation and operation requirements are a bit complicated for what looks like a simple product.
The tasks page shown in Figure 1 has three panes. The upper left pane shows the tasks configured to run on this server. At a quick glance, you can see which tasks have been successfully completed, which haven't run yet and those that have errors or have failed.
The upper right screen lets you see all the Exchange servers in your organization and to connect to each one to verify that tasks have been set up for that server. The bottom pane shows you statistics on the tasks that have been configured and executed on the server. These statistics include the date and time of the task, number of items processed and the frequency of execution for tasks.
|Figure 1. AppAnalyzer's Web-based interface makes it a snap to generate reports on Exchange server usage and performance. (Click image to view larger version.)
Serving Up Reports
AppAnalyzer uses SQL Server and OLAP Services to gather data and produce detailed reports about your Exchange server. Once you've configured the necessary settings for generating reports, AppAnalyzer begins collecting data based on your chosen parameters and time frames. You can schedule tasks to start at a later date and time or run a task immediately using the WebAdmin Console.
Once that data has been collected, you can view a report to see details of the specific Exchange feature you've selected. AppAnalyzer processes the data cube through OLAP in SQL Server and presents a graphical representation of the data analysis.
NetIQ has also added something that is a "must have" in today's virus-riddled world of e-mail. AppAnalyzer can report on and forward or delete messages based on their content, scanning for elements like keywords or certain types of attachments. Running the reporting functions at the appropriate times can also help significantly reduce the number of macro virus issues you'll have to face on a daily basis. I run Microsoft's ISA Server 2000 for my company's firewall and if you have ever attempted to install content filtering for ISA Server 2000 to provide the same functionality, you'll appreciate the ease with which you can configure this option with AppAnalyzer.
|Figure 2. The AppAnalyzer Report Console is also Web-based, so you view it in a browser window. Shown is a report on the Information Store Sizes. (Click image to view larger version.)
Using the virus filtering, you can report on messages by attachment. This lets you view a report on selected mailboxes to determine the attachment file extension and name. The report also includes the sender and receiver's e-mail addresses. AppAnalyzer also lets you monitor outgoing traffic with the same parameters. This provides you with a great opportunity to watch the mail traffic coming into and leaving your organization so you can determine whether or not employees are abusing the system and possibly opening your company up to legal liabilities. You can also simply examine the volume of e-mail traffic per user.
Although there are some significant software and installation requirements you'll need to address, no Exchange Administrator should be without this tool.
Gerry O'Brien, MCSE, MCSD, MCDBA, MCT, has been working with computers since the days of the Commodore VIC-20. Over the past five years he's done network administration for The Hardman Group Ltd., a real estate management/development company, and owns Canadian-Based GK ComputerConsulting, which provides hardware and software sales, consulting, and development services to a wide range of clients.