Custom Report - software on computers that are not in use

Custom Report - software on computers that are not in use

I need help with a sql query to show the software that is installed on workstations that are disposed, in store, or surplused.

I just need it to have the Software Installed, Asset name, and Resource State.

Is there a way to do this?

Thanks!






                  New to ADSelfService Plus?