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
