Newly installed software

[cpopoff]

Is there a easy way to tell if new software products or versions are found on the network so that I can easily add them to the tracking for compliance auditing? I have been working on adding the software found on the network into the tracking/compliance but I don't know how to find new software or versions as they come up that I would need to add to the tracking. Any ideas?

[cpopoff]

Thank you so much!

[Hemoco]

Please try the report below. It lists new software found in the last 14 days.

Select tblSoftwareHist.softwareName, tblSoftwareHist.softwareVersion,
tblSoftwareHist.SoftwarePublisher, tblSoftwareHist.Lastchanged
From tblSoftwareHist Inner Join
(Select tblSoftwareHist.softwareName, tblSoftwareHist.softwareVersion,
tblSoftwareHist.SoftwarePublisher, Count(tblSoftwareHist.Action)
As [Actions Count]
From tblSoftwareHist
Group By tblSoftwareHist.softwareName, tblSoftwareHist.softwareVersion,
tblSoftwareHist.SoftwarePublisher
Having Count(tblSoftwareHist.Action) = 1) NewSoftware On
NewSoftware.softwareName = tblSoftwareHist.softwareName And
NewSoftware.softwareVersion = tblSoftwareHist.softwareVersion And
NewSoftware.SoftwarePublisher = tblSoftwareHist.SoftwarePublisher
Where tblSoftwareHist.Action = 1 And tblSoftwareHist.Lastchanged > GetDate() - 14
Order By tblSoftwareHist.softwareName, tblSoftwareHist.softwareVersion

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.