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 2017-08-11 16:30:38

mykolaoq
Member
Registered: 2015-11-19
Posts: 30

delete very many devices

Hello! i have configured incorrect rules for devices and now i have very many duplicated devices.

mysql> select id,name from glpi_plugin_fusioninventory_unmanageds limit 20;
+----+---------+
| id | name    |
+----+---------+
|  4 | STORSRV |
|  5 | STORSRV |
|  6 | STORSRV |
|  7 | STORSRV |
|  8 | STORSRV |
|  9 | STORSRV |
| 10 | STORSRV |
| 11 | STORSRV |
| 12 | STORSRV |
| 13 | STORSRV |
| 14 | STORSRV |
| 15 | STORSRV |
| 16 | STORSRV |
| 17 | STORSRV |
| 18 | STORSRV |
| 19 | STORSRV |
| 20 | STORSRV |
| 21 | STORSRV |
| 22 | STORSRV |
| 23 | STORSRV |
+----+---------+

can i just delete these devices from this table by mysql?

Last edited by mykolaoq (2017-08-11 16:38:41)

Offline

#2 2017-08-14 16:26:40

mykolaoq
Member
Registered: 2015-11-19
Posts: 30

Re: delete very many devices

i did it, it seems ok now.

mykolaoq wrote:

Hello! i have configured incorrect rules for devices and now i have very many duplicated devices.

mysql> select id,name from glpi_plugin_fusioninventory_unmanageds limit 20;
+----+---------+
| id | name    |
+----+---------+
|  4 | STORSRV |
|  5 | STORSRV |
|  6 | STORSRV |
|  7 | STORSRV |
|  8 | STORSRV |
|  9 | STORSRV |
| 10 | STORSRV |
| 11 | STORSRV |
| 12 | STORSRV |
| 13 | STORSRV |
| 14 | STORSRV |
| 15 | STORSRV |
| 16 | STORSRV |
| 17 | STORSRV |
| 18 | STORSRV |
| 19 | STORSRV |
| 20 | STORSRV |
| 21 | STORSRV |
| 22 | STORSRV |
| 23 | STORSRV |
+----+---------+

can i just delete these devices from this table by mysql?

Offline

Board footer

Powered by FluxBB