====== Uptime calendar======
[[lansweeper:lansweeper|{{ :lansweeper:icon.jpg?180|}}]]

===== context =====
dit document beschrijft de werking van Uptime calendar

===== inhoud =====
  * Windows only: it's built using WMI data (Win32_NtLog filtered for specific events)
  * if no data is in LS: 
    * ask for report: <code>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
</code>
    * check is last scan was successfull
    * check if eventviewer contains relevant data using [[https://www.nirsoft.net/utils/computer_turned_on_times.html|TurnedOntTimesView]]
  * 
===== meer info =====
[[https://www.lansweeper.com/feature/asset-uptime-calendar/|LS website]]

{{tag>lansweeper uptime}}