Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PS C:\WINDOWS\system32> $ActivityLogsPath = "\\FTPRoot\PowerBI\ActivityLogs.csv"
- >> $RetrieveDate = Get-Date
- >> $ActivityLogs = Get-PowerBIActivityEvent -StartDateTime '2020-01-15T00:00:00.000' -EndDateTime '2020-01-15T23:59:59.999' | ConvertFrom-Json
- >> $ActivityLogSchema = $ActivityLogs | Select-Object Id,RecordType,CreationTime,Operation,UserId,UserType,UserKey,Workload,ClientIP,UserAgent,Activity,ItemName,WorkspaceName,WorkspaceAccessList,
- >> WorkspaceId,DatasetName,DatasetId,ReportName,CapacityId,CapacityName,CapacityState,CapacityUsers,AppName,ObjectId,ReportId,IsSuccess,ReportType,RequestId,
- >> ActivityId,AppReportId,OrganizationId,DistributionMethod,ConsumptionMethod,DataConnectivityMode,OrgAppPermission,RefreshType,FolderDisplayName,FolderObjectId,
- >> TakingOverOwner,StorageAccountName,GatewayName,GatewayType,GatewayId,DatasourceName,DatasourceId,IsUpdateAppActivity,DashboardId,ArtifactId,ArtifactName,
- >> DataflowId,DataflowName,DataflowType,DataflowRefreshScheduleType,DataflowAccessTokenRequestParameters,DataflowAllowNativeQueries,CustomVisualAccessTokenResourceId,
- >> CustomVisualAccessTokenSiteUri,ExportEventStartDateTimeParameter,ExportEventEndDateTimeParameter,ImportId,ImportSource,ImportType,ImportDisplayName,TemplatePackageName,
- >> TemplateAppVersion,TemplateAppObjectId,TemplateAppFolderObjectId,TemplateAppOwnerTenantObjectId,AuditedArtifactInformation,ExportedArtifactInfo,
- >> @{Name="RetrieveDate";Expression={$RetrieveDate}}
- >>
- >> $ActivityLogSchema | Export-Csv -path $ActivityLogsPath -append -NoTypeInformation
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement