This guide outlines the steps to verify if the inbound integration from PeoplePlanner to SelectHR is working correctly.
By using the Admin Tool and a specific SQL query, you can check recent inbound message activity to confirm the integration's functionality.
Inbound integration (PeoplePlanner into SelectHR)
Log in to the SelectHR Administrator Tool.
Click Import/Export Data.
Click Create an export definition.
Click Select the data to export.
Change the database to SelectHR.
Log in.
Copy the below SQL:
SELECT TOP 1000 DataHub.EventMessages.MessageNumber,
DataHub.EventMessages.CreatedDate,
DataHub.EventMessages.EventName,
DataHub.[Queue Directions].Direction,
DataHub.EventMessages.DateProcessed,
DataHub.EventMessages.Acknowledged
FROM DataHub.EventMessages
INNER JOIN DataHub.Queues ON DataHub.Queues.QueueNumber = DataHub.EventMessages.QueueNumber
INNER JOIN DataHub.[Queue Directions] ON DataHub.[Queue Directions].QueueDirectionNumber = DataHub.Queues.DirectionNumber
WHERE DataHub.[Queue Directions].Direction = 'Inbound'
ORDER BY DataHub.EventMessages.MessageNumber DESCIn the top left of the data export window, click Options, Paste SQL from clipboard.
Click Data.
This export will only show the top 1000 Inbound messages, so what you are looking for are records with a Created Date later than when you believe it stopped working.
If there are messages very recently (within the last 30 minutes) then it is safe to consider that the integration is functional.