try like bellow
var nrecord = new SCFile('node',SCFILE_READONLY); nrecord.setFields(['addlMacAddress']); var mac_addresst = '3464A9D075E1'; var sqlClause = 'SELECT logical.name FROM node WHERE addlmacaddress LIKE '; sqlClause = sqlClause "\"" mac_addresst "\""; if (nrecord.doSelect(sqlClause)==0) print(nrecord);
You don't need worry about null values doSelect method will return non 0 (RC_SUCCESS) value if record dosen't exist;
I'm not sure about performance in your environment. If it's dosen't help I'm suggesting do debugging for db queries and open case for the HP support.