cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Josip
Engaged Sweeper II
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%'
2 REPLIES 2
Josip
Engaged Sweeper II
Yes, but his one states "Show me all devices who have teamviewer on autorun"
and i need devices that do not have that option on yet.


thx for answering anyhow
brandon_jones
Champion Sweeper III
There are already some built in autorun reports in Lansweeper. This one was for Adobe Reader. I just replaced Adobe Reader with Teamviewer in the SQL code.
Try this:

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.OSname,
tblAutorunUni.Caption,
tblAutorun.Lastchanged,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Description,
tblAssetCustom.Location,
tsysIPLocations.IPLocation,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join tblAutorun On tblAssets.AssetID = tblAutorun.AssetID
Inner Join tblAutorunUni On tblAutorun.AutorunUNI = tblAutorunUni.AutorunUNI
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Join tsysIPLocations On tsysIPLocations.StartIP <= tblAssets.IPNumeric
And tsysIPLocations.EndIP >= tblAssets.IPNumeric
Where (tblAutorunUni.Caption Like N'teamviewer%') And tblAssetCustom.State = 1
Order By tblAssets.AssetName

New to Lansweeper?

Try Lansweeper For Free

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

Try Now