Voici quelques de exemples de scripts pour se connecter à GLPI via le connecteur universel:

GLPI Users:

select * from glpi_users where is_deleted=false 

GLPI Computers:

" SELECT
 glpi_computers.id,
 glpi_computers.name,
 glpi_computers.serial,
 glpi_manufacturers.name as ComputerManumfacturer,
 glpi_computermodels.name as ComputerModele ,
 glpi_users.name as UserUpn,
 glpi_users.firstname,
 glpi_users.realname 
FROM
 glpi_computers,
 glpi_users, glpi_manufacturers,
 glpi_computermodels
 WHERE
 glpi_computers.users_id=glpi_users.id
 AND glpi_computers.manufacturers_id=glpi_manufacturers.id
 AND glpi_computers.computermodels_id=glpi_computermodels.id
 AND glpi_computers.states_id=3 "

GLPI Phones:

" SELECT
 glpi_phones.id as PhoneId,
 glpi_phones.name as PhoneName,
 glpi_phones.serial,
 glpi_manufacturers.name as PhoneBrand,
 glpi_phonetypes.name as PhoneType,
 glpi_phonemodels.name as PhoneModel,
 glpi_users.firstname as UserFirstName,
 glpi_users.realName as UserRealName,
 glpi_users.name as UserUpn
 FROM
 glpi_phones, 
glpi_manufacturers, 
glpi_phonetypes, 
glpi_phonemodels, 
glpi_users 
WHERE
 glpi_phones.manufacturers_id=glpi_manufacturers.id
 AND glpi_phones.phonemodels_id=glpi_phonemodels.id
 AND glpi_phones.phonetypes_id=glpi_phonetypes.id
 AND glpi_phones.users_id=glpi_users.id
 AND glpi_phones.states_id=3 "

Rappel de chaîne de liaison type:

MySQL Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;Pwd=myPassword;