The alert log content is stored within the LANDesk database. There are a number of tables you will note start with Alert.. however the ones you may be most interested in are AlertLog and AlertStrings. The AlertLog table actually lists each event generated by the core or managed devices, and has a column called AlertId which can be used to link to the StringId column in the AlertStrings table. The StringValue and Description columns can then be used to get the 'plain text' message for each alert.
Hope thats what you were looking for.
Thanks for your response. My need is quite simple. In the console, I can query the inventory history by right clicking on a client and choosing "inventory history" from the item list. The SQL scripts are what I need. Can help?
Well if its Inventory histroy you are after how about the following.
Computer.DeviceName, History.ChangeDate, METAATTRIBUTES.ENU, History.OLDSTR, History.OLDINT, History.OLDDATE, History.NEWSTR, History.NEWINT,
History INNER JOIN
ON History.MetaObjAttrRelations_Idn = METAOBJATTRRELATIONS.METAOBJATTRRELATIONS_IDN INNER JOIN
ON METAOBJATTRRELATIONS.METAATTRIBUTES_IDN = METAATTRIBUTES.METAATTRIBUTES_IDN INNER JOIN
ON History.Computer_Idn = Computer.Computer_Idn
Thanks a lot!