Asset Report by date last modified
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?
1 Comment
[ + ] Show comment
-
I have a similar need for when a computer asset hasn't been modified in the last two years. - londeaux 10 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
jdornan
11 years ago
In the very simplest of terms like this... The filed to target is MODIFIED
select * from ORG1.ASSET where DATEDIFF(NOW(), MODIFIED) <= 7
