Logging network status

Archived Topics
16

Thanks MickeyBob, that worked great. I appreciate what you put into that.

I had to make one change because I can’t always guarantee that the indexes will be consectutive or even start at one (it is an identity column, and I might delete rows during development, or the customer may delete devices). So, I used a CTE to create a temp table of row_numbers and IP addresses, which gave me this query in your AddressQuery:

Concat("WITH IPs(RowNumber, Address) AS (SELECT     ROW_NUMBER() OVER (ORDER BY index) AS r, Address
FROM        DevicesToPing)
    SELECT     Address
     FROM         ips
     WHERE     RowNumber = ", ToString({Index}))

Now, it just loops through all the rows in the table and ignores the index.