Update satus SQL script

hello

I have to create a script for a tool that get information directly from SQL database. The different section for this report is :

Name, OperatingSystem, SAVVersion, LastScanDateTime, LastScanName, UpToDate

With the following script, i can get all informaion execpt "UpToDate"

Could someone please help me to get this information from the DB. I think i must join several table to get this info but i don't know which ones.

the actuel script without the section "UpToDate"

select distinct Name, OperatingSystem =

 CASE

  When OperatingSystem = '9' then 'Windows 2003'

  When OperatingSystem = '34' then 'Windows 2008 R2'

  When OperatingSystem = '18' then 'Windows 2008'

  When OperatingSystem = '36' then 'Windows 2012'

  When OperatingSystem = '39' then 'Windows 2012 R2'

  When OperatingSystem = '41' then 'Windows 2016'

end,

SAVVersion,DomainName, convert(varchar,LastScanDateTime,103) LastScanDateTime, LastScanName

from

  [dbo].[Computers] c,[Sophos Reporting Interface].[vPolicyComplianceData] vp

where

  vp.ComputerID = c.ID