A simple SWQL query to gather the Engines Table information from EOC for all underlying sites?

hi steven,

from everything i see, if you just add [instancesiteid] into your query, it is an inherit property on most tables... well, all that ive seen.
i tested it on a handful and searched this property in swql and its most tables. 

SELECT TOP 100 [data].[Caption] AS [Caption],[data].[IP_Address] AS [IP_Address],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.nodes AS data

hi steven,

from everything i see, if you just add [instancesiteid] into your query, it is an inherit property on most tables... well, all that ive seen.
i tested it on a handful and searched this property in swql and its most tables. 

SELECT TOP 100 [data].[Caption] AS [Caption],[data].[IP_Address] AS [IP_Address],[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.nodes AS data