I would like to create LANDesk queries based on information from a different SQL Database. The SQL Query works after configuring linked server in SQL and so on.
In this Doc http://community.landesk.com/support/docs/DOC-5789 it's mentioned how it's possible to view SQL statements from Queries created through LANDesk. It also mentions that you can't just change the 'QuerySQL' Filed with a random query (I missed that part when I first read it) but there's got to be a way.
Has anybody done it?