cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
vISPer
Engaged Sweeper
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

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

V.
Hemoco
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now