var instURL = gs.getProperty('glide.servlet.uri');
if (instURL.indexOf('https://xxxx_prod.service-now.com') > -1) {
gs.print('do not run on prod');
} else {
var cmdb_rel_count = getCMDBciRELcount();
var cmdb_endpoint_count = getCMDBendpointCount();
var runDelete = false; //--counts only if false, no delete
runDelete = true; //--deletes/tidyup enabled
gs.log('Script start...[cmdb_ci_rel count=' + cmdb_rel_count + ']', 'CMDB Tidyup');
gs.log('Script start...[cmdb_ci_endpoint_manual count=' + cmdb_endpoint_count + ']', 'CMDB Tidyup');
gs.log('Script start...[runDelete=' + runDelete + ']', 'CMDB Tidyup');
cmdb_tidyup(runDelete);
cmdb_rel_count = getCMDBciRELcount();
cmdb_endpoint_count = getCMDBendpointCount();
gs.log('Script end...[cmdb_ci_rel count=' + cmdb_rel_count + ']', 'CMDB Tidyup');
gs.log('Script end...[cmdb_ci_endpoint_manual count=' + cmdb_endpoint_count + ']', 'CMDB Tidyup');
}
function getCMDBciRELcount() {
var gr = new GlideRecord('cmdb_rel_ci');
gr.query();
return (gr.getRowCount());
}
function getCMDBendpointCount() {
var gr = new GlideRecord('cmdb_ci_endpoint_manual');
gr.query();
return (gr.getRowCount());
}
function cmdb_tidyup(runDelete) {
var gr = new GlideRecord('cmdb_ci_endpoint_manual');
gr.orderBy('sys_created_on');
gr.chooseWindow(0, 200000);
gr.query();
epsWithoutService = [];
while (gr.next()) {
var epSysId = gr.getValue('sys_id');
var grCiAssoc = new GlideRecord('svc_ci_assoc');
grCiAssoc.addQuery('ci_id', epSysId);
grCiAssoc.query();
if (!grCiAssoc.hasNext()) {
epsWithoutService.push(epSysId);
if (runDelete) {
var directRel = gr.getValue('direct_relation');
gr.deleteRecord();
if (directRel) {
var grRel = new GlideRecord('cmdb_rel_ci');
grRel.get(directRel);
grRel.deleteRecord();
}
}
}
}
if (epsWithoutService.length > 0) {
gs.log('found ' + epsWithoutService.length + ' endpoints wich are not associated with a service', 'CMDB Tidyup');
/* gs.log('EPsa are:', 'CMDB Tidyup');
gs.log(epsWithoutService, 'CMDB Tidyup'); */
}
}
these seem to work! function onSubmit () { alert ( g_form . getDisplayBox ( 'cost_center' ). value ); //--classic UI alert ( g_form . getDisplayValue ( 'cost_center' )); //--service portal }
Comments
Post a Comment