To see full post see http://www.myitforum.com/forums/tm.aspx?high=&m=234899&mpage=1#234905
selectR.Netbios_Name0 as 'Computernavn',
-- U.displayName0 as 'Bruger',
Full_User_Name0,max(ou.User_OU_Name0),MU.FullName as 'Brugernavn',
MUS.LastUsage as 'Sidst brugt',
MUS.UsageCount + MUS.TSUsageCount as 'Antal brug',
round(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.FullNamejoin dbo.v_RA_User_UserOUName ou on ou.ResourceID = u.ResourceIDwhereMF.ProductName = @RuleNamegroup byR.Netbios_Name0,-- U.displayName0,
Full_User_Name0,MU.FullName,MUS.LastUsage,MUS.UsageCount + MUS.TSUsageCount ,round(MUS.UsageTime/60.0,2)order byR.Netbios_Name0