→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎09-17-2015 11:00 PM
Solved! Go to Solution.
‎09-28-2015 11:21 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.Image As icon,
tblServicesUni.Caption,
tblServicesUni.Name,
tblServiceState.State,
tblServiceStartMode.StartMode
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblServicesUni.Name Like 'remoteregistry %' Or
tblServicesUni.Name Like 'wuaserv %') And tblAssetCustom.State = 1 And
tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName,
tblServicesUni.Caption
‎09-28-2015 11:21 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.Image As icon,
tblServicesUni.Caption,
tblServicesUni.Name,
tblServiceState.State,
tblServiceStartMode.StartMode
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where (tblServicesUni.Name Like 'remoteregistry %' Or
tblServicesUni.Name Like 'wuaserv %') And tblAssetCustom.State = 1 And
tblComputersystem.Domainrole > 1
Order By tblAssets.AssetName,
tblServicesUni.Caption
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now