Unfortunatley I don't have control over the sysaudits partitioning. Also, the use of the view is to restrict the data set I need to extract via the BCP which won't work with ad-hoc queries.