Say we have applications made of IT components and each IT component is linked to a provider (i.e. vendor).
Can you search in the inventory for all apps that have at least 1 IT component from a specific vendor?
I have tried but I could not find how apart from accessing the relationship explorer for the provider I am interested into, but I’d like a search or a report instead.
Best answer by Thomas Schreiner
Hi @Roberto,
You can do it like this:
Open the Inventory
In the side bar, select the fact sheet type “Application”
In the side bar, look for the section “IT Components”. If you cannot find it, you need to un-hide it first using the side bar settings.
In the side bar’s IT Component section, click on “Advanced filter”.
In the advanced filters side bar, look for the “Provider” section, or enter the provider name in the top filter bar.
Select the provider, and you will get a list of IT Components for this provider.
Click on “Use Filter” at the bottom right.
=> You will get an inventory view with those applications that have one or more IT Components of the Provider that you selected.
If you only need the numbers and not necessarily in LeanIX itself, you can run the following script in LeanIX Console:
for provider in Provider.all(): apps_per_provider = set(app["id"] for itc in provider.itcomponents() for app in itc.applications()) print(provider["displayName"] + ": " + str(len(apps_per_provider)))
Thanks Thomas, that works! - any way you know this could be made into a report that lists all providers and the # of apps associated to each one?
Another thing you can try is using a Matrix report for IT Components, then select Applications in the Y-axis and Providers in the X-Axis (or the other way around). That will give you a full picture, but you can filter on each of the FactSheet types to constrain as required.