Symantec av software to a query

Adding symantec av software to a query, see here for full details.http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/7c6b65be-cdfc-414f-a78d-f198f5e6a323

SELECT 

  Sys.Netbios_Name0 as 'Computer Name', 

  Sys.User_Domain0 as 'User Domain', 

  Sys.User_Name0 as 'UserName', 

  Comp.Manufacturer0 as 'Make', 

  Comp.Model0 as 'Model', 

  Process.Name0 as 'Processor', 

  BIOS.SerialNumber0 as 'Serial#', 

  Memory.TotalPhysicalMemory0/1000 as 'RAM (MB)', 

  Sys.Operating_System_Name_and0 as 'Operating System', 

  OS.CSDVersion0 as 'Service Pack', 

  Status.LastHWScan as 'Last H/W Scan', 

  OS.InstallDate0 as 'Install_Date', 

  OS.LastBootUpTime0 as 'Last Bootup', 

  Sys.AD_SITE_NAME0 as 'Location',

  SSAS.SMS_Assigned_Sites0,

  ie.FileVersion0 

 

FROM v_R_System Sys

  LEFT JOIN v_GS_COMPUTER_SYSTEM Comp on Sys.ResourceID = Comp.ResourceID

  LEFT JOIN v_GS_PC_BIOS BIOS on Sys.ResourceID = BIOS.ResourceID

  LEFT JOIN v_GS_X86_PC_MEMORY Memory on Sys.ResourceID = Memory.ResourceID

  LEFT JOIN v_GS_PROCESSOR Process on Sys.ResourceID = Process.ResourceID

  LEFT JOIN v_GS_WORKSTATION_STATUS Status on Sys.ResourceID = Status.ResourceID

  LEFT JOIN v_GS_OPERATING_SYSTEM OS on Sys.ResourceID = OS.ResourceID

  INNER JOIN dbo.v_RA_System_SMSAssignedSites SSAS ON SYS.ResourceID = SSAS.ResourceID

  LEFT JOIN dbo.v_GS_INSTALLED_EXECUTABLE IE on SYS.ResourceID = IE.ResourceID and IE.ExecutableName0 = 'PWConsole.exe'  


WHERE 

  OS.LastBootUpTime0 <> ' ' 

--  and (Sys.Name0 like '0___0-TC-%' or Sys.Name0 like '63___-TC-%')

ORDER BY 

  Sys.Netbios_Name0