Skip to main content
Contact Us

Dell Precision Optimizer Administrator’s Guide

PDF

Custom reports

Here are some examples on how you can collect some data from Dell Precision Optimizer clients using its WMI classes and create custom reports. Dell Precision Optimizer provides a large set of WMI classes to allow an IT administrator to create a huge variety of reports. The following steps illustrate how to create a Dell Precision Optimizer report. An IT administrator can customize what data must be collected and know how to present that data.

Create Custom Inventory Rules

From your KACE appliance console:
  1. Click Inventory, then select Software.
  2. Choose Action and select New.
  3. On the Software Details page, enter the following information
    • Name -> DPO Sample Inventory
    • Version -> v1
    • Publisher -> Dell
    • Supporting Operating Systems -> Select OSes
    • Custom Inventory Rule -> ShellCommandTextReturn(wmic /namespace:\\root\cimv2\DPO Path DPO_Profiles get /ALL)
    • Click Save.
  4. Click back into the new custom inventory record and hover over the record just created. Note the identifier(ID#) at the end of the URL. The URL with the ID# is visible at the lower left hand corner of the page. You will need this later for creating the report.

Force Inventory Collection

From your KACE appliance console:
  1. Click Inventory and select Devices.
  2. Select the device(s) where Dell Precision Optimizer is installed (you could use a SmartLabel for this purpose).
  3. Choose Action and select Force Inventory.
  4. After the inventory cycle is completed, navigate into one of the selected devices that was online.

  5. On the Device Detail page, click Software, expand Custom Inventory Fields. This displays a list of profiles and their current states.

NOTE: Now that you have Script and Custom Inventory setup, and have completed a Custom Inventory cycle on all desired systems, it is time to use K1000s reporting capabilities. While you can definitely pull the Dell Precision Optimizer information out of the K1000 using a Wizard based report, we are going to use a custom SQL report to process and filter our information into a useful report.

Create report

From your KACE appliance console:
  1. Click Reporting, then select Reports.
  2. Choose Action and select New (SQL).
  3. On the Report Detail page, enter the following data:
    • Title -> Dell Precision Optimizer Sample Profile Report
    • Description -> This is a sample Dell Precision Optimizer report …
    • Category <any> or New Category -> DPO Reports
    • SQL -> 
      SELECT
MACHINE.NAME AS Name,
MACHINE.IP AS Ip,
MACHINE.USER_LOGGED AS LoggedUser,
MACHINE.CS_MANUFACTURER AS Manufacturer,
MACHINE.CS_MODEL AS Model,
MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE AS MACHINE_CUSTOM_INVENTORY_XXXX,
COUNT(MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE) AS Total_Devices FROM MACHINE_CUSTOM_INVENTORY
JOIN MACHINE ON MACHINE.ID = MACHINE_CUSTOM_INVENTORY.ID
WHERE MACHINE_CUSTOM_INVENTORY.SOFTWARE_ID = XXXX
GROUP BY MACHINE_CUSTOM_INVENTORY.STR_FIELD_VALUE
ORDER BY MACHINE.CS_MANUFACTURER ASC, MACHINE.CS_MODEL ASC

      Replace XXXX with the ID# of your custom inventory which was collected above when the Custom Inventory Rule is created.

  4. Click Save.

Run Report

From your KACE appliance console:
  1. Click Reporting, then select Reports.
  2. Search for DPO to view your reports.
  3. Select the desired report, such as DPO Sample Profile Report, and select the report format you want, say HTML.

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: <>()\