Discover computers which have automatic restart enabled and will restart when Windows encounters a critical error. System failures can be difficult to troubleshoot. One effective way is analyzing exactly which error Windows is displaying after a critical system failure. However, this message will only be displayed for a short amount of time after which the computer will reboot itself. This automatic restart is on by default on Windows but can be turned off. The report below will provide a list of computers for which this option is enabled.
Automatic Restart Enabled Query
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tblAssets.Description,
tblComputersystem.Lastchanged,
tsysOS.Image As icon
From tblAssets
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblComputersystem.AutomaticResetBootOption = 1 And tblAssetCustom.State =
1
Order By tblAssets.AssetName
