Untitled

var count = 0;
var no_affinity = [];

var gr = new GlideRecord("discovery_credentials");
gr.query();
while (gr.next()) {
   var grA = new GlideRecord("dscy_credentials_affinity");
   grA.addEncodedQuery("credential_id=" + gr.sys_id);
   grA.query();
   if(!grA.next()){
	no_affinity.push(gr.name.toString());
	count += 1;
   }
}

gs.info(count + " Credentials Without affinity");
gs.info(no_affinity);