Getting to Know Your Asset Database

One of the best ways to learn how to create a customized report is to get familiar with the Altiris Database. The steps in this tip were written to get you started on the road to custom report creation.

Let's try to build a report from the simple report template. We'll use "Computer Asset" as an example.

Figure 1. Report Builder.

Click to view.

Select "Computer" for the Data Type.

Click on the "Fields" link and select the fields you wish to display. (for this scenario I decided to use Domain, Name, and perhaps IP address).

Figure 2. Field Selection.

Click to view.

Click "Finish" when done.

Our next step is to visit the report we've created and edit the report. Notice in Figure 3 there is an advanced button in the report editor front page.

Figure 3. Report Editor Front Page.

Click to view.

Click on the "Advanced" button and you'll see a query builder wizard appear.

In the next dialog box, click on "Edit SQL Directly", you should be able to see a SQL Script in the dialog box. The sql script display should give you a good start on learning Altiris Database.

Figure 4. SQL Script Appears!.

Click to view.