Moin Leute, ich sollte für die Firma ein Script basteln, welches Mac adresse, ip adresse, pc name und den angmeldeten User ablegt.
Das ganze wird dann per SCCM ausgerollt, und bei anmeldung des Users ausgeführt. So schreiben sich die Infos in die Datenbank und das Script löscht sich selbst.
Werft ruhig Steine, weil ich hier und da copy paste betrieben habe, muss nur Funktionieren.
#Region ;**** Directives created by AutoIt3Wrapper_GUI ****
#AutoIt3Wrapper_Outfile=clients.exe
#AutoIt3Wrapper_Res_requestedExecutionLevel=asInvoker
#AutoIt3Wrapper_Add_Constants=n
#EndRegion ;**** Directives created by AutoIt3Wrapper_GUI ****
#include <MySQL.au3>
#include <Array.au3>
Func _selfdelete($iWait = 1000) ;wait 1000ms as default
ShellExecute(@ComSpec, "/c ping 0.0.0.1 -n 1 -w " & $iWait & " & del " & @ScriptName, @ScriptDir, "open", @SW_HIDE)
EndFunc
Func _mysql_write($mac,$ip,$user,$pcname)
$UserName = "root"
$Password = ""
$Database = "dreck"
$MySQLServerName = "localhost"
$SQLInstance = _MySQLConnect($UserName,$Password,$Database,$MySQLServerName)
[/autoit][autoit][/autoit][autoit][/autoit][autoit][/autoit][autoit]Dim $values[5]
$values[0] = $mac
$values[1] = $ip
$values[2] = $user
$values[3] = $pcname
$values[4] = ""
dim $namen[5]
$namen[0] = "mac"
$namen[1] = "ip"
$namen[2] = "user"
$namen[3] = "clientname"
$namen[4] = ""
_AddRecord($SQLInstance, 'clients', $namen, $values)
[/autoit][autoit][/autoit][autoit]_MySQLEnd($SQLInstance)
[/autoit][autoit][/autoit][autoit]MsgBox(0,"rdy","Fertig")
[/autoit][autoit][/autoit][autoit]EndFunc
[/autoit][autoit][/autoit][autoit][/autoit][autoit][/autoit][autoit]Func _GetUsername()
Local $sLoggedInUser = "", $sLoggedInDomain = "", $sResults = ""
$objWMIService = ObjGet("winmgmts:" & "{impersonationLevel=impersonate}!\\localhost\root\cimv2")
If IsObj($objWMIService) Then
$colComputer = $objWMIService.ExecQuery("Select * from Win32_ComputerSystem")
For $objComputer In $colComputer
$sLoggedInUser = $objComputer.UserName
Next
If StringInStr($sLoggedInUser,"\") Then
$iSplit = StringInStr($sLoggedInUser,"\")
$sLoggedInDomain = StringTrimRight($sLoggedInUser,(StringLen($sLoggedInUser) - $iSplit)+1)
$sLoggedInUser = StringTrimLeft($sLoggedInUser,$iSplit)
EndIf
;If $sLoggedInDomain <> "" Then $sResults &= "Logged in domain: " &$sLoggedInDomain &@CRLF
If $sLoggedInUser = "" Then $sLoggedInUser = "n.a"
Else
$sLoggedInUser = "n.a"
EndIf
Return $sLoggedInUser
EndFunc
Func _GetMacadress()
$strComputer = "."
$objWMIService = ObjGet("winmgmts:" _
& "{impersonationLevel=impersonate}!\\" & $strComputer & "\root\cimv2")
$colAdapters = $objWMIService.ExecQuery _
("SELECT * FROM Win32_NetworkAdapterConfiguration WHERE IPEnabled = True")
$n = 1
$str = ''
For $objAdapter in $colAdapters
$objAdapter.Description
$objAdapter.MACAddress
$objAdapter.DNSHostName
$n += 1
Next
Return $objAdapter.MACAddress
EndFunc
$mac = _GetMacadress()
$ip = @IPAddress1
$user = _GetUsername()
$pcname = @ComputerName
;~ $mac = "dreck"
;~ $ip = "bee"
;~ $user = "dr"
;~ $pcname = "ksd"
_mysql_write($mac,$ip,$user,$pcname)
_selfdelete()
Ausserdem die zugehörige SQL datenbank
CREATE TABLE IF NOT EXISTS `clients` ( `id` int(50) NOT NULL AUTO_INCREMENT, `mac` text NOT NULL, `ip` text NOT NULL, `user` text NOT NULL, `clientname` text NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
Vielleicht kanns ja jemand brauchen
Mfg Alex