Skip to content

Instantly share code, notes, and snippets.

@xoner

xoner/QUERY_OCS_SOFTWARE.sql

Created June 15, 2012 09:22
Show Gist options
  • Save xoner/2935577 to your computer and use it in GitHub Desktop.
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