N number of Random Records per Unique Combination (Group/Key)

Are you meaning grouping the data by the 5 cols Client-Contractor-Distribution Center-Service Level-Alert Value-Status?

for grouping data have a look here:

In case of our understanding from above is correct we can also provide an effort reducing the effort for constructing the 5 col group keys. So let us know