Lot of logs are generated for peripheral with bogus serial numbers

[SteadEXE]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

Version

10.0.14

Bug description

Hello,

I already opened tickets in the past for this issue, it has been partially solved by adding more rules to glpi inventory when filtering serial numbers.

The issue is that we cannot detect all of them and there is no way to detect bogus peripheral in GLPI itself.

One workaround is to manually set inventory management to global when we find a peripheral with a fake serial number (most of them are cheap chinese adapter or usb composite devices) but it requires an admin to find one of them.

In one year we generated more than 25,000,000 log records.
To prevent database from exploding we enabled the cron task that flush logs after one month, but we also flush valuable informations such as owner history on legit devices.

Is it possible to have a task to automatically configure management type from unit to global for example if it changes more than x times the owner in the last x days ?

Cause those lines are created over and over.
We have 500 computers which only inventory themselves once a day, if we shorten the delay, it bloats the database even more cause those devices jump after each inventory from one computer to another

I am not yet familiary enough with GLPI source code to propose a PR, I wanted to do it with SQL only with a scheduled task on our database server, but I am not sure how to exactly filter it in logs table

Relevant log output

No response

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[github-actions]

This issue has been closed as we only track bugs here.

You can open a topic to discuss with community about this enhancement on suggestion website.
You can also contact GLPI editor team directly if you are willing to sponsor this feature.

[SteadEXE]

It's a breaking bug (before being a feature request), it bloats the database if GLPI inventory is enabled with a lot of computers

[SteadEXE]

For people having the same issue https://glpi.userecho.com/communities/1/topics/2333-add-a-task-to-automatically-change-inventory-mode-to-global-for-bogus-peripheral