ITMS Administrator Group

Expand all | Collapse all

Date and time of BIOS

Jump to Best Answer
  • 1.  Date and time of BIOS

    Posted 04-16-2018 12:18 PM


    I need to know if I can modify the BIOS date and time by script or task, how can I do it? or how to generate a sql report where I throw date, time, OS, System Type, BIOS Version, IP
    Thanks and regards.

  • 2.  RE: Date and time of BIOS
    Best Answer

    Posted 04-16-2018 01:14 PM

    Here's a SQL report I put together to get most of that info for you, as a starting point.  Just missing the BIOS date and time.  The BIOS Date in this report refers to the date of the BIOS version (BIOS release date?) - not the actual system date.

    DECLARE @v1_TrusteeScope nvarchar(max)
       SET @v1_TrusteeScope = N'%TrusteeScope%'
    SELECT vc.[Name],vc.[User],vc.[OS Name],vc.[IP Address],cs.[Manufacturer],cs.[Model],cs.[Total Physical Memory (Bytes)], [BIOS].[Version], CONVERT (VARCHAR(40),b.[Release Date],120) [BIOS Date]
    FROM vComputer vc
    JOIN vHWComputerSystem cs ON vc.[Guid]=cs._ResourceGuid
    JOIN dbo.vSWBIOSElement b ON b.[_ResourceGuid] = vc.[Guid]
    JOIN [Inv_SW_BIOS_Element] AS [BIOS] ON BIOS.[_ResourceGuid] = vc.[Guid]

    Hope that helps.