Forum GLPI-Project

ecnjohn

Member

Registered: 2022-04-27

Posts: 1

Location Changed Filter

Hello everyone, I am currently biting my teeth out trying to find a way to show all assets that have had their "Location" updated to a different one within the last 30 days.
This is a request from our accounting department who want to be able to find this information quickly, understandably without clicking through every asset that has anything updated at all in the last 30 days (which is something I can filter for easily).

Does anyone have an idea how this could be done?

Current GLPI version is 9.3 but an update to 9.6 or 10.0 is planned for the near future.

Thanks in advance!

jsamaniegog

Member

From: Valladolid, Spain

Registered: 2014-05-28

Posts: 7

Re: Location Changed Filter

Hi ecnjohn, we have the same issue in here. Have you resolved it?
Also we need to send an email when the asset's location has changed and we can't find any configuration to solve it.

Thanks.
Regards.

cconard96

Moderator

Registered: 2018-07-31

Posts: 2,813

Website

Re: Location Changed Filter

I have a plugin that centralizes the historical data and allow searching.
https://github.com/cconard96/glpi-historical-plugin
It was originally proposed as a core feature but it was not implemented.
https://github.com/glpi-project/glpi/pull/7658

The plugin was never published on the main GLPI plugin page because it never got to a polished state.
For example, there may be Financial and Administrative Information historical events shown, but it doesn't know which item the information is for since that information is not directly in the historical data database table.
It would require some logic to try and figure out to related item information.
The issue that is more blocking of a polished release, is how GLPI handles the search options. Each search option has a numerical ID that may be related to the item type itself or a linked type.
For example, the Location search option is provided by the Location type and has the ID of 3 for Computers, but ID 83 for Tickets.
ID 3 for Tickets is actually the Priority.

I tested searching the data based on your requirements (just Computers because of the previous search option ID issue), and it did show the data wanted more or less.

I am fairly confident that it would be possible to overcome these issue to make it more user-friendly but I haven't really had time to continue work on it.

I will try to revisit it today and if I can improve it more, I'll see about backporting it to GLPI 9.3.

Last edited by cconard96 (2022-07-10 15:35:13)

---

GLPI Collaborator and Plugin Developer.
My non-English comments are automated translations. Sorry for any confusion that causes.
Mes commentaires non anglais sont des traductions automatiques. Désolé pour toute confusion qui cause.
Mis comentarios que no están en inglés son traducciones automáticas. Perdón por cualquier confusión que cause.

jsamaniegog

Member

From: Valladolid, Spain

Registered: 2014-05-28

Posts: 7

Re: Location Changed Filter

Thanks cconard96 is great! we are going to try it here.