Report "Services: Automatic services which are stopped on servers"

[Alulux]

Hi again,
In the above mentioned report, is it possible to exclude some non important services which are usally not started at all (e.g. Microsoft .NET Framework NGEN v.4.0.....) ?

[Hemoco]

Our apologies, you need to use the format below instead.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblServicesUni.Caption,
tblServices.Lastchanged,
tsysOS.Image As icon
From tblServices
Inner Join tblAssets On tblServices.AssetID = tblAssets.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblServices.StartID = 3 And
tblServices.StateID = 1 And tblAssetCustom.State = 1 And
tblServicesUni.Name <> 'YourService1' and tblServicesUni.Name <> 'YourService2' and tblServicesUni.Name <> 'YourService3'
Order By tblAssets.AssetName

[Alulux]

The first part works (with one service), but when i add additonal services, they are simply being cut off when i click "save & run" amd "edit" again

tblServicesUni.Name <> 'clr_optimization_v4.0.30319_64' and <> ´clr_optimization_v4.0.30319_32´

[Alulux]

Thanks a lot, I will try that today!

[Hemoco]

Do the following:
- In the Dashboard\Reports\All Reports section of the web console, hit the edit button next to the report.
- Replace the report's SQL code with the one below. Replace YourService1 with the name of the service you want to exclude.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblServicesUni.Caption,
tblServices.Lastchanged,
tsysOS.Image As icon
From tblServices
Inner Join tblAssets On tblServices.AssetID = tblAssets.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblServices.StartID = 3 And
tblServices.StateID = 1 And tblAssetCustom.State = 1 And
tblServicesUni.Name <> 'YourService1'
Order By tblAssets.AssetName

- You can add additional exclusions as shown below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tblAssets.Description,
tblServicesUni.Caption,
tblServices.Lastchanged,
tsysOS.Image As icon
From tblServices
Inner Join tblAssets On tblServices.AssetID = tblAssets.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblServicesUni On tblServices.ServiceuniqueID =
tblServicesUni.ServiceuniqueID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.Domainrole > 1 And tblServices.StartID = 3 And
tblServices.StateID = 1 And tblAssetCustom.State = 1 And
tblServicesUni.Name <> 'YourService1' and <> 'YourService2' and <> 'YourService3'
Order By tblAssets.AssetName

- Hit the Save & Run Report button.