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
