Retrieving Associations

The Get-EmdbAssociation cmdlet retrieves associations and returns information about them or about the source or target objects. It is mandatory to specify the type of associations to be retrieved. The following association types are available:


Association type

Description

BootEnvUsesPnpPackage

Used Driver Packages / Used by Boot Environment Packages

CitrixDeliveryController

Citrix Delivery Controller running on / Citrix Delivery Controller for

ComputerAssociatedUser

Associated with user / Associated with computer

ComputerDevice

Installed device / Installed on

ComputerMissingPatch

Vulnerabilities / Other computers with this vulnerability

ComputerNwDevice

Network device / Network device from

ComputerRequiresSoftware

Computer requires software / Other computers that also require this software

DashboardTileConfig

Tiles on the dashboard / List of dashboards

eScriptComponents

eScript components

ExternalGroupMembers

Members of the external group / Member in external groups

GroupMembers

Members of the group / member in groups

MSWUV6ScanCabPkgs

Assigned PM patch packages

SoftwareCulture

Supported languages / Other software supporting this language

SoftwareOS

Supported operating systems / Software that supports this operating system

SoftwareOSFlavor

Supported operating system variant / Software that supports this operating system variant

SoftwareReplacesSoftware

Software replaces software

SoftwareRequiresSoftware

Software requires software

SwCategoryMembers

Software category members / member in software categories

SwSetComponents

Software set components / Other software sets that use this software

UserFavorites

User's favourites / Is favourite of

VMHostGuests

Guest computer of the VM Host / Guest of


Examples:


Hint: The execution of these examples requires a connected PowerShell drive.


The first example retrieves all associations about missing patches of the WIN10-01 computer and returns the corresponding patch packages by using the ReturnTarget-switch:


$MyComputer = Get-EmdbComputer "WIN10-01" -Recurse

Get-EmdbAssociation -AssociationType ComputerMissingPatch -Source $MyComputer -ReturnTarget 


Here, all Software Sets are determined in which the package "Notepad++ 8.5.1 German" is used:


$MyPackage = Get-EmdbSoftwarePackage "Notepad++ 8.5.1 German" -Recurse

Get-EmdbAssociation -AssociationType SwSetComponents -Target $MyPackage -ReturnSource


In the last example, all members of the External Group "SAP user" are determined:


Get-EmdbAssociation -AssociationType ExternalGroupMembers -Source $(Get-EmdbGroup "SAP-User" -Recurse) -ReturnTarget