Forum GLPI-Project

cyberbillp

Member

Registered: 2006-05-01

Posts: 9

Company management

I have a new question today. :-)

How can I equate various alias' for a single company?
For example.......

I have:
Dell   http://www.dell.com     
Dell Computer Corp.         
Dell Computer Corporation   http://www.dell.com     
Dell Inc.

and

Microsoft         
Microsoft Corp         
Microsoft Corp.         
Microsoft Corporation         
Microsoft Corporation - Office Resource Kit Group         
Microsoft Press

I'd like to make all these alias' of the same relative company (Dell's for a single Dell, and Microsoft for all the variations of Microsoft). Matter of fact as Microsoft gobbles down more and more companies, it would make it easier to point them all to Microsoft.... But I digress.
I know this is probably a feature request, but is there a way to do it now?

I use OCSng 4014 and GLPI 0.65.

doch83

Member

From: Lake Forest, CA, USA

Registered: 2007-02-21

Posts: 20

Website

Re: Company management

bump

CiF

Member

Registered: 2007-01-22

Posts: 12

Re: Company management

anyone tried ? this would be useful if we can combind......

CiF

Member

Registered: 2007-01-22

Posts: 12

Re: Company management

To see all software with "Microsoft"

select glpi.glpi_software.name, glpi.glpi_software.FK_glpi_enterprise
from
glpi.glpi_software, glpi.glpi_enterprises 
where 
glpi_enterprises.ID = glpi_software.FK_glpi_enterprise 
AND 
glpi.glpi_enterprises.name like '%Microsoft%';

To update all software entries to one Microsoft (For instance id=2, u need to check it with the sql statement shown above)

update glpi.glpi_software , glpi.glpi_enterprises
set
glpi.glpi_software.FK_glpi_enterprise = 2
where 
glpi.glpi_enterprises.ID = glpi.glpi_software.FK_glpi_enterprise 
AND 
glpi.glpi_enterprises.name like '%Microsoft%';