Device details can be retrieved from NCM GUI under Devices view as shown in below screenshot.
SysOID details can be obtained from InfraDB dump of AS or DS server, follow below steps to dump infradb to .txt file from which SysOID details can be extracted: