ITMS Administrator Group

Hi,

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.

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.