Using the Microsoft Access SMSVIEW Samples

This sample Access database uses ODBC to link to the SMS database. The sample provides one form, five queries, and two reports.

The form shows all computers with duplicate TCP/IP addresses.

There are five queries: Duplicate TCP/IP Addresses, Late Scan, ListDup, Low Disk Space, and Network.

The first report shows all computers that have not scanned their hardware or software in the past 10 days. The second report shows all computers that have fixed disks that are over 90 percent full.

You can use Microsoft Access to generate any number of forms or reports to analyze the SMS data. For example, you can create a help desk tracking system using Microsoft Access that ties in to the site database. This can include maintenance history, trouble calls, configuration changes, and so on.

    To set up Microsoft Access for the Microsoft Access sample

Make sure you have completed the ODBC setup as described in General Setup for Using the SMSVIEW Samples.

    To use the Microsoft Access sample

1. Start Microsoft Access.
2. Copy SMSDB.MDB from the SDK directory on the SMS CD-ROM to the directory on your hard disk where you want to place the sample.
3. Open the SMSDB.MDB database.

   The sample has a main menu form, from which you choose a report or form. You can view the queries (as well as the form and reports) in the database window for SMSDB.

   When you click a button in the main menu form, the SQL Server Login dialog box appears.

4. In the Login ID and Password boxes, type the SQL login identifier and password for the SQL Server containing the site database.

   Note that the SQL login identifier must have dbo permission on the site database.

5. In the Database: SMSDB window, you can choose the tab for the type of item you want to use. The sample SMSDB database provides sample forms, queries, and reports. In the tab list, double-click the item you want to use.