Greetings @MEBoatman. I wonder if others can share if they've ever used the CMDB Query Builder for a no-code approach to identifying these records. If this is not achievable, the thought that comes to mind is the build the list of records (minus those to be excluded) via a scripted report.
To do this, you can create a new function within a Script Include that uses a GlideRecord query to build the desired list of Business Applications you wish to display. I'll include some sample code and screenshots below to get the conversation started. As always, interested in what others have to share and if there are better solutions.
Note: This requires that the Business App Request records for the Retire Business Application Requests are populating the Business Application value in the Configuration Item (cmdb_ci) field. In my PDI, this is NOT out of the box behavior so would need to be configured as such if you are not already doing this.
Script Include:
var BusAppFilterUtils = Class.create();
BusAppFilterUtils.prototype = {
initialize: function() {},
removeRetireRequests: function() {
var exclude_list = [];
// Query the Business Application Request table
// State is one of - Pending, Open, Work In Progress
// Short Description - Request to retire business application
// ENSURE YOU ARE POPULATING THE BUSINESS APPLICATION BEING IMPACTED IN THE CMDB_CI FIELD!!!!
var retire_request = new GlideRecord('business_app_request');
retire_request.addEncodedQuery('stateIN-5,1,2^short_descriptionSTARTSWITHRequest to retire business application');
retire_request.query();
while (retire_request.next()) {
exclude_list.push(retire_request.cmdb_ci.toString());
}
//Return the final query that is excluding those Business Applications with open BAR
return exclude_list;
},
type: 'BusAppFilterUtils'
};
Then, back on the report screen, you start to use the Condition Builder and call this function within the text field. Since you can't see the full text within the screenshot for the 'Sys ID - is not' field, I'll include the code here: javascript: new global.BusAppFilterUtils().removeRetireRequests();
