Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper
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?
Engaged Sweeper
Thank you so much!
Lansweeper Alumni
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,
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.