Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
WooYing
Engaged Sweeper

Hi All

I am trying to report a software report of new software that is installed on my systems.  I am not talking about upgrades for Chrome or Edge, or Adobe.  I am speaking of new installation ONLY, I know sometime it can bee deemed as a new software and if that is the case is it possible to do exclusion of software on the report for items like Chrome, Edge, or Adobe.  If so how do I go about producing that report.  Thank you 

2 REPLIES 2
WooYing
Engaged Sweeper

Thank you Hendrik_VE for the great solution.  But is there a way to report all recently installed software and do an exclusion from there, like Chrome, Edge and MS Office?  Thank you again for your good work.  

Hendrik_VE
Champion Sweeper III

I'm using this report to check if any new and unknown software has been installed on my estate:

Select Distinct Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblSoftwareUni.Added,
tblAssets.IPAddress,
tsysIPLocations.IPLocation
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Right Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tblSoftwareHist On tblSoftwareHist.softid = tblSoftwareUni.SoftID
Where tblSoftwareUni.Added > GetDate() - 7 And
SubString(tblSoftwareUni.softwareName, 1, 10) Not In (Select
SubString(tblSoftwareUni.softwareName, 1, 10) From tblSoftwareUni
Where tblSoftwareUni.Added < GetDate() - 7) And
tblSoftwareUni.SoftwarePublisher Is Not Null
Order By tblSoftwareUni.Added Desc

 

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now