‎02-27-2012 02:12 PM
‎02-28-2012 06:00 PM
Select tblComputers.Computername, tblComputers.Domain, tblComputers.Computer,
tblComputers.Firstseen, tblComputers.Lastseen, tblComputers.Lasttriggered,
tblComputers.LastScheduled, tblComputers.LastActiveScan,
tblComputers.LastLsPush, tblComputers.Username, tblComputers.Userdomain,
Web40OSName.OSname, tblOperatingsystem.ServicePackMajorVersion,
tblSoftwareHist.softwareName, tblSoftwareHist.softwareVersion,
tblSoftwareHist.SoftwarePublisher, tblSoftwareHist.Installdate,
tblSoftwareHist.Lastchanged, tblSoftwareHist.Action
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblSoftwareHist On tblComputers.Computername = tblSoftwareHist.ComputerName
Where tblComputers.Computer = 'YourComputer' And tblSoftwareHist.softwareName Like
'%dropbox%'
Order By tblSoftwareHist.Lastchanged Desc
Select Distinct tblComputers.Computername, tblComputers.Domain,
tblComputers.Computer, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.Lasttriggered, tblComputers.LastScheduled,
tblComputers.LastActiveScan, tblComputers.LastLsPush, tblCPlogoninfo.Domain As
Domain1, tblCPlogoninfo.Username, tblCPlogoninfo.ADsite
From tblComputers Inner Join
tblCPlogoninfo On tblComputers.Computername = tblCPlogoninfo.Computername
Where tblComputers.Computer = 'YourComputer'
‎02-27-2012 06:15 PM
‎02-27-2012 03:39 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now