Find Computers Which Do Not Have System Restore Running
System Restore is a Windows feature that allows you to revert the computer, including system files, installed applications registry and system settings to that of a previous time. This is frequently used to recover systems from unexpected issues. To be able to recover systems it is important that the system restore service is running so that the computer or server automatically creates system restore points that can be rolled back to. This audit provides an overview of all machines which do not have the service running and will therefore not be creating restore points so you can start taking action right away before issues arise.
System Restore 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'srservice' And tblAssetCustom.State = 1 Order By tblAssets.AssetName