For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980
selectU.Name0 as 'Bruger',
-- U.displayName0 as 'Bruger',
MU.FullName as 'Brugernavn',
ou.ou as OU,round(sum(MUS.UsageTime)/60.0,2) as 'Forbrug (min)'
fromdbo.v_R_System Rjoin dbo.v_MonthlyUsageSummary MUS on R.ResourceID = MUS.ResourceIDjoin dbo.v_MeteredFiles MF on MUS.FileID = MF.MeteredFileIDjoin dbo.v_MeteredUser MU on MUS.MeteredUserID = MU.MeteredUserIDjoin dbo.v_R_User U on U.Unique_User_Name0 = MU.FullNameleft join (select OU.ResourceID, replace(max(ou.User_OU_Name0),'Gartek.LOCAL/Ottawa/','') as OU from v_RA_User_UserOUName OU group by OU.ResourceID) as OU on OU.ResourceID = U.ResourceID
whereMF.ProductName = @RuleNameGroup byU.Name0,MU.FullName,ou.ouorder byU.Name0