Need assistance with RM classification reports

Stacy_Butler

I need a live report that will pull the total size of documents that have RM classification assigned. I used the following query and its results:select d.name, to_char(sum(dv.datasize),'999,999,999,999') "Size"from DVersData dv, rimsnodeclassification rm, dtree dwhere rm.nodeid = dv.docid and rm.classid=d.dataidgroup by d.nameorder by d.namePD013.10 212,319,013,159 However, when we run the following query, we get completely different results.select to_char(sum(dv.datasize)/1024,'999,999,999,999') "Size K Bytes"from dversdata dv, providerdata pvwhere pv.providertype = 'OurCentera'and pv.providerid = dv.providerid386,839,556,000What is the correct way to pull the Size of the RM classified data [and include the classification name]?