SW installed for specific users account

[LinHD]

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

[SteveN63]

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]

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]

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