/build/static/layout/Breadcrumb_cap_w.png

Miscellaneous Question


Asset Report by date last modified

08/21/2013 2065 views

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:
1 Comment   [ + ] Show comment

Comments

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

All 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

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