Retrieving Associations
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 |