---
title: "Windows Systems: Identify Users Assigned to Multiple Devices | v8+"
canonical: "https://docs.certero.com/space/CUP/118952285/Windows+Systems%3A+Identify+Users+Assigned+to+Multiple+Devices+%7C+v8%2B"
format: markdown
---
This Custom Group implementation provides valuable insight into device inventory where the last logged on user is found on more than one device within your organization. It helps Software Asset Management (SAM), ITAM, and security teams better understand device-to-user ratios and identify where users may be consuming more hardware resources than expected. 

## Use Case: 

This group would be particularly useful for: 

- Auditing for potential dual device usage for Windows systems
- Detecting potential non-compliance with internal policies
- Supporting rationalization or hardware refresh planning

## What does it do? 

Custom Groups allow System Administrators to execute custom SQL queries directly from the UI which can be then viewed as a filtered grid view result.  The query has been designed to show devices where the Last Logged on User exists more than once under <span style="color: #096ecc">Computer Systems > Microsoft Windows </span>. This group will update dynamically each day based on inventory. 

From v10, users are recognised whether they come from Active Directory or Entra ID, and only Windows devices are counted towards a user's total.

## Which version do I need? 

Download the group that matches your Certero version: 

| Certero version | Download |
| --- | --- |
| v8 to v9 |  |
| v10 onwards |  |

> 📝 v10 changed how users are identified in Certero to support Entra ID, so the group for v8 and v9 is not compatible with v10 onwards. If you are upgrading, replace it with the v10 version by following [Upgrading to v10](#Upgrading-to-v10) below.

## How to use the new group: 

- Download the zip file for your Certero version from [Which version do I need?](#Which-version-do-I-need?) and extract to a preferred directory
- Login to your Certero platform using a SYSADMIN account
- Navigate to <span style="color: #096ecc">Data Groups > Custom Groups </span>
- Select <span style="color: #096ecc">Import </span>
- Browse to your downloaded JSON group and import
- Press <span style="color: #096ecc">Save </span>
- <span style="color: #2f3941">Expected result shown below (numbers will vary) </span>

![image](media://59fc71c8-3d7c-49be-93e0-8b6fff4ed9ed)

> ℹ️ For security reasons, custom data groups and the ability to import/create options are disabled for non-sysadmin logins.

## Upgrading to v10 

If you imported the group for v8 or v9 before upgrading to v10: 

- Navigate to <span style="color: #096ecc">Data Groups > Custom Groups </span>
- Delete the existing **Windows Computers - Two or more Devices** group
- Import the v10 version by following the steps in [How to use the new group](#How-to-use-the-new-group:)