Automated report regarding software inventory changes

[imorrison]

Hi,

I am trying to create a scheduled report, automatically emailed to me, regarding which workstations have had software installed or uninstalled for that day. Is that possible to do with Lansweeper? I am using the registered premium edition, version 4.2.0.52

Many thanks

[Hemoco]

Please use the following report:

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, Web40OSName.Compimage As icon,
Case tblSoftwareHist.Action When '1' Then '+' When '2' Then '-'
End As [+/-], tblSoftwareHist.softwareName As Software,
tblSoftwareHist.softwareVersion As Version, tblSoftwareHist.SoftwarePublisher
As Publisher, tblSoftwareHist.Installdate, tblSoftwareHist.Lastchanged
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblSoftwareHist On tblComputers.Computername = tblSoftwareHist.ComputerName
Where tblSoftwareHist.Lastchanged > GetDate() - 1
Order By tblComputers.Computer, tblSoftwareHist.Lastchanged Desc,
tblSoftwareHist.softwareName

Info on setting up report mailing can be found on page 91 of our online documentation.