times when windows computers were turned on or woken up (last 1 day)

[ssahin]

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Username,
  tblUptime.EventType,
  tblUptime.EventTime,
  tblAssets.IPAddress,
  tblAssets.Firstseen,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblUptime On tblUptime.AssetID = tblAssets.AssetID
  Inner Join tblDomainroles On tblDomainroles.Domainrole =
      tblComputersystem.Domainrole
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where ((tblUptime.EventType = 1 And tblUptime.EventTime >= DateAdd(day, -1,
      GetDate())) Or (tblUptime.EventType = 4 And tblUptime.EventTime >=
      DateAdd(day, -1, GetDate())))
Order By tblUptime.EventTime Desc

[ssahin]

Hello, you can see the opening times of your computers with the report using the query above.