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

Leave a Reply

Your email address will not be published. Required fields are marked *