SMS data and dates

I am looking to see what version of a program is installed across our network.  How can I select only the most recent data in SMS?  
My query:
SELECT
sys.name0 [Redtag],
sf.filename [File],
sf.fileversion [Vsn],
R.user_Name0 as LastUser,
r.creation_date0 as [Date]
FROM dbo.SoftwareFile AS sf
INNER JOIN dbo.SoftwareInventory AS si ON sf.FileId = si.FileId
INNER JOIN dbo.v_GS_System AS SYS on sys.resourceid = si.clientid
INNER JOIN dbo.v_R_System AS R on R.resourceid = si.clientid
where sf.filename = 'HSSTIMESTUDY.EXE'
order by sys.name0, r.creation_date0

I get this:
Redtag                       File                        Vsn                  LastUser      Date
ITSD-VM2-318648      HssTimeStudy.exe      1.02.0005      T0189      2010-02-20 12:11:10.000
ITSD-VM2-318648      HssTimeStudy.exe      1.02.0006      T0189      2010-03-05 14:08:25.000

I only want a single row returned for a given RedTag.  In the example I want the 2nd line since that appears to be later information.