Autorun

[Josip]

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%'

[Josip]

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]

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