SCCM contains a Reports feature that enables administrators to generate reports according to their needs. The feature uses SQL statements to query information stored in the SCCM database. Due to the complexity of the SQL statements, reports should only be modified by an administrator familiar with SQL query statements.
An administrator can use the Manufacturer0 field in the v_GS_COMPUTER_SYSTEM view to help identify HP computers in their environment.
To create a report that displays a list of all HP servers:
All HP Servers.
Name0, Domain0, ResourceID, Model0 from v_GS_COMPUTER_SYSTEM where
((Manufacturer0 like '%HP%' or Manufacturer0 like '%Compaq%' or
Manufacturer0 like '%Hewlett-Packard%') and (Model0 like
Your report now appears in the list of reports.
To locate your report, type
HP in the Look for box at the top of the Reports page, and
click Find Now. Your new
report must be visible in the list.
To run the report, right-click on the report, and then select Run. Your HP computers is listed in the report. To open the computer details report for that server, click the shortcut button in the first column.