I am trying to write a LS Report that's supposed to check if software is set on autorun or not.
Ran into a wall here and am not sure if this works or not.
Can someone just check and see if this is doing what it's supposed to do?
Thx
Select Top 1000000 tblAssets.AssetID As AssetID1,
tblAssets.AssetID,
tblAssets.Username,
tblAssets.AssetName,
tblAssets.AssetUnique As AssetUnique1,
tblSoftwareUni.softwareName As software,
Case
When tblAssets.AssetID In (Select tblAutorun.AssetID
From tblAutorun Inner Join tblAutorunUni On tblAutorunUni.AutorunUNI =
tblAutorun.AutorunUNI
Where tblAutorunUni.Caption Like 'Teamviewer%') Then 'yes'
Else 'no'
End As [autorun MySoftware]
From tblAssets
Inner Join tblSoftware On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Where tblSoftwareUni.softwareName Like 'Teamviewer%'