
    switch ($env:computername) {
        "ITDWINAUTOT1" {
            New-UDTypography -Text 'NPD'
            $ServerInstance = "itdintsql22p1.nd.gov\INTSQL22P1"
            $Database = "ITD-Systems-Automation"
            $Table = "Infra_WindowsServer_FileManagement_RemoveITDExpiredFiles_PRD"
        }
        "ITDWINAUTOP1" {
            New-UDTypography -Text 'PRD'
            $ServerInstance = "itdintsql22p1.nd.gov\INTSQL22P1"
            $Database = "ITD-Systems-Automation"
            $Table = "Infra_WindowsServer_FileManagement_RemoveITDExpiredFiles_PRD"
        }
    }

    $SqlQuery = "SELECT [PSUJobId],[DateTime],[ComputerName],[Status],[FullName] FROM [$Database].[dbo].[$Table]"
    $SqlRecords = Invoke-Sqlcmd -ServerInstance $ServerInstance -Database $Database -Query $SqlQuery -Credential $Secret:sql_itdpsu1 -Verbose