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