How do I export Related Items within Business Application to xlsx ?

[Oliver Strein]

I have the need to export the "Related Items" within a Business Application into a xlsx speadsheet but don't know how?

Basically the same routine which is generating the "Related Items"-List which is also used to generate the Dependency Map!?

Thanks a lot

[CMDB Whisperer]

Assuming you are following CSDM and defining your infrastructure relationships up to an Application Service that is consumed by the Business Application, then go to the svc_ci_assoc table and filter it down to the specific Application Service you are interested in, and then select Export -> XLS.

If you are not using CSDM prescribed methods (you should be!) and are instead relating your Business Applications directly down to the infrastructure level, then you can go to the cmdb_rel_ci table and filter the relationships down to the one where Parent is the Business Application that you are interested in, and then export the list to XLS for the first-level dependencies.  If you want more than first-level dependencies, you'll have to query them via CMDB Query Builder.  I don't know of a good way to export results from Query Builder to XLS.