Video Screencast Help

Assets with Status Changes

Created: 13 Feb 2013 • Updated: 14 Feb 2013 | 4 comments
This issue has been solved. See solution.

I am trying to create a report that lists all assets with status changes.  I could have sworn that there was an out of the box report that was available but I'm not able to find it in my configuration.  While I continue to work on the report, I was hoping that someone might have run across this as well and might be able to help me out a little.  Thanks.

Comments 4 CommentsJump to latest comment

Reena Joshi's picture

Please let me know if my understanding is correct. You are looking for a report which lists all the assets whose status has been changed i.e. a report which will list all the assets with their earlier and present status.

tschenke's picture

Yes, I want a list of assets that have had a status changed.  I have a rule that takes any computer that has not reported a basic inventory in 90 days and set it to retired.  I know that if one of those computers suddenly finds it's way back on to the network, it's asset status will change back to active.  i'd like a report that shows all assets that have had a status change in the past X number of days to keep an eye on those machines.  Does that make sense?  I know that I can check a data class for the last time it was modified but I'm having a hard time tracking that down.  

bonvicin's picture

Take a look at the following KB article titled How does an asset's Status work?

The very last query in the article will provide the date of the last status change.  All you need to do is add a condition to return only those assets with changes in the last 90 days.

tschenke's picture

Funny, I opened that link the other day and never looked at it.  That is exactly what i'm looking for.  Thank you very much.