Report to check 4 existing and running services

[Tobi]

Hi everybody.

I would like to have an report that shows me all computers with an bad GData Antivirus installation. We have many Windows XP and many Windows 7 computers.

An good GData Installation has 4 installed and running services.
An bad GData Installation has less than 4 services installed or not all 4 services are running.

The servicenames are exactly the same on Win 7 and Win XP:

AVKProxy
AVKWCtl
GDScan
AntiVirusKit Client

Is it possible to make an report for this ? I have no skills in doing this ...

It would be great if you could help me out.

BTW: Our Lansweeper Version is v5

Cheers
Tobi

[Tobi]

Hi Lansweeper Support.

This works great ! Exactly what i was looking for....

Thanks a lot for your help

Cherrs
Tobi

[Hemoco · Accepted solution]

Please use the report below for non-compliant machines. Replace Service Name 1-4.

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where (tblAssets.AssetID Not In (Select Top 1000000 tblServices.AssetID
From tblServices Inner Join tblServiceState On tblServiceState.StateID =
tblServices.StateID Inner Join tblServicesUni
On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID
Where tblServicesUni.Name = 'Service Name 1' And tblServiceState.State =
'running') And tsysAssetTypes.AssetTypename = 'windows') Or
(tblAssets.AssetID Not In (Select Top 1000000 tblServices.AssetID
From tblServices Inner Join tblServiceState On tblServiceState.StateID =
tblServices.StateID Inner Join tblServicesUni
On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID
Where tblServicesUni.Name = 'Service Name 2' And tblServiceState.State =
'running') And tsysAssetTypes.AssetTypename = 'windows') Or
(tblAssets.AssetID Not In (Select Top 1000000 tblServices.AssetID
From tblServices Inner Join tblServiceState On tblServiceState.StateID =
tblServices.StateID Inner Join tblServicesUni
On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID
Where tblServicesUni.Name = 'Service Name 3' And tblServiceState.State =
'running') And tsysAssetTypes.AssetTypename = 'windows') Or
(tblAssets.AssetID Not In (Select Top 1000000 tblServices.AssetID
From tblServices Inner Join tblServiceState On tblServiceState.StateID =
tblServices.StateID Inner Join tblServicesUni
On tblServicesUni.ServiceuniqueID = tblServices.ServiceuniqueID
Where tblServicesUni.Name = 'Service Name 4' And tblServiceState.State =
'running') And tsysAssetTypes.AssetTypename = 'windows')