I'm not sure if this is the correct forum, but here we go:
I am trying to build a Database View that shows:
Servers Related to Application Services that again is related to Business Applications.
I am using the cmdb_rel_ci for relations:
It will not work.
I can make it show servers related to Application Services or Application services related to Business Applications, but combining the two is not possible.
I can make it work with the CMDB Query builder, but that solution is not suitable for my need.
I also tried with at Script Include solution, without luck.
Does anyone have a solution ?
If I'm following your example correctly in how I setup some sample CIs, you'll want your DB view to look like this - just no left join on 200 needed, from what you had:
This gives you too many records, which is a good start as you have all of the tables joined. Now you just have to filter the list to only show the records that you want. In my case I excluded Name (aps_name) != NULL, but you can add ba_name != NULL as well, or whatever.
Once you have the DB View manually filtered to only show the records you want, right click on the last filter breadcrumb and Copy Query. Then create a before Query Business Rule using the view name as the table. The script will use the query to always filter the results:
(function executeRule(current, previous /*null when async*/ ) {
current.addEncodedQuery('aps_name!=NULL^ba_name!=NULL');
})(current, previous);
If I'm following your example correctly in how I setup some sample CIs, you'll want your DB view to look like this - just no left join on 200 needed, from what you had:
This gives you too many records, which is a good start as you have all of the tables joined. Now you just have to filter the list to only show the records that you want. In my case I excluded Name (aps_name) != NULL, but you can add ba_name != NULL as well, or whatever.
Once you have the DB View manually filtered to only show the records you want, right click on the last filter breadcrumb and Copy Query. Then create a before Query Business Rule using the view name as the table. The script will use the query to always filter the results:
(function executeRule(current, previous /*null when async*/ ) {
current.addEncodedQuery('aps_name!=NULL^ba_name!=NULL');
})(current, previous);
