Forum GLPI-Project

Kromas

Member

Registered: 2020-11-05

Posts: 3

Auto Assigning Computers to Users

Hi There.

I would like to auto assign a massive number of computer assets to their respective users.

So under the computer tab I want a user assigned as the user in the alternate username field.

Basically I have all my users loaded in through LDAP with details: name.surname@domain.com eg John.Smith@company.com
Fusion imports the computer with the alternate username: surname(first letter of name)@domain eg SmithJ@company

Is there a way I can assign computers to users based on those criteria?

Using GLPI 9.5.2 with FusionInventory 9.5.0 + 1.0

Any help is greatly appreciated as I really don't want to manually assign 5000+ computers to users.

Thanks

Last edited by Kromas (2020-11-05 15:02:08)

Kromas

Member

Registered: 2020-11-05

Posts: 3

Re: Auto Assigning Computers to Users

Just a quick note. I just did a dirty patch to resolve this issue by using Pentaho to manipulate the data. This works if anyone was interested.

LaDenrée

HELPER

Registered: 2012-11-19

Posts: 6,287

Re: Auto Assigning Computers to Users

this is a workaround :

export your computers as csv file
use a formula to create a new colum alternate username

use datainjection plugin to update computers alternate username.

other way (more tricky):

use mysql to update database

---

Trouver la panne avant de réparer...
GLPI10.0.16 (ubuntu 22.04 PHP8.1  Mariadb10.6 ) plugins : comportements 2.7.3 reports 1.16.0 formcreator 2.13.9, datainjection 2.13.5 fields 1.21.9

Kromas

Member

Registered: 2020-11-05

Posts: 3

Re: Auto Assigning Computers to Users

Thanks. Pentaho is a sql data injection BI tool so it works quite well and is cronned to work every hour so my system is working quite nicely at the moment.

I would have prefered some sort of rule or script within GLPI or the FI plugin itself though.

Changemanager

Member

Registered: 2023-02-21

Posts: 40

Re: Auto Assigning Computers to Users

hello,

Now with version 10.0.7, is it possible for imported LDAP users to be assigned PCs based on rules?

Thankyou!