Find Computers Which Do Not Have Security Center Running
Security Center is a built-in Windows feature that checks for issues and alerts users regarding antivirus status, windows updates and more. Disabling the service will stop it from notifying users, which can or cannot be desired. With this audit, you can easily list all the machines on which the security center service is not running and users will not receive these types of notifications. This way you can start taking action quickly.
Security Center Service Not Running Query
Select Top 1000000 tblAssets.AssetID, tblAssets.AssetUnique, tblAssets.Domain, tsysOS.OSname, tblAssets.Description, tblServices.Lastchanged, tsysOS.Image As icon From tblAssets Inner Join tblServices On tblAssets.AssetID = tblServices.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 tblServices.Started = 0 And tblServicesUni.Name = N'wscsvc' And tblAssetCustom.State = 1 Order By tblAssets.AssetName