Prepare list of Servers with SPK info, near to warranty expiry

hi everyone. I want to prepare a list of servers with SPK info that are near to warranty expire. i try couple of queries but i couldn't get anything. thank you in advance

Welcome

Please share what you have already tried?