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 2013-07-16 19:08:15

rbernier
Member
Registered: 2013-07-16
Posts: 16

Past Item Assignments in User History

There is one function that would be very useful to me, but I don't think GLPI does it out of the box -- the ability to view a user's item assignment history.

If I were to look at an item, like a computer, I can see in its history tab every user that has ever been assigned that computer. However, in the user's history tab, I can't see past item assignments.

I'm wondering what potential there is to create an additional history tab called "Past Assignments," that would only show assignment history?

What I'm basically looking at is a query like this one:

SELECT *
FROM glpi_logs
WHERE new_value="username"
OR old_value="username"
ORDER BY id DESC LIMIT 0,750

I think this would allow me to see all items being assigned and unassigned from a user in a linear fashion. Obviously where I have "username," I'd have to pull that value from another query on the glpi_users table, based on the user's id value -- which I'm assuming is stored in some php variable? I'm not well versed in PHP, but I can look at code and figure out what's going on.

Can somebody point me in the direction of what php file(s) contain the code to generate a history query? I think I'll tackle the additional tab another time--unless it's a simple feat -- which I doubt.

I'm using version 0.83.7

Thanks in advance for any help. I love this product smile

Last edited by rbernier (2013-07-16 19:18:01)


GLPI: 0.90.4-1 (Remi Repo), CentOS 7

Offline

#2 2013-07-19 23:59:46

rbernier
Member
Registered: 2013-07-16
Posts: 16

Re: Past Item Assignments in User History

I've submitted a different rendition of this topic here:

http://www.glpi-project.org/forum/viewt … p?id=33226

I apologize if I should have tacked it onto this submission, but I felt it was different enough to merit it's own thread.


GLPI: 0.90.4-1 (Remi Repo), CentOS 7

Offline

Board footer

Powered by FluxBB