cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
LinHD
Engaged Sweeper II
I am attempting to look for software installed by the user (the kind that installs in the user appdata folder).
When I look at a Windows asset I see that some software is identified as "installed only for a specific user account"
Is there a way to report all sw of this kind and for which users it is installed?
I have seen that the table tblSoftware could be the starting point, I can't find the link to the user
Thanks in advance for your help
Lin
3 REPLIES 3
SteveN63
Engaged Sweeper
I too have run the above script which exports all software installed. However, it doesn't indicate which software has been installed by the user, i.e. to \AppData. In my case I'm not bothered who's installed it, I just want to see what's out there and then review anything suspicious by looking at the individual last scan results.
LinHD
Engaged Sweeper II
Thank you, but the query gives me a list of the installed sw, which is already useful, but I need to know which user has installed the sw.
It may be impossible, since I don't find a way to relate SW and Users in the database

Kind regards
Andy_Sismey
Champion Sweeper III
Give this Query a go :

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
[User-Software].softwareName
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join (Select tblSoftware.CurrentUser,
tblSoftwareUni.softwareName,
tblSoftware.AssetID
From tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tblSoftware.CurrentUser = 'true') [User-Software] On
[User-Software].AssetID = tblAssets.AssetID
Where tblAssetCustom.State = 1