SQL query to list all the software installed in workstation including prohibited , user-defined type of software?

SQL query to list all the software installed in workstation including prohibited , user-defined type of software?

Dear all AE expertise,


I know a little about SQL statement. Could any expertise tell me how to query all the software installed in workstation with asset state and username. The software installed is includinng all software type , such as prohibited and user defined type.

Thank you in advance.

Raymond Cheung

              New to ADManager Plus?

                New to ADSelfService Plus?