/build/static/layout/Breadcrumb_cap_w.png

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:
Posted by: jdornan 10 years ago
Red Belt
0

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

 select * from ORG1.ASSET 
where DATEDIFF(NOW(), MODIFIED) <= 7

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ