Hello.

We need a query to make a report on assets that have recently been disposed.

Database: Postgres SQL

Build: 7.5 Build 7530

Note: We do not have Servicedesk Plus, only Asset Explorer.

I need a query for assets that has recently (like in the last week or day) changed status to "Disposed".

I want the following columns:

* Asset Name

* Asset Tag

* Product type

* Product

* Disposed by

* Disposed Date

I would also want it to contain two costume fields if possible, called "IS#" and "Security Rating".

Big advantage if we can modify how far back we want the query to run.