Skip to main content

Search the system for a specific SYS ID sys_id

Search the system for a specific SYS ID sys_id

Search the system for a specific SYS_ID
Search the system for a specific SYSID

OPTION 1: if you have SNUtils Installed

if you have SNUtils installed, you can search for a sys_id like so:



this will load the record. To install SNUtils, see this link

See my other posts on SNUtils

OPTION 2: run your own script


[courtesy of] Shahed Ali Shah

// ******************* // * Search for Sys ID searchIt('e1ce533b1b117c1049c38732f54bcb88');




function searchIt(sys_id) {​​​ gs.print('Searching for ' + sys_id); var baseTables = new GlideRecord('sys_db_object'); baseTables.addEncodedQuery('super_classISEMPTY^nameNOT LIKEts_c_^nameNOT LIKEsysx_^nameNOT LIKEv_'); baseTables.addEncodedQuery('sys_scope=global^NQaccess=public^read_access=true'); // avoid the scope issue trap baseTables.query(); while (baseTables._next()) {​​​ var sTableName = baseTables.getValue('name'); // Does the table have a sys_id field var sd = new GlideRecord('sys_dictionary'); sd.addQuery('name', sTableName); sd.addQuery('element', 'sys_id'); sd.queryNoDomain(); if(!sd.isValid()) continue; if(!sd._next()) continue; // Search the table var grFound = new GlideRecord(sTableName); grFound.addQuery('sys_id', sys_id); grFound.queryNoDomain(); if(grFound._next()) {​​​ gs.print('Found it in ' + grFound.getClassDisplayValue() + ' [' + grFound.getRecordClassName() + '] /' + grFound.getRecordClassName() + '.do?sys_id=' + sys_id); break; }​​​ }​​​ gs.print('End of Search'); }​​​

Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

URL link in addInfoMessage

var ga=new GlideAjax('gld_HR_ajax'); ga.addParam('sysparm_name', 'checkEmployeeNumber_hrProfile'); ga.addParam('sysparm_hrprofilenumber', g_form.getValue('number')); ga.addParam('sysparm_employeenumber', newValue); ga.getXMLAnswer(function(answer) { if (answer!='undefined' && answer!=''){ var navURL="<a style='text-decoration:underline;color:blue' href=hr_profile.do?sysparm_query=number=" + answer + ">" + answer + "</a><img width='3' src='images/s.gif'/>"; var sMsg='The employee number entered already exists on another HR Profile ' + navURL; //alert(sMsg); g_form.showErrorBox('employee_number', 'error - please check'); g_form.addInfoMessage(sMsg); } });