AzureResourceInventory

3.6.0-Beta

Modules/Private/3.ReportingFunctions/Start-ARIExcelJob.ps1

                                function Start-ARIExcelJob {

    Param($ReportCache, $File, $DataActive, $TableStyle, $Debug)

    if ($Debug.IsPresent)

        {

            $DebugPreference = 'Continue'

            $ErrorActionPreference = 'Continue'

        }

    else

        {

            $ErrorActionPreference = "silentlycontinue"

        }

    $ParentPath = (get-item $PSScriptRoot).parent.parent

    $InventoryModulesPath = Join-Path $ParentPath 'Public' 'InventoryModules'

    $ModuleFolders = Get-ChildItem -Path $InventoryModulesPath -Directory

    Write-Progress -activity $DataActive -Status "Processing Inventory" -PercentComplete 50

    $ModulesCount = [string](Get-ChildItem -Path $InventoryModulesPath -Recurse -Filter "*.ps1").count

    Write-Output 'Starting to Build Excel Report.'

    Write-Output ('Supported Resource Types: ' + $ModulesCount)

    $Lops = $ModulesCount

    $ReportCounter = 0

    Foreach ($ModuleFolder in $ModuleFolders)

        {

            $ModulePath = Join-Path $ModuleFolder.FullName '*.ps1'

            $ModuleFiles = Get-ChildItem -Path $ModulePath

            $CacheFiles = Get-ChildItem -Path $ReportCache -Recurse

            $JSONFileName = $ModuleFolder.Name

            $CacheFile = $CacheFiles | Where-Object { $_.Name -like "*$JSONFileName*" }

            if ($CacheFile)

                {

                    $CacheFileContent = New-Object System.IO.StreamReader($CacheFile.FullName)

                    $CacheData = $CacheFileContent.ReadToEnd()

                    $CacheFileContent.Dispose()

                    $CacheData = $CacheData | ConvertFrom-Json

                }

            Foreach ($Module in $ModuleFiles)

                {

                    $c = (($ReportCounter / $Lops) * 100)

                    $c = [math]::Round($c)

                    Write-Progress -Id 1 -activity "Building Report" -Status "$c% Complete." -PercentComplete $c

                    $ModuleFileContent = New-Object System.IO.StreamReader($Module.FullName)

                    $ModuleData = $ModuleFileContent.ReadToEnd()

                    $ModuleFileContent.Dispose()

                    $ModName = $Module.Name.replace(".ps1","")

                    $SmaResources = $CacheData.$ModName

                    $ModuleResourceCount = $SmaResources.count

                    if ($ModuleResourceCount -gt 0)

                    {

                        Start-Sleep -Milliseconds 25

                        Write-Debug ((get-date -Format 'yyyy-MM-dd_HH_mm_ss')+' - '+"Running Module: '$ModName'. Lines in Excel: $ModuleResourceCount")

                        $ExcelRun = ([PowerShell]::Create()).AddScript($ModuleData).AddArgument($PSScriptRoot).AddArgument($null).AddArgument($InTag).AddArgument($null).AddArgument($null).AddArgument('Reporting').AddArgument($file).AddArgument($SmaResources).AddArgument($TableStyle).AddArgument($null)

                        $ExcelJob = $ExcelRun.BeginInvoke()

                        while ($ExcelJob.IsCompleted -contains $false) { Start-Sleep -Milliseconds 200 }

                        $ExcelRun.EndInvoke($ExcelJob)

                        $ExcelRun.Dispose()

                        Remove-Variable -Name ExcelRun

                        Remove-Variable -Name ExcelJob

                        Remove-Variable -Name SmaResources

                        Clear-ARIMemory

                    }

                    $ReportCounter ++

                }

        }

    }