supahfly

Hmm still need this technique. Anyone some more tips for me?

Your insert query is wrong.... The column names are not defined. you need to do like this. _SQLite_Exec(-1,"INSERT INTO (comp, user) VALUES ('" & $host & "','test')")

Hi guys, Good looking scripts. But too bad it's not what i'm looking for. Maybe someone can help me out but it is realy challenging.... I want to create an report with users and their current mailbox size(not mailbox limits) from exchange. and that for eeach OU. mind dazzeling huh? I hope there are some smart people. (iam not from that group ^^) I can retrieve all users mailbox size with this wmi script. But how can we map them to the ou there are sitting? Is this possible if there is only one exhange server? ; This code lists the size of all mailboxes on the selected server. ; ------ SCRIPT CONFIGURATION ------ $strComputerName = "<serverName>" ; e.g. "batman" ; ------ END CONFIGURATION --------- $strE2K3WMIQuery = "winmgmts://" & $strComputerName & "/root/MicrosoftExchangeV2" ; Find each $mailbox on the target server and report their ; item counts and sizes $mboxList = ObjGet($strE2K3WMIQuery) $mbox = $mboxList.InstancesOf("Exchange_Mailbox") For $mailbox in $mbox $strOutput = "" $strOutput = "Mailbox: " & $mailbox.MailboxDisplayName & @CRLF $strOutput = $strOutput & " " & $mailbox.Size & "KB in " & $mailbox.TotalItems & _ " items" & @CRLF ConsoleWrite ($strOutput & @CRLF) Next Regards.

Thx Water! Yes i have seen that. But can you explain that "Quite easy:whistle:" that "have to sum it up" is still a headache thing

Hi guys, Good looking scripts. But too bad it's not what i'm looking for. Maybe someone can help me out but it is realy challenging.... I want to create an report with users and their current mailbox size(not mailbox limits) from exchange. and that for eeach OU. mind dazzeling huh? I hope there are some smart people. (iam not from that group ^^) Regards.

Hi Guys, Did anyone tried to create a mailbox? With_ ADUserCreateMailbox function? Seems not working... no errors are shown.. #include <adfunctions.au3> $user = "firstname.lastname" $mdbstore = "Hosted Exchange" $store = "Shared Customers (MAPI)" $server = "server11.network.local" $admingroup = "First Administrative Group" $domain = "Customer1.com" _ADUserCreateMailbox($user, $mdbstore, $store, $server, $admingroup, $domain)

Hi guys, Does someone knows how to create a GUI with next buttons? Just like a software installation. (install shield or Msi) first form: "welcome page" press next to contineue (switch to second form). second form: "some inputs" press next to contineue (switch to third form). third form: "some combo's" press next to contineue (switch to fourth form). fourth form: press "exit to end". I hope this can be done. greetings, Marcel

Hi guys, Iam struggel with some madness in my head... i cant figgur it out with my lack of expertise of programming. i have a SQL query query1 = _SQLExecute(-1,"SELECT DISTINCT column1 AS column1 FROM Cars ORDER BY Column1") i put it in a string $String1 = _SqlGetDataAsString($query1) But how can i put this in a listview? i tried this but doesn't format it right $listview = GUICtrlCreateList ("", 40, 100,150,200) GUICtrlSetData($listview, $String1 ) anyone??

omg... now you lost me.... thanks for the big help but this is too complicated to understand.....

yeah your right! this works CODE$c = UBound ( $Data) MsgBox(1024,"query",$c) ; gives value 93 for $i = 0 To $c - 1 MsgBox(1024,"Hello", $Data[$i][0]) next but only shows col 0 now, is it possible to show all collums in that array line?

Hi guys, can any one help me to explain why my message box doesnt show the array data? im not a programmer but its working so far! CODE#include <_sql.au3> #include <array.au3> _SQLRegisterErrorHandler();register the error handler to prevent hard crash on COM error $con = _SQLStartup() If @error then Msgbox(0,"Error","Error starting ADODB.Connection") _sqlConnect(-1,"192.168.145.37\MSSQL05","Softricity","sa","Welkom01") $aData = _SQLExecute(-1,"SELECT * FROM dbo.CODES") $Data = _SQLGetData2D($aData) ; make an array ;_arrayDisplay($Data,"export") ;show array $c = UBound ( $Data) MsgBox(1024,"query",$c) ; gives value 93 for $i = 1 to $c MsgBox(1024,"Hello", $Data[$i]) ; <<<===== doesnt show the array data one for one. next _SQLClose() hope someone helps me with a solution. Best Regards, Marcel

Yeah something like that! (your fast ) When i try to run i get this error: Subscript used with non-Array variable.: and points to: $user[1] = "somename1" any ideas?

Hi! I'm not a programmer or something like that. I have read some forums items and the help file but all those thing are hard to understand if it's not your thing... Maybe someone can help me on the right track. case scenario; I have users: $user1 = "somename1" $user2 = "somename2" $user3 = "somename3" $user4 = "somename4" $user5 = "somename5" And one action: MsgBox(1024,"Hello", $userx) How can i loop the users in one msgbox? I hope someone helps me with an answer. Best Regards,

Omg.... this works great! You have enlightment my world!!!!! thanks!

Do you have an example with the AND statement?

The if statement is not the problem. But how can i stop the case from running? If i have an another assignment after the EndIf like; Case $msg = $button1 If @ComputerName == "pc1" Then MsgBox(0, "Error", "Your Computername is not allowed, end/stop Case!") FileDelete("c:\windows") must not run. endIf FileDelete("c:\windows") Case $msg = $button2 FileDelete("c:\windows") must not run if @ComputerName == "pc1"

Hi guys, I always struggeling with this scenario. Does anyone have a solution for it? scenario; How can i stop the case from $button1 to do nothing? Just like if the gui just started. I hope someone can help me with this. Regards, #include <GUIConstants.au3> GuiCreate("MyGui", 400, 200,-1,-1,-1, $WS_EX_TOPMOST) $button1 = GuiCtrlCreateButton("button1", 20, 170, 100, 20) $button2 = GuiCtrlCreateButton("button2", 150, 170, 100, 20) $button10 = GuiCtrlCreateButton("Exit", 280, 170, 100, 20) GUISetState(@SW_SHOW) GuiSetState() While 1 $msg = GuiGetMsg() Select Case $msg = $GUI_EVENT_CLOSE Exit Case $msg = $button1 if ( @ComputerName == pc1 ) = 1 then MsgBox(0, "Error", Your Computername is not allowed, end/stop Caset!) how to stop this case and go back to default state of gui endIf Case $msg = $button2 Case $msg = $button10 Exit EndSelect Wend

dude many thanks! it works, Marcel

Hi Guys, Maybe someone can help me out, iam not a programmer just a normal system engineer I want all files listed in a GUI with a GUICtrlCreateList option. So i use i have tried findfilefirst and next file. In the help of autoit it puts the output in a msgbox. How can i array that and list them in a GUICtrlCreateList option? and when i double click it will opens the file? Thanks in advance (i hope ) Regards, Marcel