Cleansing - All Users

The All Users (Cleansing) report presents a detailed inventory of all users, including essential attributes necessary for thorough data validation and cleansing, in accordance with IT Service Management (ITSM) best practices and standards.

Report Usage

It facilitates data cleansing activities by presenting a comprehensive view of all user records, allowing organizations to validate, update, and enhance user information. This ensures accurate software asset tracking and compliance in alignment with IT Service Management (ITSM) practices.

Example

During a quarterly data validation cycle, the IT Operations Team uses the Cleansing – All Users report to identify discrepancies in user records. The report reveals users with mismatched “Current Data Origin” values and several accounts marked as “Is Confirmed = No”.

This insight allows the team to validate employee status with HR, align directory information, update job titles and departments, and remove stale or obsolete accounts from asset management systems.

By cleansing and validating these records, the organization improves accuracy in software license assignments, strengthens identity management practices, and ensures compliance with ITSM standards.

Steps:

To access the Cleansing – All Users report:

Navigate to Reports > Asset Management to open the dashboards page. Search for Cleansing - All Users report.
Figure: Dashboard
Select the report to view a detailed table containing all user attributes relevant for cleansing.
Figure: Cleansing – All Users Report

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

Field	Description
Country	The nation where the user is based.
User Name	The unique name or ID assigned to each user.
Environment	The IT environment (e.g., Production, Test, Development) where the user operates.
Current Data Origin	The source system or method from which the user data was collected.
Has Installs	Indicates if the user has associated software installations.
Is Confirmed	Indicates whether the user is a confirmed employee or not.
Company	The organization that the user belongs to.
Department	The specific department within the company employing the user.
Job Title	The user's job position or designation.
Employee ID	The unique identification number assigned to the employee.
Distinguished Name	The full directory path of the user in the network (e.g., Active Directory).
Location	The physical site or office where the user works.
Address Site	The full address or site details of the user’s workplace.
Last Seen	The date and time when the user was last detected or recorded in the system.
User Specified 1	Custom user attribute field #1 for additional data.
User Specified 2	Custom user attribute field #2 for further data.
User Specified 3	Custom user attribute field #3 for supplementary data.
User Specified 4	Custom user attribute field #4 for extra data as needed.

Filters

Use filter icon to refine the report results based on selected criteria and display only relevant records.

Figure: Filters

Enter the details as described in the following table and click Apply filters to view the report or clear all to reset the filters.

Field	Description
Country	Enter or search the Country from the list.
User Name	Enter or search the User Name from the list.
Environment	Enter or search the Environment from the list.
Has Installs	Fetch the list that “Has Installs”.
Current Data Origin	Enter or search the Current Data Origin details from the list.
Is Confirmed	Fetch the list that “Is Confirmed”.
Company	Enter or search Company name from the list.
Department	Enter or search the Department from the list.