Creating a report that lists computers that are assigned to users that only have one assigned?

dmaci
Kilo Contributor

Hello,

 

If possible, I would like to create a report that will list computers that are assigned to users that only have one assigned computer. Creating this report will help me designate a primary computer to a user who only has one assigned computer. Any idea of how I can create this report? 

 

For example:

Billy only has 1 computer assigned to them (ComputerA)

Jim has 2 computers assigned to them (ComputerB & ComputerC)

Larry only has 1 computer assigned to them (ComputerD)

 

Given the data above, I want to create a report that would output these computers:

ComputerA

ComputerD

0 REPLIES 0