One-Touch Smart Reporting

Quickly access your SMS database via Aelita's SnapReports.

Anyone working with Microsoft's Systems Management Server knows that one of its greatest strengths is its vast information database concerning a network's systems. But getting useful information from that database isn't always an easy task. Many organizations find they need a third-party solution to extract that data. This usually means learning to operate a new external program and sometimes even dedicated hardware. SnapReports, however, is unique—it's not an external application. Rather, SnapReports "gently" attaches itself to the SMS Administrator Console, allowing administrators to easily and quickly create customizable HTML reports drawn from the SMS database. These reports can be saved, printed, or searched for desired information.

With SnapReports operating as part of the SMS Administrator Console, the learning curve is reduced. In no time, administrators-who already know the SMS Console-can use SnapReports. What's more, installing SnapReports doesn't modify any SMS-generated reports. SnapReports simply appears as a Report extension under the Queries and Status Messages Queries sections of the Administrator Console.

A really cool SnapReports feature is its one-touch operation. Almost everything that needs to be done can be performed with a single mouse click. There's no need for extra dialog boxes or searching for the correct field in the hierarchy. In addition, because every query gets a Report folder below it, the SnapReports utility is always close at hand.

Creating reports with SnapReports is easy. Simply select the SMS Query or SMS Collection you want to build a report around, choose the attached Report, select the attributes to display and any necessary parameters, click the Run button, and the report is generated. SnapReports also remembers your input so that the next time you choose this report, the previous information will be automatically selected for you. Once a report is created, you can search it by clicking the Find button and entering the search criteria. The search results will be displayed in the console's left pane.

Customizing reports is just as easy. Because all reports are generated as HTML, all you have to do is modify the template. With basic HTML knowledge, your reports can quickly display your company's logo or colors.

SnapReports provides a variety of flexible HTML-based reports that allow you to make sense of the huge amount of information collected by SMS.

I did run into one drawback while using SnapReports: It requires Internet Explorer 5.0 for report display. The program's setup process didn't check to see if I had IE5 installed. What's more, not only did I need to reboot my server after installing SnapReports, but after installing IE5. This procedure could impact any organization running the SMS Administrator Console on an SMS server-many organizations wouldn't agree to reboot a production server twice. I should also note that the SnapReports version I tested failed to display when IE5.5 was installed.

Other than the above minor drawbacks, SnapReports is a solid tool-extremely powerful and easy to use. If your organization requires advanced and customized reports drawn from your SMS database, this is definitely a solution that you should consider.

About the Author

Barry Shilmover, MCSE+I, MCT, owns Shilmover Consulting Services, a Microsoft Solution Provider specializing in Windows NT/2000 and Exchange 5.5/2000 solutions. He has co-authored books that include Windows 2000 System Administrator’s Black Book and Exchange 5.5 Exam Cram, both from Coriolis Press.

Featured

  • Microsoft Offers Support Extensions for Exchange 2016 and 2019

    Microsoft has introduced a paid Extended Security Update (ESU) program for on-premises Exchange Server 2016 and 2019, offering a crucial safety cushion as both versions near their Oct. 14, 2025 end-of-support date.

  • An image of planes flying around a globe

    2025 Microsoft Conference Calendar: For Partners, IT Pros and Developers

    Here's your guide to all the IT training sessions, partner meet-ups and annual Microsoft conferences you won't want to miss.

  • Notebook

    Microsoft Centers AI, Security and Partner Dogfooding at MCAPS

    Microsoft's second annual MCAPS for Partners event took place Tuesday, delivering a volley of updates and directives for its partners for fiscal 2026.

  • Microsoft Layoffs: AI Is the Obvious Elephant in the Room

    As Microsoft doubles down on an $80 billion bet on AI this fiscal year, its workforce reductions are drawing scrutiny over whether AI's ascent is quietly reshaping its human capital strategy, even as official messaging avoids drawing a direct line.