Some publishers are not showing in "Run Reconciliation" Publishers drop down list and How is "Run Reconciliation" Publishers drop down list retrieved? - Support and Troubleshooting

Some publishers are not showing in "Run Reconciliation" Publishers drop down list and How is "Run Reconciliation" Publishers drop down list retrieved? .ns-kb-css-body-editor-container { p { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } span { font-size: 12pt; font-family: Lato; color: var(--now-color--text-primary, #000000); } h2 { font-size: 24pt; font-family: Lato; color: var(--now-color--text-primary, black); } h3 { font-size: 18pt; font-family: Lato; color: var(--now-color--text-primary, black); } h4 { font-size: 14pt; font-family: Lato; color: var(--now-color--text-primary, black); } a { font-size: 12pt; font-family: Lato; color: var(--now-color--link-primary, #00718F); } a:hover { font-size: 12pt; color: var(--now-color--link-primary, #024F69); } a:target { font-size: 12pt; color: var(--now-color--link-primary, #032D42); } a:visited { font-size: 12pt; color: var(--now-color--link-primary, #00718f); } ul { font-size: 12pt; font-family: Lato; } li { font-size: 12pt; font-family: Lato; } img { display: ; max-width: ; width: ; height: ; } } Description Some publishers are not showing in " Run Reconciliation " Publishers drop down list and How is " Run Reconciliation " Publishers drop down list retrieved?

Explanation This is the code responsible on retrieving the publishers in " samp_run_reconciliation_by_publisher" UI page rendered when you navigate to "Run Reconciliation" UI Module: https://Instance_Name.service-now.com/sys_ui_page.do?sys_id=0074b4f33b132200e724ea2b34efc48b

var result = []; var entitlement = new GlideAggregate("alm_license"); entitlement.addNotNullQuery("model"); entitlement.addNotNullQuery("model.manufacturer.sys_id"); entitlement.addQuery("software_model.sw_product_type", ReconciliationConstants.PRODUCT_TYPE_LICENSABLE_VALUE); entitlement.addQuery("software_model.product.ignore_installs", "false"); entitlement.setNoLimit(true); entitlement.setGroup(true); entitlement.groupBy("model.manufacturer"); entitlement.query();

while (entitlement.next()) { var obj = { 'text': entitlement.getDisplayValue("model.manufacturer"), 'id': entitlement.getValue("model.manufacturer") }; result.push(obj); } var stringify = JSON.stringify(result); stringify;

Based on the logic defined, the publishers will only qualify to show in the publishers drop down list when the following conditions are fulfilled: There are entitlements associated with software models which are associated with products from this manufacturer with "Product Type" is Licensable and with "ignore_installs" equals false.

For ease, you could also run the same logic to retrieve the publishers as a Background Script in global scope on your instance which will print the list of the publishers/manufacturers that are qualified to show in the "Publishers" drop down list:

var entitlement = new GlideAggregate("alm_license"); entitlement.addNotNullQuery("model"); entitlement.addNotNullQuery("model.manufacturer.sys_id"); entitlement.addQuery("software_model.product.sw_product_type", "licensable"); entitlement.addQuery("software_model.product.ignore_installs", "false"); entitlement.setNoLimit(true); entitlement.setGroup(true); entitlement.groupBy("model.manufacturer"); entitlement.query();

while (entitlement.next()){ gs.print(entitlement.getDisplayValue('model.manufacturer')); }