2 Replies Latest reply on Nov 12, 2012 12:49 AM by alanmengo

    Can't see all inventory history changes in the HISTORY table

    Rookie

      Does anyone know of a SQL query or point me to a table in the LANDesk database that keeps track of hardware inventory history such as memory? I ran a query like this against my LANDesk database but I only managed to get info such as USB-attached devices and optical drives. I have already turned on tracking for memory and a couple other things, and although I can view memory history for a test workstation that I pulled some RAM out of, I cannot pull that information from the HISTORY table the database.

       

      Here's the SQL query:

       

      select devicename,isnull(oldstr,'') as Old_Status, isnull(NewStr,'') as New_Status, ChangeDate from computer c left join history h on c.computer_idn=h.

      computer_idn where changedate is not null

       

      Thanks.