Thanks ZMAN, I have run the query you had posted but it only comes back with around 300 od lines of info.. I'd like to find out how many distributions have been carried out since Jan 1st this year until now. Can that be done so I just get total of distributions? i.e. total number of distributions and how many per taks? Is that possible?
Sorry I have to ask if you changed the start and end dates?
SET @start = '2010-1-01 12:29:00' SET @finish = '2010-10-08 12:29:00'
What version of LANDsk are you using, and are you using SQL Server?