SELECT * FROM IoTDeviceAddress WHERE TYPE='SpruceSensorAdd' ;