SMS_AppDeploymentAssetDetails missing AppStatusType 5(error) but it shown in the gui console?

$AppName = "Avaya Workplace 3.40.1.10 V1"

$Collection = "Avaya Workplace 3.40.1.10 V1-install (device)"

$CimSession = New-CimSession `

    -ComputerName $ProviderMachineName `

    -Credential $Credl

$a = Get-CimInstance `

       -Namespace 'root\SMS\site_PRI' `

        -CimSession $CimSession `

        -Query "Select * FROM SMS_AppDeploymentAssetDetails WHERE CollectionName = '$Collection'"

$a | Select-Object AppStatusType -Unique

AppStatusType
 2
 1  
```I dont see the unknown???  want to query so i get the device also above give me but only status 1,2    
  
1 = Success  2 = InProgress  3 = RequirementsNotMet  4 = Unknown  5 = Error  

code based of [https://gist.github.com/Graham-Beer/4c66ceb5340f85a2acf664be466d8b63](https://gist.github.com/Graham-Beer/4c66ceb5340f85a2acf664be466d8b63)

This is from sccm

![Microsoft.ConfigurationManagement_2GqmFvPF6Z](/api/attachments/f263a460-52e9-4837-af4c-83c96e7cc560?platform=QnA)


```sql
I dont see the unknown???  want to query so i get the device also above give me but only status 1,2      

1 = Success  2 = InProgress  3 = RequirementsNotMet  4 = Unknown  5 = Error  

code based of https://gist.github.com/Graham-Beer/4c66ceb5340f85a2acf664be466d8b63

From sccm console i see this