Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID Left Join tsysOS On tsysOS.OScode = tblAssets.OScode TsysAssetTypes.AssetTypename As AssetType,Ĭoalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)Ĭonvert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 /Ĭonvert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) / 3600 %Ĭonvert(nvarchar(10),Ceiling(Floor(Convert(integer,tblAssets.Uptime) % 3600 /Ħ0))) + ' minutes' As UptimeSinceLastReboot The audit is sorted so that devices with the highest uptime are automatically shown at the top so you can easily identify the devices you should reboot.Īsset Uptime Since Last Reboot Query Select Top 1000000 tblAssets.AssetID, Not updating a workstation or server for a long period of time can result in serious security holes in your network's security. Once your network has been scanned, this audit provides an overview of all devices and their uptime since their last reboot.ĭevices, specifically workstations or servers rely on reboots to apply patches which also improve security. Lansweeper scans the uptime of all devices without the need of an agent or a CMD/PowerShell script.
0 kommentar(er)
