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.
select
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
'%ProLiant%'))
Click OK.
Your report now appears in the list of reports.
To locate your report, type All
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.