You are not logged in.
I created a custom report using the Reports v1.3.0 plugin and am having trouble creating a sql query for the CPU mhz, number(Single, Dual, or Quad processor), and total amount of RAM. I was able to create an sql query all other information quite easily but these 3 pieces of info seem complicated based on where they are in the tables. Currently, i am grabbing all this information from the ocs tables since the data is easier to get. Could anyone provide me with a sql query to grab this information from the glpi tables based on computer id? thanks.
Last edited by dan2003 (2009-05-08 19:12:40)
Offline