reporting services - How to find only failed user details in SSRS 2008 R2? -

i want find failed user details, below query giving duplicate records. not able find proper solution.

to find failed job details i'm using below query:

select * executionlog e join catalog c on e.reportid = c.itemid c.name '%reportname%' , timestart>= '2013-04-15 09:00:00.000'  , status <> 'rssuccess' 

however, above query giving duplicate values particular report.

how can unique details?

note: cannot apply distinct or group by because table contains columns of ntext , image data types

if want "failed user details" don't select ntext or image columns @ all. way can distinct normally:

select  distinct       --parameters,       --content,       --property,       --parameter,       instancename, reportid, username, requesttype, format,  timestart, timeend,        timedataretrieval, timeprocessing, timerendering, source, status, bytecount,        [rowcount], itemid, path, name, parentid, type,  intermediate, snapshotdataid,        linksourceid,  description, hidden, createdbyid, creationdate, modifiedbyid,        modifieddate, mimetype, snapshotlimit, policyid, policyroot, executionflag,        executiontime  executionlog e join  catalog c on e.reportid = c.itemid c.name '%reportname%'       , timestart>= '2013-04-15 09:00:00.000'        , status <> 'rssuccess' 

you can trim many more columns. note doing select * bad practice many cases anyway.

if you're interested in corresponding ntext and/or image values can join catalog against above subquery again.