I'm trying to find a way to search asset history and am unsure if that is possible or not. Using advanced search that field is not an option to search on. Ideas?


0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


You can write a custom SQL report to show asset history. The reason it isn't a field to search on is because the KBOX interface is displaying info from the ASSET table on the Inventory page - the data isn't really in Inventory at all.
Answered 12/14/2010 by: airwolf
Tenth Degree Black Belt

Please log in to comment
Answered 12/14/2010 by: GillySpy
Seventh Degree Black Belt

  • broken link....
  • Link is fixed now
  • FYI this will only work on 5.3 and earlier. ASSET_HISTORY structure was changed in 5.4 for the better so that you do not have to parse the DESCRIPTION field as much as you once did.
Please log in to comment
I gotta tell you most of the custom SQL stuff is way over my head. I'll give it a shot though and see what I come up with.


Answered 12/14/2010 by: JesseLara
Orange Belt

Please log in to comment