Advertisement
Guest User

Untitled

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