Jump to content
Sign in to follow this  
Colyn1337

Automatic Firmware Updates - SQLite & WMI

Recommended Posts

#cs -----------------------------------------------------------------------------------------------------------------
Author:
Colyn Via
Script Function:
Query local device WMI info and perform a SQL lookup to check for firmware updates. The SQL database contains
device models, current firmware version, and the path to the update package. This script looks for the firmware
version based on the device model, and then copies the installer to the host drive. The script then performs a
silent install of the firmware update all the while preventing an accidental shutdown. This script has a verbose
log which gets copied to a network location if there's a problem. If it's successful the log writes a single
line to a master log in the same network location reporting it's success. Once the update is complete, the
installer file is deleted, as well as the local log file.
Version Notes:
1.0.03 - Adjusted final write to local log so that the $FirmwareDBResult is written in the log.
1.0.02 - Added processwait() to script to prevent premature script completion
1.0.01 - Added values to BIOSString dump in addition to names
1.0.00 - Initial complete version
#ce -----------------------------------------------------------------------------------------------------------------
#NoTrayIcon
#include 
#include 
; Unless directed otherwise, autoit will do an internet lookup for the driver to use. Later in the code
; the _SQLite_Startup UDF directs the program to get the driver locally. This is why it's important to
; include the driver in the package.
FileInstall("SQLite3.dll", @ScriptDir & "", 1)
Global $FWversion, $Product, $hDB, $hQuery, $aRow, $UpgradeDBResult, $FWversionDBResult, $CheckCurrent
Global $CheckDB, $UpgradeEXE, $SQLQuery1, $SQLQuery2, $PID
Global Const $Timestamp = @MON & "/" & @MDAY & "/" & @YEAR & " " & @HOUR & ":" & @MIN & ":" & @SEC & " "
Global Const $Log = "C:AMTFirmwareLog_" & @ComputerName & ".txt"
Global Const $GlobalLog = 'redactedvProFirmware ResponsesSuccessSucceeded.txt'
Global Const $FirmwareDB = 'redactedvProFirmware.db'
Global Const $GlobalResponse = 'redactedvProFirmware Responses'
; This script was designed to be verbose and log most events. This code creates the log and adds the first line.
FileWriteLine($Log, $Timestamp & "Hello! My name is " & @ComputerName & ". " & @OSVersion & " " & @OSArch & " is how I roll.")
FileWriteLine($Log, $Timestamp & "I'm running script 1.0.03.")
FWversion()
; This function runs a WMI query to get the current AMT firmware version on the device.
Func FWversion()
$objIntelME = ObjGet("winmgmts:" & "." & "rootIntel_ME")
; An error catch must be present here, as AutoIt does not mute COM errors naturally. Without this catch,
; an ugly sounding error will appear to the user. IsObj() is not enough, as it cannot handle a return.
If @error Then
FileWriteLine($Log, $Timestamp & "Intel_ME is not a valid NAMESPACE.")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
Exit
EndIf
$colIntelME = $objIntelME.ExecQuery("SELECT * FROM ME_System")
; The "Else" of this statement reports back which devices couldn't determine their firmware version.
If IsObj($colIntelME) Then
For $objMEsystem In $colIntelME
$FWversion = $objMEsystem.fwversion
Next
Else
FileWriteLine($Log, $Timestamp & "ME_System query failed.")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
Exit
EndIf
FileWriteLine($Log, $Timestamp & "Local host vPro firmware lookup result = " & $FWversion)
ConsoleWrite("Local host vPro firmware lookup result = " & $FWversion & @LF)
EndFunc ;==>FWversion
Product()
; This function runs a WMI query to get the current model information for the device.
Func Product()
; Since these variables are used often in general coding practice, they are Local'd instead of
; declared global. When the code finishes this function, it will drop these variables.
Local $x, $y, $prodArray, $aRefine
$objWMI = ObjGet("winmgmts:" & @ComputerName & "rootHPInstrumentedBIOS")
If @error Then
FileWriteLine($Log, $Timestamp & "rootHPInstrumentedBIOS is not a valid NAMESPACE.")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
Exit
EndIf
$colItems = $objWMI.ExecQuery("SELECT * FROM HPBIOS_BIOSString")
; The "Else" of this block accounts for the possibility that this code might run on a non HP device.
If IsObj($colItems) Then
FileWriteLine($Log, $Timestamp & "Attempting to grab hardware info.")
For $objItems In $colItems
If $objItems.Name = "Notebook Model" Then
$Product = $objItems.Value
FileWriteLine($Log, $Timestamp & "Raw value for " & $objItems.Name & " is " & $Product)
$prodArray = StringSplit($Product, " ")
; BIOS revisions change slightly how the information is presented by WMI. Sometimes it's
; simply the Model number, other times it can be a string of words. For simplicity and
; uniformity, this code strips out just the Model number from the string. This code is
; looking for a word that starts with a number. If HP begins using Model Numbers that
; start with letters, this code will need to be reworked.
For $x = 1 To $prodArray[0]
If StringIsAlpha($prodArray[$x]) Then
Else
; As it turns out, HP in its infinite wisdom decided to, in some cases, put both
; product identifiers in the SAME CIM component value. This confuses the scrip and
; it ends up recording the wrong value. To correct for this, and as the model
; number always starts with a number (currently), I've directed the script to check
; the first character in the string it's wanting to use to see if it's a number
; IsInt means "is it an integer", which in this case, the value is not. AutoIt
; sees it as a string, so Number() is used instead.
FileWriteLine($Log, $Timestamp & "I'm considering using " & $prodArray[$x] & ".")
$aRefine = StringSplit($prodArray[$x], "")
If Number($aRefine[1]) Then
FileWriteLine($Log, $Timestamp & "It turns out that " & $prodArray[$x] & " starts with " & $aRefine[1] & _
" and must therefore be what I'm looking for. Right?")
$Product = ($prodArray[$x])
EndIf
EndIf
Next
ExitLoop
ElseIf $objItems.Name = "Product Name" Then
$Product = $objItems.Value
FileWriteLine($Log, $Timestamp & "Raw value for " & $objItems.Name & " is " & $Product)
$prodArray = StringSplit($Product, " ")
For $x = 1 To $prodArray[0]
If StringIsAlpha($prodArray[$x]) Then
Else
FileWriteLine($Log, $Timestamp & "I'm considering using " & $prodArray[$x] & ".")
$aRefine = StringSplit($prodArray[$x], "")
If Number($aRefine[1]) Then
FileWriteLine($Log, $Timestamp & "It turns out that " & $prodArray[$x] & " starts with " & $aRefine[1] & _
" and must therefore be what I'm looking for. Right?")
$Product = ($prodArray[$x])
EndIf
EndIf
Next
ExitLoop
EndIf
Next
FileWriteLine($Log, $Timestamp & "Finished attempts to grab hardware info.")
; In the event that "Notebook Model" is not the value to read, it helps to see what should be added.
; The following code runs a dump of the contents of HPBIOS_BIOSstring and copies the log to the log directory.
; Later the results of the log can be used to determine what other $objItems.Name might exist.
If $Product = "" Then
FileWriteLine($Log, $Timestamp & "Query (SELECT * FROM HPBIOS_BIOSString) SUCCEEDED! However unable to " & _
"resolve object.name of known variables on " & @ComputerName & ".")
FileWriteLine($Log, "*************** Beginning Dump of HPBIOS_BIOSstring ***************")
For $objItems In $colItems
FileWriteLine($Log, "*** " & $objItems.name & " = " & $objItems.Value)
Next
FileWriteLine($Log, "*************** Done Exporting HPBIOS_BIOSstring ***************")
Sleep(5)
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
Exit
EndIf
Else
FileWriteLine($Log, $Timestamp & "rootHPInstrumentedBIOS is not a valid NAMESPACE on " & @ComputerName & ".")
EndIf
ConsoleWrite("WMI query for Model produced " & $Product & @LF)
EndFunc ;==>Product
If $FWversion = "" Then Exit
If $Product = "" Then Exit
SQL()
; This function names the SQL queries and initializes the SQL engine.
Func SQL()
; SQL Queries
$SQLQuery1 = "SELECT " & '"' & "Update" & '"' & " FROM Lookup WHERE Product=" & '"' & $Product & '"' & ';'
$SQLQuery2 = "SELECT " & '"' & "FWVersion" & '"' & " FROM Lookup WHERE Product=" & '"' & $Product & '"' & ';'
; Check the DB and open it if the script can find it
FileWriteLine($Log, $Timestamp & "Checking to see if " & '"' & $FirmwareDB & '"' & " exists...")
If FileExists($FirmwareDB) Then
FileWriteLine($Log, $Timestamp & "Found it!")
Else
FileWriteLine($Log, $Timestamp & "I can't see it!")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
Exit
EndIf
_SQLite_Startup("", "", 0)
_SQLite_Open($FirmwareDB)
EndFunc ;==>SQL
Eligibility()
; This function determines the devices eligibility to upgrade, and figures out where to get the update from.
Func Eligibility()
; Since these variables are used often in general coding practice, they are Local'd instead of
; declared global. When the code finishes this function, it will drop these variables.
Local $x, $y, $z, $Proceed, $diff, $exe
_SQLite_Query(-1, $SQLQuery1, $hQuery)
If _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK Then
Else
ConsoleWrite("Query Failed")
FileWriteLine($Log, $Timestamp & $SQLQuery1 & " FAILED.")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
_SQLite_QueryFinalize($hQuery)
_SQLite_Close()
_SQLite_Shutdown()
Exit
EndIf
$UpgradeDBResult = $aRow[0]
FileWriteLine($Log, $Timestamp & $SQLQuery1 & " SUCCEEDED.")
_SQLite_QueryFinalize($hQuery)
ConsoleWrite($UpgradeDBResult & @LF)
; Need to get just the name of the update executable for use later.
$exe = StringSplit($UpgradeDBResult, "")
$UpgradeEXE = $exe[($exe[0])]
FileWriteLine($Log, $Timestamp & "The executable needed later is " & $UpgradeEXE & ".")
; Testing purposes - Making my host appear to be a 6550b
;~ $SQLQuery2 = "SELECT " & '"' & "FWVersion" & '"' & " FROM Lookup WHERE Product=" & '"' & "6550b" & '"' & ';'
_SQLite_Query(-1, $SQLQuery2, $hQuery)
If _SQLite_FetchData($hQuery, $aRow) = $SQLITE_OK Then
Else
ConsoleWrite("Query Failed")
FileWriteLine($Log, $Timestamp & $SQLQuery2 & " FAILED.")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
_SQLite_QueryFinalize($hQuery)
_SQLite_Close()
_SQLite_Shutdown()
Exit
EndIf
$FWversionDBResult = $aRow[0]
FileWriteLine($Log, $Timestamp & $SQLQuery2 & " SUCCEEDED.")
_SQLite_QueryFinalize($hQuery)
ConsoleWrite($FWversionDBResult & @LF)
FileWriteLine($Log, $Timestamp & "Query result was " & $FWversionDBResult)
; Be sure to close down SQL when it's not needed.
_SQLite_Close()
_SQLite_Shutdown()
; Testing purposes - Make my firmware appear older
;~ $FWversion = "6.2.0.1022"
FileWriteLine($Log, $Timestamp & "Comparing firmware versions.")
; So as not to run the risk of destroying the data, the data is copied to new
; variables before be begin to break it apart into arrays.
$CheckCurrent = StringSplit($FWversion, ".")
$CheckDB = StringSplit($FWversionDBResult, ".")
FileWriteLine($Log, $Timestamp & "Splitting firmware strings.")
; This code checks to make sure the two arrays are equal in terms of size.
; If they are not, the code will generate an error. This code also manually
; adjusts either array so that it always matches the larger of the two.
If $CheckDB[0] > $CheckCurrent[0] Then
$diff = ($CheckDB[0] - $CheckCurrent[0])
For $z = 1 To $diff
_ArrayAdd($CheckCurrent, 0)
Next
EndIf
If $CheckDB[0] < $CheckCurrent[0] Then
$diff = ($CheckCurrent[0] - $CheckDB[0])
For $z = 1 To $diff
_ArrayAdd($CheckDB, 0)
Next
EndIf
FileWriteLine($Log, $Timestamp & "Finished comparing stringsplit array sizes, continuing to determine if upgrade is needed.")
; This part is checking to see if the firmware update indicated by the SQL query
; is newer than the current version on the device. If the firmware is current or
; better, the program deletes the log file and closes.
Do
For $x = 1 To $CheckDB[0]
If $CheckDB[$x] > $CheckCurrent[$x] Then
$Proceed = "y"
ExitLoop
ElseIf $CheckDB[$x] < $CheckCurrent[$x] Then
$Proceed = "n"
ExitLoop
ElseIf $CheckDB[$x] = $CheckCurrent[$x] And $x = $CheckDB[0] Then
$Proceed = "n"
ExitLoop
EndIf
Next
Until $Proceed <> ""
If $Proceed = "n" Then
FileDelete($Log)
Exit
EndIf
FileWriteLine($Log, $Timestamp & "Finished comparing firmware versions. Proceeding to UpdateFirmware()")
EndFunc ;==>Eligibility
; $UpgradeDBResult is the path to the firmware update as retrieved by the Eligibility() function
UpdateFirmware()
; This function pulls down the update and executes it. It also writes to the $GlobalLog.
Func UpdateFirmware()
FileWriteLine($Log, $Timestamp & "Attempting to copy " & '"' & $UpgradeDBResult & '"' & " to local drive.")
If FileExists($UpgradeDBResult) Then
FileCopy($UpgradeDBResult, @HomeDrive & "")
Else
FileWriteLine($Log, $Timestamp & "FileExists() check failed. I quit!")
FileCopy($Log, $GlobalResponse)
FileDelete($Log)
Exit
EndIf
FileWriteLine($Log, $Timestamp & "Run command issued for " & @HomeDrive & "" & $UpgradeEXE)
; The -s switch is for silent install
Run(@HomeDrive & "" & $UpgradeEXE & " -s", "", @SW_HIDE)
; Prevent shutdown during firmware update process
ProcessWait($UpgradeEXE, 60)
Do
Run("shutdown /a", @SystemDir, @SW_HIDE)
Sleep(10)
$PID = ProcessExists($UpgradeEXE)
Until $PID = 0
FileWriteLine($GlobalLog, $Timestamp & @ComputerName & " launched " & $UpgradeEXE & " to achieve " & $FWversionDBResult & ".")
EndFunc ;==>UpdateFirmware
FileDelete(@HomeDrive & "" & $UpgradeEXE)
FileDelete($Log)
Exit

Edited by Colyn1337

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.

  • Similar Content

    • By DirtyJohny
      Hi everyone.Need rewrite this function how in еxample.
      Original:
      #RequireAdmin #NoTrayIcon Opt("MustDeclareVars",1) Func _a() Local $sls=ObjGet("winmgmts:{impersonationLevel=impersonate," _ &"authenticationLevel=Pkt}!\\"& _ @ComputerName&'\root\wmi'),$lss=$sls.ExecQuery _ ('SELECT * FROM WmiMonitorID'), _ $lll,$sll,$sss="",$lsl,$lls,$i,$z For $z In $lss $lsl=$z.UserFriendlyName For $i=0 To Ubound($lsl)-1 if ($lsl[$i]) Then $lll&=Chr($lsl[$i]) Next $lls=$z.SerialNumberID For $i=0 To Ubound($lls)-1 if ($lls[$i]) Then $sll&=Chr($lls[$i]) Next $sss&="Model"&@TAB&@TAB&": "&$lll&@CR&"Serial Number"&@TAB&": "&$sll&@CR&@CR $lll="" $sll="" Next MsgBox(262144,'Monitors '&$lss.Count,$sss&" "&@CR) $lss=Null $sls=Null EndFunc _a() Example:
      Func _InfoPC() Local $ObjService = ObjGet('winmgmts:{impersonationLevel = impersonate}!\\' & @ComputerName & '\root\cimv2') Local $ObjMB = $ObjService.ExecQuery('SELECT * FROM Win32_BaseBoard', 'WQL', 0x30) If IsObj($ObjService) Then For $objItemMB In $ObjMB $sInfo &= @TAB & 'Motherboard: ...... ' & $objItemMB.Product & @CRLF I'm beginner in this sphere and need  you all speak easy and simply because i'm Russian.Thanks)
    • By jguinch
      Hello.
      I did create these few functions several months ago. I post here, if it can interest someone.
      These functions based on WMI queries allow you to manage printers : add / delete printer, driver, port, or obtain configuration, set default printer ... I let you discover it with the code.

       
      Here is the list of the available functions :
      _Printmgr_AddLocalPort
      _Printmgr_AddLPRPort
      _PrintMgr_AddPrinter
      _PrintMgr_AddPrinterDriver
      _PrintMgr_AddTCPIPPrinterPort
      _PrintMgr_AddWindowsPrinterConnection
      _PrintMgr_CancelAllJobs
      _Printmgr_EnumPorts
      _PrintMgr_EnumPrinter
      _PrintMgr_EnumPrinterConfiguration
      _PrintMgr_EnumPrinterDriver
      _PrintMgr_EnumPrinterProperties
      _PrintMgr_EnumTCPIPPrinterPort
      _Printmgr_Pause
      _Printmgr_PortExists
      _Printmgr_PrinterExists
      _Printmgr_PrinterSetComment
      _Printmgr_PrinterSetDriver
      _Printmgr_PrinterSetPort
      _Printmgr_PrinterShare
      _Printmgr_PrintTestPage
      _PrintMgr_RemoveLocalPort
      _PrintMgr_RemoveLPRPort
      _PrintMgr_RemovePrinter
      _PrintMgr_RemovePrinterDriver
      _PrintMgr_RemoveTCPIPPrinterPort
      _PrintMgr_RenamePrinter
      _Printmgr_Resume
      _PrintMgr_SetDefaultPrinter
       
      And some examples :
      #include <Array.au3> #include "PrintMgr.au3" _Example() Func _Example() ; Remove a printer called "My old Lexmark printer" : _PrintMgr_RemovePrinter("My old Lexmark printer") ; Remove the driver called "Lexmark T640" : _PrintMgr_RemovePrinterDriver("Lexmark T640") ; Remove the TCP/IP printer port called "TCP/IP" _PrintMgr_RemoveTCPIPPrinterPort("MyOLDPrinterPort") ; Add a driver, called "Samsung ML-451x 501x Series", and driver inf file is ".\Samsung5010\sse2m.inf" _PrintMgr_AddPrinterDriver("Samsung ML-451x 501x Series", "Windows NT x86", @ScriptDir & "\Samsung5010", @ScriptDir & "\Samsung5010\sse2m.inf") ; Add a TCP/IP printer port, called "MyTCPIPPrinterPort", with IPAddress = 192.168.1.10 and Port = 9100 _PrintMgr_AddTCPIPPrinterPort("MyTCPIPPrinterPort", "192.168.1.10", 9100) ; Add a printer, give it the name "My Printer", use the driver called "Samsung ML-451x 501x Series" and the port called "MyTCPIPPrinterPort" _PrintMgr_AddPrinter("My Printer", "Samsung ML-451x 501x Series", "MyTCPIPPrinterPort") ; Set the printer called "My Printer" as default printer _PrintMgr_SetDefaultPrinter("My Printer") ; Connect to the shared printer "\\192.168.1.1\HPDeskjetColor") _PrintMgr_AddWindowsPrinterConnection("\\192.168.1.1\HPDeskjetColor") ; List all installed printers Local $aPrinterList = _PrintMgr_EnumPrinter() _ArrayDisplay($aPrinterList) ; List all printers configuration Local $aPrinterConfig = _PrintMgr_EnumPrinterConfiguration() _ArrayDisplay($aPrinterConfig) ; List all installed printer drivers Local $aDriverList = _PrintMgr_EnumPrinterDriver() _ArrayDisplay($aDriverList) ; Retrieve the printer configuration for the printer called "Lexmark T640" $aPrinterConfig = _PrintMgr_EnumPrinterConfiguration("Lexmark T640") _ArrayDisplay($aPrinterConfig) ; Add a local printer port (for a file output) _PrintMgr_AddLocalPort("c:\temp\output.pcl") ; Remove the local port _PrintMgr_RemoveLocalPort("c:\temp\output.pcl") EndFunc ;==>_Example Download link :
      PrintMgr.au3
      PrintMgr_Example.au3
    • By dmob
      So I am trying to implement an archive system of sorts for my (SQLite) DB app. I wrote a function to attach a separate (archive) DB and
      sync the columns with main DB. If archive DB file does not exist, create file with _SQLiteOpen then close the file (and thus connection) with SQLite_Close.
      This works as intended, however, after the create operation, all subsequent _SQLite_* functions returned a "Library misuse error".
      After a little digging I found the problem in the _SQLite_Close function: it clears the "last opened database" handle even when there still is a live
      DB connection open. All other functions then "think" there is no DB connection active. I hacked two functions in the UDF for a quick fix:

      In _SQLite_Close: Change
      ... $__g_hDB_SQLite = 0 __SQLite_hDel($__g_ahDBs_SQLite, $hDB) Return $iRval[0] to:
      $__g_hDB_SQLite = __SQLite_hDel($__g_ahDBs_SQLite, $hDB) Return $iRval[0] and in Func __SQLite_hDel changed
      Func __SQLite_hDel(ByRef $ahLists, $hGeneric) Local $iElement = _ArraySearch($ahLists, $hGeneric) If $iElement > 0 Then _ArrayDelete($ahLists, $iElement) EndFunc ;==>__SQLite_hDel to:
      Func __SQLite_hDel(ByRef $ahLists, $hGeneric) Local $iElement = _ArraySearch($ahLists, $hGeneric) If $iElement > 0 Then _ArrayDelete($ahLists, $iElement) Return $ahLists[UBound($ahLists)-1] ; Return last opened db EndIf Return 0 EndFunc ;==>__SQLite_hDel so it preserves last opened DB again.
       
      My archive function now works great
      I'm not sure if this should be classified as a bug, but I believe so...
      Hope this helps someone before
    • By shital
      #Region ;**** Directives created by AutoIt3Wrapper_GUI **** #AutoIt3Wrapper_UseX64=y #EndRegion ;**** Directives created by AutoIt3Wrapper_GUI **** RunAs(test", @ComputerName, "testinng",2,"wmic product where ""name= '%notepadexamples%'"" call uninstall", @SystemDir & "\wbem", @SW_MAXIMIZE)  it not working 
       
    • By Colduction
      Hi AutoIt Programmers!

      I've seen a code that gives Name of Group by writing it's group's SID, but this one response very slower than Windows Command-Line WMIC
       
      Func _GetLocalGroupName($sSID = 'S-1-5-18') $objWMIService = ObjGet ("winmgmts:\\" & @ComputerName & "\root\cimv2") $colItems = $objWMIService.ExecQuery('SELECT Name FROM Win32_Group where SID="' & $sSID & '"') For $GroupNames in $colItems MsgBox (0,"",$GroupNames.Name) ExitLoop Next EndFunc I don't want call and use any third-party programs even CMD, i just want use from Windows API, netapi32.dll or AutoIt Functions (Standalone).
      Do you have any idea to improve speed/performance of this code? I'll happy of your comments
       
       
       
      ====================== SOLOUTION by @Subz ======================
       
×
×
  • Create New...