Owner's Manual

Reporting 155
NOTE: If you have newly discovered a system, the Resource Connection State
report does not display the connection state data immediately.
Creating a New SQL Report
If you do not find a report that suits your needs, you can create a new report
and present data in a way you want.
For example, if you want a report on the operating systems present on the
servers on your network.
1
On the left pane, on the Reports tree, right-click Reports and select New 
Report  SQL Report .
2 On the New SQL Report page, in the Data Source tab, enter:
select [OS Name] from DiscoveredMachines
3
Click Apply .
The report displays the operating systems on each discovered system.
Creating a New Dell Computer Report
To create a new Dell computer report:
1
On the Reports portal page, right-click Reports and select New  Report 
Computer Report .
2 In the Data Source tab, Query sub-tab, select the Base Query and choose
Dell Computer from the Base Resource Type drop-down menu.
NOTE: You can also create other Dell reports from this drop-down.
3 In the Fields sub-tab, click Add to include the attributes. See “Attributes
for Inventory”for all Dell attributes.
NOTE: All Dell attributes are prefixed with Dell Computer or Dell Management
Console.
4 Click Save changes .
A tabular report is displayed with all the attributes you selected.
For advanced reports, see the Symantec documentation available under
Help  Document Library .
book.book Page 155 Monday, April 19, 2010 5:19 PM