LinuxUpdateDeploymentAdvisory view
The Reporting3.LinuxUpdateDeploymentAdvisory view describes the deployments of advisories.
| 
                                                         Column Name  | 
                                                    
                                                         Data Type  | 
                                                    
                                                         Nullable  | 
                                                    
                                                         Description  | 
                                                
|---|---|---|---|
| 
                                                         Id  | 
                                                    
                                                         bigint  | 
                                                    
                                                         
  | 
                                                    
                                                         This is the unique identifier.  | 
                                                
| 
                                                         DeploymentId  | 
                                                    
                                                         int  | 
                                                    
                                                         
  | 
                                                    
                                                         Deployment ID. See LinuxUpdateDeployment view.  | 
                                                
| 
                                                         LinuxAdvisoryId  | 
                                                    
                                                         int  | 
                                                    
                                                         
  | 
                                                    
                                                         The advisory ID. See LinuxAdvisory view.  | 
                                                
| 
                                                         DetectedAdvisoryId  | 
                                                    
                                                         bigint  | 
                                                    
                                                         X  | 
                                                    
                                                         The id of the detected update advisory ID. See LinuxDetectedUpdateAdvisory view.  | 
                                                
| 
                                                         RemediationState  | 
                                                    
                                                         tinyint  | 
                                                    
                                                         
  | 
                                                    
                                                         The remediation state of the advisory: 0 – Success 1 – Failed 2 – Pending Reboot  | 
                                                
| 
                                                         ExitCode  | 
                                                    
                                                         int  | 
                                                    
                                                         X  | 
                                                    
                                                         Exit code. Success is null or 0.  | 
                                                
| 
                                                         ErrorNote  | 
                                                    
                                                         nvarchar(max)  | 
                                                    
                                                         X  | 
                                                    
                                                         Detailed error message.  | 
                                                
| 
                                                         PolicyRequested  | 
                                                    
                                                         bit  | 
                                                    
                                                         X  | 
                                                    
                                                         If this advisory was specified in the patch group.  |