xoner/QUERY_OCS_SOFTWARE.sql

Created June 15, 2012 09:22

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/xoner/2935577.js"></script>
Save xoner/2935577 to your computer and use it in GitHub Desktop.

Download ZIP

Simple query to get the software installed across the computers.

Raw

QUERY_OCS_SOFTWARE.sql

	USE ocsweb;

	SELECT H.NAME, S.NAME, S.VERSION
	FROM softwares S, hardware H
	where S.NAME LIKE '%SoftwareName%' AND H.ID = S.HARDWARE_ID;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment