You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-04-16 15:09:20

nsi-test
Member
Registered: 2018-02-16
Posts: 19

Is it safe to move locations to entities using raw SQL query?

Hi,
We use GLPI 9.1.4 on CentOS Linux release 7.3.1611 (Core) server with the following plugins loaded:
File injection    2.4.2
FusionInventory    9.1+1.1
Objects management    2.4.0
OCS Inventory NG    1.3.3 (not used)
Our computers are Windows based (7 and 10)
We use FusionInventory Agent 2.3.21 x86 for windows.

Sometimes we find out that some locations are not in  appropriate entity. But drom the web interface - the option "transfer and merge" has some limitations. For example I can merge them only to the root entity. In the table glpi_locations there is a field "entities_id" which defines the entity of the location. It si very easy to change it. I personally use this kind of code:

UPDATE `glpi_locations` 
SET entities_id = 92
WHERE id = 123
LIMIT 1;

(Ids are arbitrary.)

My question is: is it safe to do so? Is there some problematic situation that can emerge?

Thanks in advance.
Regards.


I cannot write french, but I can read it. So french sources are welcome.

Offline

Board footer

Powered by FluxBB