Newly installed Software installation Only, not upgrades

[WooYing]

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 

[WooYing]

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]

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