SET QUOTED_IDENTIFIER OFF
GO

   CREATE VIEW HARAUDITLOGVIEW  
   (     ParentAuditEventObjId, AuditEventObjId, ActionObjId,
        SuccessFailure, ActionName, EventTime,      UsrObjId,
        UserName,      ClientHostName, ClientProcessId,
        ServerHostName, ServerProcessId,      ResourceTypeObjId,
        ResourceTypeName, ResourceObjId, ResourceName,
             EventDescription,      ER1ResourceTypeObjId,
        ER1ResourceTypeName, ER1ResourceObjId, ER1ResourceName,
            ER2ResourceTypeObjId, ER2ResourceTypeName,
        ER2ResourceObjId, ER2ResourceName,      ER3ResourceTypeObjId,
        ER3ResourceTypeName, ER3ResourceObjId, ER3ResourceName,
            ER4ResourceTypeObjId, ER4ResourceTypeName,
        ER4ResourceObjId, ER4ResourceName  )  AS
   SELECT     AE.ParentAuditEventObjId, AE.AuditEventObjId,
        AE.ActionObjId, AE.SuccessFailure, AC.ActionName,
        AE.EventTime,     AE.UsrObjId, AE.UserName,     AE.ClientHostname,
        AE.ClientProcessId, AE.ServerHostname, AE.ServerProcessId,
            AE.ResourceTypeObjId, RT.ResourceTypeName,
        AE.ResourceObjId, AE.ResourceName,     ED.EventDescription,
            ER1.ResourceTypeObjId ER1ResourceTypeObjId,
        RT1.ResourceTypeName ER1ResourceTypeName,     ER1.ResourceObjId ER1ResourceObjId,
        ER1.ResourceName ER1ResourceName,     ER2.ResourceTypeObjId ER2ResourceTypeObjId,
        RT2.ResourceTypeName ER2ResourceTypeName,     ER2.ResourceObjId ER2ResourceObjId,
        ER2.ResourceName ER2ResourceName,     ER3.ResourceTypeObjId ER3ResourceTypeObjId,
        RT3.ResourceTypeName ER3ResourceTypeName,     ER3.ResourceObjId ER3ResourceObjId,
        ER3.ResourceName ER3ResourceName,     ER4.ResourceTypeObjId ER4ResourceTypeObjId,
        RT4.ResourceTypeName ER4ResourceTypeName,     ER4.ResourceObjId ER4ResourceObjId,
        ER4.ResourceName ER4ResourceName   
   FROM     HARAUDITEVENT AE      INNER JOIN     HARACTION AC
       ON
   ( AE.ActionObjId = AC.ActionObjId )      INNER JOIN     HARRESOURCETYPE RT
       ON
   ( AE.ResourceTypeObjId = RT.ResourceTypeObjId )      LEFT OUTER JOIN     HARAUDITEVENTDESCRIPTION ED
       ON
   ( AE.AuditEventObjId = ED.AuditEventObjId )      LEFT OUTER JOIN     HARAUDITEVENTRESOURCEL1 ER1
       ON
   ( AE.AuditEventObjId = ER1.AuditEventObjId )      LEFT OUTER JOIN    HARAUDITEVENTRESOURCEL2 ER2
       ON
   ( AE.AuditEventObjId = ER2.AuditEventObjId )      LEFT OUTER JOIN    HARAUDITEVENTRESOURCEL3 ER3
       ON
   ( AE.AuditEventObjId = ER3.AuditEventObjId )      LEFT OUTER JOIN    HARAUDITEVENTRESOURCEL4 ER4
       ON
   ( AE.AuditEventObjId = ER4.AuditEventObjId )      LEFT OUTER JOIN    HARRESOURCETYPE RT1
       ON
   ( ER1.ResourceTypeObjId = RT1.ResourceTypeObjId )      LEFT OUTER JOIN    HARRESOURCETYPE RT2
       ON
   ( ER2.ResourceTypeObjId = RT2.ResourceTypeObjId )      LEFT OUTER JOIN    HARRESOURCETYPE RT3
       ON
   ( ER3.ResourceTypeObjId = RT3.ResourceTypeObjId )      LEFT OUTER JOIN    HARRESOURCETYPE RT4
       ON
   ( ER4.ResourceTypeObjId = RT4.ResourceTypeObjId )  

GO