SWQL find the foreigner key

Question

Hi, 
 I need help to find the foreigner key to join the table. For example, I know I can do a join to get datastores linked to a host or a cluster. And I also see the chain icon shows "dataSotres(Orion,VIM,Datastores)." as in the screenshot. But how can I find the foreigner key to link them? I don't see the same keys in those two tables. 
 Thank you so much.

KMSigma.SWI · Accepted Answer

Those are navigation properties and you don't need to JOIN them, you can just call them. It's covered in Episode #86 - Orion SDK 101: Intro to PowerShell and Orion API - SolarWinds Lab Archive - SolarWinds Lab - THWACK . 
 The syntax would be something like: 
 SELECT [Hosts].BootTime
 , [Hosts].BiosSerial
 , [Hosts].DNSHostName
 , [Hosts].IPAddress
 , [Hosts].DataStores.Name AS [DatastoreName] -- <-- we do the 'join' for you
 , [Hosts].DataStores.FreeSpace AS [DatastoreFreeSpace] -- <-- we do the 'join' for you
FROM Orion.VIM.Hosts AS [Hosts]

SWQL find the foreigner key

Top Replies