How we can query the kb_manager current sys_id from knowledge base table

[Amrutha K V]

Hi All,

How we can query the kb_manager current sys_id from knowledge base table(kb_knowledge_base) after gliding Knowledge base table.

Thank you!

[Hemanth M1]

Hi @Amrutha K V 

Are you looking for sys_id of the knowledge base managers, you try below script.

var kbManager = new GlideRecord("kb_knowledge_base");
kbManager.addQuery("sys_id", "sys_id of the knowledge base");
kbManager.query();
if(kbManager.next()){
kbManager.getValue("kb_managers"); //this would give comma separated managers sys_ids
}

[Bert_c1]

Hi Amrutha K V,

Try the following script (if you are looking for script logic):

var kb = new GlideRecord('kb_knowledge');
kb.addQuery('active', true);
kb.query();
while (kb.next()) {
   var kbBase = new GlideRecord('kb_knowledge_base');
   kbBase.addQuery('sys_id', kb.kb_knowledge_base.toString());
   kbBase.query();
   if (kbBase.next()) {
      gs.info("KB: " + kb.number + ", knowledge base: " + kbBase.title + " has managers: " + kbBase.kb_managers.getDisplayValue());
   }
}

[Mitsua]

Hello @Amrutha K V 

You can use below script to fetch manager sys_id of knowledge base.

var kbManager = new GlideRecord('kb_knowledge_base');
kbManager.addQuery('sys_id','sys_id of knowledge base');
kbManager.query();
if(kbManager.next()){
    var manager = kbManager.kb_managers; // comma seperated list of sys_id stored in this "manager" variable
}

@Amrutha K V Let me know if any queries.

Please mark this as correct answer/accepted and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks

MS!

Community Rising Star 2023