Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Azure File Share Audit Script
#AuditFileshare
Param(
[object]$WebhookData
)
#defining global Variables
#items after $script: are the variable names
#Items after $RequesterHeader are the Names for theMS Flow items
$script:Listname = "AuditFileShare"
$script:SiteUrl = "https://vidlerit.sharepoint.com/sites/automation"
$script:listItemId=$WebhookData.RequestHeader.ItemID
$script:ServerPath=$WebhookData.RequestHeader.ServerPath
$script:AuditShare=$WebhookData.RequestHeader.AuditShare
#Connect to site and update "Results" to In-Progress
Try
{
$date = get-date -Format MMMdd-HHmm
$SPOUser="vidler-o365"
$Creds=Get-AutomationPSCredential -Name $SPOUser
$credsAD = Get-AutomationPSCredential -Name "vidler-ad"
Connect-PnPOnline -Url $Global:SiteUrl -Credential $Creds
#update list
$updatedItem = Set-PnPListItem -List $Global:listname -Identity $Global:listItemId -Values @{"Status" = "Inprogress"}
#Start of Script
$strFileName = "c:\scripts\AuditFileShare.ps1"
#parameters about to be passed to remote script
write-output "ServerPath = $ServerPath AuditShare = $AuditShare DateItem $date listitemid = $listitemID listname = $listname"
$script = [scriptblock]::Create("$strFileName -ServerPath $ServerPath -AuditShare $AuditShare -OutPutFolder $date")
Invoke-Command -ComputerName rv16aad -script $script -Credential $CredsAD -Authentication CredSSP -ErrorVariable script:errortext
if ($errortext)
{
Write-Output "List item updating $($listItemId) Most likely invalid path due to following error $errortext"
$updatedItem= Set-PnPListItem -List $Global:listname -Identity $Global:listItemId -Values @{"Status" = "Error"; "ErrorMessage" = "$errortext Please Check the Path and try again"}
Exit
}
#File to Attach
$item = Get-PnPListItem -List $Global:listname -Id $Global:listitemID
$Uploadfile = "$Auditshare-$date"
$filepath = "C:\sharepointfiles\$UploadFile.zip"
$fileName = Split-Path $filePath -Leaf
$ctx = Get-PnPContext
$fileStream = New-Object IO.FileStream($filePath,[System.IO.FileMode]::Open)
$attachInfo = New-Object -TypeName Microsoft.SharePoint.Client.AttachmentCreationInformation
$attachInfo.FileName = $fileName
$attachInfo.ContentStream = $fileStream
$attFile = $item.attachmentFiles.add($attachInfo)
write-output "about to attach file"
$ctx.load($attFile)
Write-Output "List item updating $($listItemId)"
$updatedItem = Set-PnPListItem -List $Global:listname -Identity $Global:listItemId -Values @{"Status" = "Completed"}
}
Catch
{
Write-Output "Error Occured $($_.Exception.Message)"
Write-Output "List item updating Error Message and Status for ListItem# $($listItemId)"
$updatedItem= Set-PnPListItem -List $Global:listname -Identity $Global:listItemId -Values @{"Status" = "Error"; "ErrorMessage" = $_.Exception.Message}
}
Finally
{
Write-Output "Disconnecting"
Disconnect-PnPOnline
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.