Cleansing - Hardware Template Report

The Cleansing – Hardware Template report presents a detailed overview of hardware and system attributes for all inventoried devices, facilitating data cleansing and validation processes. It enables organizations to ensure the accuracy, completeness, and consistency of device information in line with IT Service Management (ITSM) practices and compliance requirements.

Usage

It delivers a validated and comprehensive inventory of hardware assets, supporting thorough data cleansing, precise asset tracking, and informed decision-making. This ensures alignment with IT Service Management (ITSM) best practices and enhances organizational efficiency and compliance.

Example

Before performing a quarterly asset data audit, the IT Asset Management team opens the Cleansing – Hardware Template report to assess device attributes such as domain name, IP address, make, model, serial number, RAM, CPU details, operating system, and platform.

During the review, the team discovers several entries with missing serial numbers and outdated OS information. This enables them to correct the data ahead of compliance checks, avoiding discrepancies and ensuring smooth audit operations.

Accurate and cleansed data results in consistent reporting, improved planning, and reduced operational risks.

Steps:

To view the Cleansing – Hardware Template report, perform the following steps:

Navigate to Reports > Asset Management. The Dashboards page is displayed. Search or select Cleansing – Hardware Template from the dashboard list.

Figure: Dashboards
The Cleansing – Hardware Template report is displayed. Use the Search box on the top-right to look up specific devices, serial numbers, models, or any column value.

Figure: Cleansing – Hardware Template Report

The following table outlines key fields in the report along with concise descriptions of their purpose and usage.

Field	Description
Domain Name	The network domain to which the device belongs.
Device Name	The unique identifier or name of the hardware device.
IP Address	The network address assigned to the device.
Physical Host	The name of the host machine for virtual devices, or the device itself if physical.
Make	The manufacturer of the device.
Model	The model or series of the device.
Serial Number	The unique serial number assigned by the manufacturer.
CPU Name	The name or designation of the installed CPU.
Ram In Bytes	The amount of RAM installed in bytes.
CPU Speed In MHz	The speed of the CPU measured in megahertz.
CPU Cores	The number of physical cores in the CPU.
CPU Threads	The number of threads supported by the CPU.
Number Of Physical CPUs	The count of physical CPUs installed.
Number Of Logical CPUs	The count of logical CPUs (including virtual cores).
Operating System	The OS installed on the device.
Service Pack	The service pack or update level of the operating system.
Platform	The hardware platform or architecture of the device.
OS Mobility	Whether the OS allows for device mobility (e.g., portable OS).
Terminal Server	Indicates if the device operates as a terminal server.
Lifecycle	The stage of the device’s lifecycle (e.g., deployed, retired).
Status	The current operational status of the device (e.g., active, inactive).
BIOS Date	The date of the device’s BIOS release or last update.
Last Seen Date	The most recent date the device was detected or reported.
Last Logged On User	The user who most recently logged onto the device.
Device Type	The classification of the device (e.g., laptop, server, desktop).
Physical Or Virtual	Indicates if the device is physical or virtual.
Environment	The operational context (e.g., desktop, server).
Country Of Use	The country where the device is used or located.
Business Unit	The division or department within the organization that owns or uses the device.
User Specified 1–4	Custom fields for additional user-defined device attributes.
IBM PVU	Processor Value Unit metric used for IBM licensing calculations.
Virtualization Type	The virtualization platform or technology used (e.g., VMware, Hyper‑V).
Multi Threading enabled	Indicates whether multi‑threading is enabled on the CPU.

Note:
Users can scroll horizontally to view all attribute columns and vertically to navigate through the list of inventoried devices.

Filters

The left panel provides multiple filters to refine the dataset. You can filter the report using below attributes.

Figure: Filters Panel

Filter Name	Description
Domain Name	Filters devices based on the domain to which they belong, helping isolate assets grouped by network or organizational domain.
Device Name	Filters the list using the system or host name assigned to each device, useful when searching for specific machines.
IP Address	Filters devices by their assigned IP address to identify systems within specific network ranges or troubleshoot network issues.
Physical Host	Filters virtual machines or hosted systems by the physical server on which they reside.
Make	Filters devices by manufacturer (e.g., HP, Dell), allowing brand-based grouping or comparison.
Model	Filters devices by their model type, helping identify similar hardware configurations.
Serial Number	Filters devices based on their unique serial number, useful for asset verification and audits.
CPU Name	Filters devices based on the processor type or CPU family to analyze performance profiles or identify specific CPU groups.
Ram In Bytes	Filters devices based on total installed memory capacity.
Operating System	Filters by the OS installed on the device.
Platform	Filters by hardware platform or architecture (e.g., x86, x64).
OS Mobility	Filters based on whether the OS supports mobility (e.g., portable OS types).
Terminal Server	Filters devices based on terminal server capability/role.
Last Seen Date	Filters devices by most recent discovery/heartbeat date.
Last Logged On User	Filters results based on the last authenticated user.
Device Type	Filters by classification such as laptop, server, desktop, etc.
Physical Or Virtual	Filters based on whether the device is physical or virtual.
Environment	Filters by operational environment category (e.g., desktop, server).
Country Of Use	Filters devices by the country where they are used or located.
Business Unit	Filters based on the organizational unit owning or using the asset.

Note:
Click Apply Filters to update the view. Use Clear all to reset the filters.