By filtering and sorting you can easily find specific software changes for troubleshooting or investigation purposes. This audit lists all Windows software changes including detailed information of the software changed, version, publisher, install date, change date and more. Lansweeper automatically scans detailed hardware, software, user and network information from Windows computers. The main SELECT pulls a list of all software for those assets that are in the sub-SELECT list.Discover All Software Changes in the Last 7 Daysĭiscover and list all Windows software changes within your network in the last 7 days. The INNER JOIN limits the main SELECT to only those assets in the sub-SELECT list. The sub-SELECT produces a list of assets that have the INSITE software installed.

TblSoftwareUni.softwareName Like N'INSITE%') AS HasInsite ON HasInsite.AssetID = tblAssets.AssetID INNER JOIN tblSoftwareUni ON tblSoftwareUni.SoftID = tblSoftware.softID Where tblSoftwareUni.softwareName Like N'INSITE%' And tblAssetCustom.State = 1 Left Outer Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID

Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Creating reports is generally out of my realm, so apologies for that in advance.

I lifted this code straight from these forums, but not sure how to get it to list the rest of the installed software. What I'm having trouble with is getting the list to show all of the software installed on those machines as well. I've got a report that lists all of the assets with a certain piece of software installed (in this instance, the software is INSITE).

Lansweeper software report