I need some assistance creating a report that only has modified assets within a certain period of time such as a week.  For example if I had a printer that was already assigned a location, then say Tuesday it was moved and assigned another location.  I would like to have that to show up in a report that I would schedule on, say, a Friday afternoon.  How do I access the last modified field or history field?

 

Answer Summary:
Cancel
1 Comment   [ + ] Show Comment

Comments

  • I have a similar need for when a computer asset hasn't been modified in the last two years.
Please log in to comment

Answers

0

In the very simplest of terms like this... The filed to target is MODIFIED

 select * from ORG1.ASSET 
where DATEDIFF(NOW(), MODIFIED) <= 7
Answered 08/21/2013 by: jdornan
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity