SWQL Resource for remote Orion install

I've never seen it done,  I imagine it could be possible to copy the aspx of the custom resource and modify it if you are familiar with coding that sort of thing.

thinking you could run SQL server component monitors against the other SQL database to return a static from the other orions database..

Then again might be worth writing something that will communicate over SWIS information service and just declaring the ip addresses when executing the script, I'm thinking this could be achieved with 'da' powershell

'remote install' didn't see that

Not sure about SWQL, but you can use SQL queries for another database on the same server with the following in a Custom Table resource:

select * from [<servername>].[<databasename>].[dbo].[<tablename>]

The Orion sql user should have read access to the other database that you're running the query on.