Get-LPMSAppActivityData

# Get-LPMSAppActivityData

SYNOPSIS

Enriches application data with API activity information from Azure Log Analytics.

SYNTAX

ByWorkspaceId (Default)

Get-LPMSAppActivityData -AppData  -WorkspaceId  [-Days ] [-ThrottleLimit ]
 [-MaxActivityEntries ] [-retainRawUri] [-ProgressAction ] []

ByWorkspaceDetails

Get-LPMSAppActivityData -AppData  -subId  -rgName  -workspaceName 
 [-Days ] [-ThrottleLimit ] [-MaxActivityEntries ] [-retainRawUri]
 [-ProgressAction ] []

DESCRIPTION

This function queries Azure Log Analytics workspace to retrieve Microsoft Graph API activity for each application over a specified time period using PowerShell 7's native parallel processing. Uses ForEach-Object -Parallel for efficient concurrent execution while maintaining simplicity and native PowerShell functionality. Activity data includes:

HTTP methods used (GET, POST, PUT, PATCH, DELETE, etc.)
API endpoints accessed (normalized and tokenized for pattern matching)
Unique method/URI combinations (deduplicated)
Tokenized URIs with {id} placeholders for permission mapping

This data is essential for:

Determining least privileged permissions based on actual API usage
Identifying unused permissions that can be removed
Understanding application behavior and API consumption patterns
Auditing what Graph API operations applications perform
Planning permission optimization initiatives

Key Features:

Parallel processing using PowerShell 7 native functionality (5-10x faster for large datasets)
Optimized parameter handling (pre-builds workspace parameters for efficiency)
Memory efficient processing with single-pass statistics gathering
Individual error handling (one failure doesn't stop processing)
Verbose logging for monitoring and progress tracking
Returns enhanced objects with Activity property and optional ErrorMessage for diagnostics

EXAMPLES

EXAMPLE 1

$apps | Get-LPMSAppActivityData -WorkspaceId $workspaceId -Days 90 -ThrottleLimit 20 -Verbose

Queries activity data using the workspace ID (ByWorkspaceId parameter set).

EXAMPLE 2

$apps | Get-LPMSAppActivityData -subId $subscriptionId -rgName $resourceGroup -workspaceName $workspace -Days 30 -Verbose

Queries activity data using workspace details (ByWorkspaceDetails parameter set) when using user_impersonation scope.

PARAMETERS

-AppData

An array of application objects to enrich with activity data. Each object must contain: Required Properties:

PrincipalId (String): The Azure AD service principal object ID
PrincipalName (String): The application display name (used for logging/progress)

Optional Properties:

Any other properties are preserved and passed through
Common properties: AppId, Tags, AppRoles, etc.

This parameter accepts pipeline input, allowing you to pipe application objects directly from Get-MgServicePrincipal or other sources.

Type: Array
Parameter Sets: (All)
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: False

-WorkspaceId

The Azure Log Analytics workspace ID (GUID) where Microsoft Graph activity logs are stored. This workspace must contain the MicrosoftGraphActivityLogs table with diagnostic logging enabled. Used with the 'ByWorkspaceId' parameter set (default). Mutually exclusive with subId, rgName, and workspaceName parameters.

Type: String
Parameter Sets: ByWorkspaceId
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-subId

Azure subscription ID where the Log Analytics workspace is located. Used with the 'ByWorkspaceDetails' parameter set. Required when using user_impersonation token scope.

Type: String
Parameter Sets: ByWorkspaceDetails
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-rgName

Resource group name where the Log Analytics workspace is located. Used with the 'ByWorkspaceDetails' parameter set. Required when using user_impersonation token scope.

Type: String
Parameter Sets: ByWorkspaceDetails
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-workspaceName

Log Analytics workspace name. Used with the 'ByWorkspaceDetails' parameter set. Required when using user_impersonation token scope.

Type: String
Parameter Sets: ByWorkspaceDetails
Aliases:

Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

-Days

The number of days of historical activity to retrieve, counting back from the current date. Default: 30 days

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: 30
Accept pipeline input: False
Accept wildcard characters: False

-ThrottleLimit

The maximum number of concurrent runspaces to use for parallel processing. Valid range: 1-50 concurrent workers. Default: 10 Recommended values:

5: Conservative for rate-limited environments
10: Balanced performance (default)
20: Aggressive for high-throughput scenarios

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: 10
Accept pipeline input: False
Accept wildcard characters: False

-MaxActivityEntries

The maximum number of activity entries to retrieve per application from Log Analytics. This limits the result set size to prevent excessive data retrieval and memory consumption. Valid range: 1-500000 entries (Log Analytics limit). Default: 100000 Recommended values:

30000: Conservative, faster queries
100000: Balanced (default)

Type: Int32
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: 100000
Accept pipeline input: False
Accept wildcard characters: False

-retainRawUri

Optional switch. Returns cleaned but non-tokenized URIs when specified. Default behavior tokenizes URIs by replacing IDs with {id} placeholders. NOTE if you utilize this switch you will not be able to run a permission analysis on the endpoints

Type: SwitchParameter
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

-ProgressAction

Type: ActionPreference
Parameter Sets: (All)
Aliases: proga

Required: False
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

OUTPUTS

System.Object

Returns the input application objects enriched with an "Activity" property containing the activity data.

Additional Properties Added:

- Activity: Array of activity records with Method, RequestUri, and TokenizedRequestUri

- ErrorMessage: (Only if error occurred) Descriptive error message for troubleshooting

Applications with no activity will have an empty Activity array. Applications with errors

will have both an empty Activity array and an ErrorMessage property explaining the failure.

NOTES

Prerequisites:

PowerShell 7.0 or later (required for ForEach-Object -Parallel)
PSFramework module (for logging only)
EntraAuth module with active Log Analytics connection
Azure Log Analytics workspace with MicrosoftGraphActivityLogs table enabled
Must be authenticated via Connect-EntraService before calling this function