Skip to main content

Dell Precision Optimizer Administrator’s Guide

SSRS Reports

As a system administrator, you can create various reports based on the data collected from Dell Precision Optimizer’s WMI providers. If this is desired, you can include the sms_def_dpo3.mof to extend the database definitions and fetch the corresponding data from Dell Precision Optimizer client systems. You may select some or all the data elements you want to review. The default is set to select all Dell Precision Optimizer data elements.

Importing the sms_def_dpo3.mof file to set hardware inventory classes

  1. In the Configuration Manager console:
    1. Open the Administration page.
    2. Click the Overview tab.
    3. Click the Site Configuration tab and select Client Settings.
  2. Right click an existing Client Setting and select the properties or create a new Custom Client Setting.
  3. In the Hardware Inventory tab, select Set Classes.
  4. Select Import and browse to the location of the sms_def_dpo3.mof file.
  5. Click Ok to import the file and close the Hardware Inventory Classes window.

After the collected data is populated in the SQL database, you can create different types of Dell Precision Optimizer reports. The samples (*.RDL) are provided with the Dell Precision Optimizer software. You can import these RDL files, connect them to your SQL database and run the reports.

To Import an .RDL file

  1. Open SQL Server data tools.
  2. In the Solution Explorer, right click the folder in which you would like to add the .RDL file.
    1. Select Add Existing Item.
    2. Select the .RDL file.
  3. Once the file is imported, open the file and select the Design tab.

To ensure the .RDL file is using the right data source

  1. In the Report Data pane, click Datasets and right click one of the datasets and select Dataset Properties.
  2. In the Dataset Properties window:
    1. the Use a dataset embedded in my report is selected.
    2. Under Data source, click New….
    3. In the Data Source Properties window, select Use shared data source reference and select the correct data source.
    4. Click Ok.
  3. Repeat steps 1 and 2 for all other datasets in the Datasets folder.

Disk Information across multiple systems

This report displays disk information across multiple systems using their latest system analysis report.

Table 1. Disk information across multiple systemsDisk information across multiple systems
Service Tag Bytes Read(MB) Bytes Write(MB) Read Time(%) Write Time(%) Idle Time (%)
98K94X1 0 0 0 0 100
F8W4WZ1 0 460 0 0 98
Disk information across multiple systemsService Tag

Disk information for a single system

This report displays disk information for a single system across multiple reports.

Table 2. Disk information for a single systemDisk information for a single system.
Date Reported Bytes Read (MB) Bytes Write (MB) Read Time (%) Write Time (%) Idle Time (%) Hours On
2015-07-15T11:06:53-05:00 5 526 0 0 98 4
2015-07-15T07:06:53-05:00 16 606 0 1 98 4
2015-07-15T03:06:53-05:00 568 949 0 0 98 3.1
2015-07-14T23:06:53-05:00 6 550 0 0 98 4
2015-07-14T19:07:01-05:00 0 466 0 0 98 4
2015-07-14T15:06:46-05:00 0 447 0 0 98 3.95
2015-06-22T15:24:47-05:00 369 354 0 0 96 3.48
2014-12-16T03:26:33-05:00 0 176 0 0 99 3.43
2014-12-15T23:26:33-05:00 0 178 0 0 99 4
2014-12-15T19:26:34-05:00 0 177 0 0 98 3.98
Disk information for a single system

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\