SQL for Last_Logon_Timestamp0 and LastHWScan :

SQL for Last_Logon_Timestamp0 and LastHWScan :

select Distinct v_R_System.Netbios_Name0 as 'Device Name',
 v_R_User.Full_User_Name0 AS 'Employee Name',
  v_R_System.User_Name0 AS 'User ID',
  v_R_System.AD_Site_Name0,
  v_R_System.Active0,
  v_R_System.Client0,

   v_R_User.Mail0 AS 'Employee eMail',
    v_GS_OPERATING_SYSTEM.Caption0 AS 'Operating System',
v_GS_OPERATING_SYSTEM.InstallDate0 AS 'OSD Install Date',
  v_GS_SYSTEM_ENCLOSURE.Manufacturer0 AS 'Manufacturer',
   v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
   v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS 'Serial Number',
   v_r_system.Last_Logon_Timestamp0,LastHWScan

from v_R_System
Left Join v_R_User on v_R_User.User_Name0 = v_R_System.User_Name0
Left join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceId
Left join v_GS_SYSTEM_ENCLOSURE on v_GS_SYSTEM_ENCLOSURE.ResourceID = v_R_System.ResourceId
Left join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceId
Left join v_GS_PC_BIOS on v_GS_PC_BIOS.ResourceID = v_R_System.ResourceId
Left join vCollectionMembers on vCollectionMembers.MachineID = v_R_System.ResourceId
Left join v_GS_LOGICAL_DISK on v_R_System.ResourceID = v_GS_LOGICAL_DISK.ResourceID
LEFT JOIN v_GS_WORKSTATION_STATUS HWSCAN on v_R_System.ResourceID = HWSCAN.ResourceID