I am trying to figure out a way to write a SQL query to the Landesk database to provide all the information found in the dbo.Computer table along with the OS.
Does anyone have a snippit of SQL that I can run to get this information? The idea is for me to create a web front-end for other departments in IT to query asset inventory information from a custom web application. I just don't know where the OS info is stored. I would imagine there will be some joins to other tables.
Any help would be appreciated.