Query "Log On As" on Services

[vISPer]

Hello,


I was wondering if anyone can help me with this: I'm trying to create a report that shows a list of computers with services that are set to Log On As "BACKUPADMIN" account.

We noticed that our backup program is not configured properly on some of the domain computers and instead of the "Local System Account" it is set to start as the mentioned user above. So I need a list of the computers that have any services running under "BACKUPADMIN".

Can Lansweeper do that? Any help would be greatly appreciated.


Thank,
V.

[vISPer]

Thank you so much. This worked perfectly. Lansweeper is number one and the support in this forum is top notch.

V.

[Hemoco · Accepted solution]

Please try:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblServicesUni.Caption,
tblServicesUni.Name,
tblServicesUni.Pathname,
tblServicesUni.Startname,
tblServiceState.State,
tblServices.Desktopinteract
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblServices On tblAssets.AssetID = tblServices.AssetID
Inner Join tblServiceStartMode On tblServiceStartMode.StartID =
tblServices.StartID
Inner Join tblServiceState On tblServiceState.StateID = tblServices.StateID
Inner Join tblServicesUni On tblServicesUni.ServiceuniqueID =
tblServices.ServiceuniqueID
Where tblServicesUni.Startname Like '%BACKUPADMIN%' And tblAssetCustom.State = 1