Hello,
I am trying to update the WorldMapPoints Latitude and Longitude with RawStatus data from custom pollers.
These custom pollers pull latitude and longitude from input GPS data, which is returned as the RawStatus field in each. These are remote moving locations.
Here is the query I have for latitude, have not started on longitude yet.
UPDATE [SolarWindsOrion].dbo.[WorldMapPoints]
SET Latitude = (Select Rawstatus
FROM [SolarWindsOrion].dbo.[WorldMapPoints] WPS
INNER JOIN [SolarWindsOrion].dbo.CustomPollerAssignment CPA
ON wps.InstanceID = CPA.NodeID
INNER JOIN [SolarWindsOrion].dbo.CustomPollerStatus CPS
ON cps.CustomPollerAssignmentID = cpa.CustomPollerAssignmentID
Where wps.InstanceID = CPA.NodeID AND CPA.AssignmentName Like '%Latitude%')
I had to join the CustomPollerStatus table with the CustomPollerAssignmentID table since the status table did not have the nodeID. I then joined them to the InstanceID in the WorldMapPoints table, which is essentially the NodeID.
The query above executed, but updated all the latitude fields to the same value.
I have seen others on here do some similar updates, but mostly for static locations and using latitude/longitude as custom properties.
