1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| $sSQL = 'SELECT DISTINCT Computer, Description, Type FROM Installed INNER JOIN Computers USING (Computer)'
$iRval = _SQLite_GetTableData2D(-1, $sSQL, $g_aTotalUpdatesByComputer, $iRows, $aCols)
If $iRval <> $SQLITE_OK Then Exit
_ArrayColInsert($g_aTotalUpdatesByComputer, 3)
For $i = 0 To UBound($g_aTotalUpdatesByComputer) - 1
$g_aTotalUpdatesByComputer[$i][$eCol_OldVersions] = 0
Next
; - Version maxi pour chaque soft -
$sSQL = "SELECT * FROM VersionMax"
$iRval = _SQLite_GetTableData2D(-1, $sSQL, $aResult, $iRows, $aCols)
If $iRval <> $SQLITE_OK Then Exit
;~ va($aResult)
; - Nombre d'occurences du soft -
Local $iLastResult = @Compiled ? UBound($aResult) - 1 : ($MAXRESULT = -1 ? UBound($aResult) - 1 : $MAXRESULT)
ConsoleWrite("$iLastResult = " & $iLastResult & @CRLF)
For $iResult = 0 To $iLastResult
If StringRegExp($aResult[$iResult][$eDetailSofts_Name], $g_sExcluded) Then ContinueLoop
$sSQL = 'SELECT Computer FROM Installed' & _
' WHERE Name = "' & $aResult[$iResult][$eDetailSofts_Name] & '" AND CalculatedVersion <> "' & $aResult[$iResult][$eDetailSofts_CalculatedVersion] & '"'
;~ ConsoleWrite($sSQL & @CRLF)
$iRval = _SQLite_GetTableData2D(-1, $sSQL, $aOldVersion, $iRows, $aCols)
If $iRval <> $SQLITE_OK Then Exit
For $i = 0 To UBound($aOldVersion) - 1
; Compte le nombre de mises à jour pour chaque computer
$iIndex = _ArraySearch($g_aTotalUpdatesByComputer, $aOldVersion[$i][0], 0, 0, 0, 0, 1, $eCol_Name)
$g_aTotalUpdatesByComputer[$iIndex][$eCol_OldVersions] += 1
Next
Next |
Partager