Epics without Stories
Blog - ServiceNow Elite
·
Jul 06, 2020
·
article
Here is a quick script to find Epics without Stories
1. Elevate your privilege to security_admin.
2. In the Left Navigator > Scripts - Background
3. Paste this in the Run Scripts area:
//Find Epics without Stories
(function() {
var epicList = [];
var grEpic = new GlideRecord("rm_epic");
grEpic.query();
while (grEpic.next()) {
var gaStory = new GlideAggregate("rm_story");
gaStory.addQuery("epic",grEpic.sys_id);
gaStory.addAggregate('COUNT');
gaStory.query();
if (gaStory.next()) {
if (gaStory.getAggregate('COUNT') == 0) {
epicList.push(grEpic.getValue("number"));
}
}
}
gs.print(epicList.toString());
})();
4. Click Run Script
View original source
https://www.servicenowelite.com/blog/2020/7/6/epics-without-stories