ETRUST 5computer Associate) software test

[Yarglo]

Here is a easy report for know witch computers (and servers ...) don't have Etrust (CA eTrustITM Agent) installed.

Regards.

Select tblComputers.Computername, tblComputers.Username, tblComputers.Lastseen,
  tblComputers.Firstseen, tblComputers.LastknownIP
From tblsoftware Inner Join
  tblComputers On tblComputers.Computername = tblsoftware.ComputerName
Group By tblsoftware.ComputerName, tblComputers.Computername,
  tblComputers.Username, tblComputers.Lastseen, tblComputers.Firstseen,
  tblComputers.LastknownIP
Having tblsoftware.ComputerName Not In (Select tblsoftware.ComputerName
  From tblsoftware Where tblsoftware.softwareName = 'CA eTrustITM Agent')