Last boot time

[gladen]

Hi,
Is there a way to get Last boot time on a Windows computer? What i want to do is a report that list computers that havn't got rebooted in X days.

There is a field named Last boot time in systeminfo, do lansweeper collect that info?

[ghelpdesk]

One option is to set a file scan entry for 'c:\pagefile.sys' . You can then make a report to list all computers by the fileversions LastModified date. Below is a report we are using to show workstations with uptime > 7 days.

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblFileVersions.FilePathfull, tblFileVersions.LastModified From tblComputers Inner Join tblFileVersions On tblComputers.Computername = tblFileVersions.Computername Where tblFileVersions.FilePathfull Like '%pagefile.sys' And tblFileVersions.LastModified < GetDate() - 7 Order By tblFileVersions.LastModified

[dteague]

ghelpdesk wrote:
One option is to set a file scan entry for 'c:\pagefile.sys' . You can then make a report to list all computers by the fileversions LastModified date. Below is a report we are using to show workstations with uptime > 7 days.

Select Top 1000000 tblComputers.Computername,  tblComputers.ComputerUnique,   tblFileVersions.FilePathfull, tblFileVersions.LastModified From tblComputers Inner Join   tblFileVersions On tblComputers.Computername =  tblFileVersions.Computername Where tblFileVersions.FilePathfull Like '%pagefile.sys' And   tblFileVersions.LastModified < GetDate() - 7 Order By tblFileVersions.LastModified

Thanks for this. I made a couple of mods (I only want to show workstations that didn't reboot over the weekend).