Hey all, I have been asked to dig out some statistics from the database of a GLPI 0.72.4 installation.
Most of the stuff I want I seem to be able to find in the "glpi_tracking" table. The field "category" however, is not entirely clear. It holds a numeric identifier; in my case I have values in the range of 0-22. I'd like to know which "name" that identifier corresponds to. In the table "glpi_dropdown_tracking_category" I find a nice list of categories and their numerical IDs. Are these the same thing? I do notice that "14" is missing as an ID in both tables. I assume it was removed at some point in time. Should this be a concern? Is it OK to assume that the "category ID" in "glpi_tracking" can be translated using the "glpi_dropdown_tracking_category" table?? Also; since this is a rather old installation with quite a bit of data - can I be sure that the ID's haven't been "reused"? (i.e. has ID "4" always meant the same thing? Has it always been tied to the same "name"?) Any info on this would be most appreciated. Thanks, //James _______________________________________________ Glpi-user mailing list [email protected] https://mail.gna.org/listinfo/glpi-user
