Get the reason of shutdown/reboot

[ProfileNL]

Hi,

Is it possible to create a report with the reason of the shutdown/reboot? I did some research about this and I found the table tblUptime. But how can I relate tblUptime and tblNtLog with each other?
So far, I have this:

Select Top (1000000) tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblNtlog On tblAssets.AssetID = tblNtlog.AssetID

Any help is appreciated