Uptime calendar

dit document beschrijft de werking van Uptime calendar

• Windows only: it's built using WMI data (Win32_NtLog filtered for specific events)
• if no data is in LS:
  • ask for report:

    Select Top 1000000 tblAssets.AssetID,
    
      tblAssets.AssetName,
    
      tblAssets.IPAddress,
    
      tblAssets.Lastseen,
    
      tblAssets.Lasttried,
    
      tblUptime.EventTime,
    
      tblUptime.EventType,
    
      Case tblUptime.EventType When 1 Then 'power on' When 2 Then 'power off'
    
        When 3 Then 'Start sleep' When 4 Then 'End sleep'
    
        When 5 Then 'Unexpected shutdown' End As Event
    
    From tblAssets
    
      Inner Join tblUptime On tblAssets.AssetID = tblUptime.AssetId
    
    Where tblAssets.AssetID In (Select Distinct Top 1000000 tblUptime.AssetId
    
      From tblUptime
    
      Where tblUptime.EventTime > GetDate() - 30) And tblAssets.AssetName =
    
      'Test'
    
    Order By tblUptime.EventTime Desc

  • check is last scan was successfull
  • check if eventviewer contains relevant data using TurnedOntTimesView

LS website