DZone Snippets: windows code

Internet Explorer automation using win32::OLE

bouffon69 (Sylvain Le Courtois) — Fri, 28 Sep 2007 11:45:24 GMT

// Sample code used for one of my client



#!/usr/bin/perl -w



use strict;

use Data::Dumper;

use Win32::OLE qw( EVENTS );



my ($day, $mon, $year, $hour, $min, $sec) = (localtime)[3, 4, 5, 2, 1, 0];

$mon++; # 0-based index

$year = $year + 1900;

my $date = sprintf ("%04i-%02i-%02i %02i\:%02i\:%02i", $year, $mon, $day, $hour, $min, $sec);



my $Disconnect;

my $Menu;

my $TreeView;

my $WatchDog;

my $MenuClicked=0;



my $ScenarioCompleted=0;



my @TreeViewLinks=("Appareillage du B","Branchement Comptage","Branchement individuel");

my $Previouslink=$TreeViewLinks[0];



my $ie = Win32::OLE->new( 'InternetExplorer.Application' ) or die "error starting IE";

$ie->{visible} = 1;



Win32::OLE->Option( Warn => 3 );



$WatchDog=time();

Win32::OLE->WithEvents( $ie, \&Event, 'DWebBrowserEvents2' );

$ie->navigate( 'http://www.xxx.fr' );

Win32::OLE->MessageLoop();

unlink("noemis.err") if -f "noemis.err";

if ( ! $ScenarioCompleted ) {

	open( ERR , ">noemis.err" ); 

	print ERR "Problem executing Noemis scenario, please check www.xxx.fr.\n" ;

	close(ERR);

}

$Disconnect->Click();

Win32::OLE->SpinMessageLoop;



# Maintenance du fichier historique

open ( STATS , "noemis.txt" );

my @lines=;

close (STATS);

open( STATS , ">noemis.txt" ); 

for my $line (@lines) {

	my ($datetime) = split ( /;/ , $line );

	my ($h_year,$h_mon) = $datetime =~ /^([0-9]{4})-([0-9]{2})/;

	print STATS $line if ($year*12+$mon) - ($h_year*12+$h_mon) < 2;

}

print STATS join(";",$date,"Noemis Scenario",( time() - $WatchDog ))."\n";

close( STATS );



sleep 2;

Win32::OLE->SpinMessageLoop;

sleep 1;

$ie->Quit();

exit 0;





sub Event {

	my ($Obj,$Event,@Args) = @_;

	my $IEObject = shift @Args;

	print " Event triggered: $Event\n";    



	my ($i,$anchor);

	my $anchors;

    

	# STEP 1 : Find the main menu, login to the web site, find the treeview

	if ($Event eq "DocumentComplete") {    

		print "URL: " . $IEObject->Document->URL . "\n";

		if ( $IEObject->Document->URL eq "http://www.xxx.fr/ident.aspx" ) {

			my $forms = $IEObject->Document->forms;

			my $form = $forms->item(0);

			if ( defined($form->elements("fldNumCli")) ) {

				print "--------------------------------------------\n";

				print "Found the login box, authenticating ...\n";

				print "--------------------------------------------\n";

			    $form->elements("fldNumCli")->{value} = "xxxx";

			    $form->elements("fldUtil")->{value} = "xxx";

			    $form->elements("fldPwd")->{value} = "xxx";

		    	$form->elements("btIdent")->Click();

	    		}

		}

		if ( $IEObject->Document->URL eq "http://www.xxx.fr/menu.aspx" ) {

			print "Found the menu.\n";

			$Menu = $IEObject->Document;

			$anchors = $IEObject->Document->links;

			for (my $i=0; $i < $anchors->length; $i++) {

				$anchor = $anchors->item($i);

				print $anchor->href."\n";

				$Disconnect = $anchor if $anchor->href eq "http://www.xxx.fr/ident.aspx?qs=deconnecter";

			}

	      	}	    

		if ( $IEObject->Document->URL eq "http://www.xxx.fr/client/frameTreeview.aspx" ) {

			print "Found the TreeView.\n";

			$TreeView = $IEObject->Document;

      		}		

	}



	# STEP 2 : Click on the Menu and TreeView links   

	if ($Event eq "DocumentComplete") {    		

	if ( ! $MenuClicked and defined($Menu) ) {

		my $MenuItem = $Menu->getElementById("SM_CLIE_RECH");

		if ( defined($MenuItem) ) { 

			print $MenuItem->ID."\n";

			$MenuItem->Click;

			$MenuClicked = 1;

		}

	}}



	if ( $Event eq "CommandStateChange" or $Event eq "StatusTextChange" ) {

		print Dumper($IEObject);

	}

	if ( @TreeViewLinks != 0 and 

	     defined($TreeView) and 

	     $Event eq "DocumentComplete" 

	) {

		my $link = shift(@TreeViewLinks);

		$anchors = $TreeView->links;

		my $found=0;

		print "Looking for '$link' in the TreeView ... \n";

	        for (my $i=0; $i < $anchors->length; $i++) {

		       	$anchor = $anchors->item($i);

	        	#print $anchor->innerHTML."\n";

		       	if ( $anchor->innerHTML =~ /$link/ ) {

				print "Clicking on '$link' ... \n";

	                	$anchor->Click;

				$found=1;

				$Previouslink=$link;

				last;

			}

	        }

		if ( ! $found ) { 

			# Le TreeView a bugge, on reclique

			sleep 1;

			print "Looking for '$Previouslink' in the TreeView ... \n";

		        for (my $i=0; $i < $anchors->length; $i++) {

			       	$anchor = $anchors->item($i);

	        		#print $anchor->innerHTML."\n";

		       		if ( $anchor->innerHTML =~ /$Previouslink/ ) {

					print "Clicking on '$Previouslink' ... \n";

	              		  	$anchor->Click;

					last;

				}

		        }

			unshift @TreeViewLinks,$link;

		}

	} 

   

	# STEP 3 : Verify the list displayed 

		

	if ($Event eq "DocumentComplete") {    

   		if ( @TreeViewLinks == 0 and $IEObject->Document->URL =~ /listeRefPlof.aspx/ ) {

			print "Scenario completed, exiting ...\n";

			$ScenarioCompleted=1;

	   		Win32::OLE->QuitMessageLoop;

		}

	}

    



	# Exit on errors

	    

	Win32::OLE->QuitMessageLoop() if $Event eq "OnQuit" or time() > $WatchDog + 60;

    

}

ASP Page listing and making changes to AD accounts

bouffon69 (Sylvain Le Courtois) — Thu, 20 Sep 2007 07:02:54 GMT

// Used for automated AD account migration



Workstation User Account migration

href="files/v2006.css" type=text/css rel=stylesheet>





<%

' ------------------------------------------------------------------------

Const ADS_PROPERTY_CLEAR = 1



Const SOURCE_OU="ou=NT Users,ou=NT,dc=fr,dc=erm,dc=int"

Const TARGET_OU="ou=SUPPORT SERVICES,dc=fr,dc=erm,dc=int"



Const HOMES_PATH="\\frsrvfil0001\USERS\"

Const PROFILES_PATH="\\frsrvfil0001\PROFILES\"



Const ADMIN_HOMES_PATH_SOURCE="\\frsrvfil0001\U$\NT\"

Const ADMIN_PROFILES_PATH_SOURCE="\\frsrvfil0001\P$\NT\"

Const ADMIN_HOMES_PATH_DEST="\\frsrvfil0001\U$\"

Const ADMIN_PROFILES_PATH_DEST="\\frsrvfil0001\P$\"



Const SCRIPT_NAME="ntuser_to_xp.asp"



Dim State

State="Init"

Dim OU, Member

 

If Request.QueryString("login") <> "" Then

		' Affichage formulaire pour modif du compte

		State="Info"

End If

If Request.Form("login") <> "" Then

		' On a cliqué sur OK pour valider le formulaire

		State="Modify"

End If

' ------------------------------------------------------------------------

%>

border=0>






  
  
    

      






        
        
                      width=160> 
          



<%

	If State="Init" Then

	'-----------------------------------------------------------------------------------

	' Listing of the NT Users

	'-----------------------------------------------------------------------------------

%>          



                        border=0>









              
              
                

                    <%

                    'Response.Write(SOURCE_OU & "
") 

                    %>

					Please select the NT 4.0 Workstation user account to migrate

                
                
              
                

                                  <%

                  Set OU = GetObject("LDAP://" & SOURCE_OU)

                  OU.Filter = Array("user")

    	          For Each Member In OU

    	          		' Bug with the SMS Account ??

    	          		If Member.Name <> "CN=SMSService" Then 

    	          		If Member.AccountDisabled = 0 Then

	    	                Response.Write("" & Member.FullName & "
")

	    	            End If

	    	            End If 

            	  Next      

                  

                  %>



                
                
                
                



<%

End If

%>                

                

<%

	If State="Info" Then

	'-----------------------------------------------------------------------------------

	' Information page about the NT Users

	'-----------------------------------------------------------------------------------

%>          

			



                        border=0>





                  <%

                  Sub TabRow(v1,v2)

                  		Response.Write("")

                  		Response.Write("")

                  End Sub

                  Set Member = GetObject("LDAP://" & Request.QueryString("login") & "," & SOURCE_OU)


                  TabRow "User Name",Member.FullName

                  TabRow "NT Login",Member.sAMAccountName

				  TabRow "Login Script", Member.LoginScript & " (to delete)"

				  TabRow "Profile Path", Member.Profile

				  TabRow "New Path",PROFILES_PATH & Member.sAMAccountName

				  TabRow "Home Folder", Member.HomeDirectory

				  TabRow "New Path",HOMES_PATH & Member.sAMAccountName


				  ' Liste des OU dans SUPPORT SERVICES

 				  Dim OUSuppServices, Entity, BoxList

 				  Set OUSuppServices=GetObject("LDAP://" & TARGET_OU)

				  OUSuppServices.Filter = Array("organizationalUnit")

				  BoxList=""

				  TabRow "Organizational Unit",BoxList


                  %>



              
              
                

                 	<%

                 	Response.Write("Windows NT 4.0 User Account Migration")

                    %>

					

                
               
" & v1 & "")

                  		Response.Write(" " & v2 & "
				  
                                    

                
                

                


                 >

                

                 Cliquer ici pour migrer ce compte.



                ATTENTION, l'utilisateur ne doit pas être connecté ! 

                <% Response.Write("

" & "Cliquer ICI pour annuler" & "
") %>

                



<%

End If

%>                



<%



	If State="Modify" Then

	'-----------------------------------------------------------------------------------

	' Migration of the NT Users

	'-----------------------------------------------------------------------------------

Sub dirMoveTree(source, dest)

	Response.Write "Deplacement de " & source & " vers " & dest & "
"

	Dim Folder,File,SubFolder

	set Folder=fso.GetFolder(source)

	For Each File In Folder.Files

	      Response.Write File.Name & " File -> " & dest & "
"

	      file.move dest & "\"

	Next

	For Each SubFolder In Folder.SubFolders

	      Response.Write SubFolder.Name & " Folder -> " & dest & "
"

	      SubFolder.move dest & "\"

	Next

End Sub



%>          



Windows NT 4.0 User Account Migration



<%



' Modification des proprietes l'utilisateur dans AD

Set Member = GetObject("LDAP://" & Request.QueryString("login") & "," & SOURCE_OU)



' ADS_PROPERTY_CLEAR

Member.PutEx 1, "scriptPath", 0

Member.SetInfo



Member.Put "profilePath", PROFILES_PATH & Member.sAMAccountName

Member.Put "homeDirectory", HOMES_PATH & Member.sAMAccountName

' 

Member.SetInfo

' 

Response.Write("Utilisateur " & Member.sAMAccountName & " Modifié dans AD

")



' Deplacement dans le bon conteneur

Set OU = GetObject("LDAP://" & "OU=Users," & Request.Form("entity") & "," & TARGET_OU)

OU.MoveHere "LDAP://" & Request.QueryString("login") & "," & SOURCE_OU, Request.QueryString("login")

Response.Write("Utilisateur " & "LDAP://" & Request.QueryString("login") & "," & SOURCE_OU & " Deplacé dans " & "LDAP://" & "OU=Users," & Request.Form("entity") & "," & TARGET_OU & "

")



DIM fso, File, Folder, SubFolder

Set fso = CreateObject("Scripting.FileSystemObject")



' Creation des repertoires cible



fso.CreateFolder(ADMIN_HOMES_PATH_DEST & Request.Form("login"))

fso.CreateFolder(ADMIN_PROFILES_PATH_DEST & Request.Form("login"))



' Deplacement des données



dirMoveTree ADMIN_HOMES_PATH_SOURCE & Request.Form("login"),ADMIN_HOMES_PATH_DEST & Request.Form("login")

dirMoveTree ADMIN_PROFILES_PATH_SOURCE & Request.Form("login"),ADMIN_PROFILES_PATH_DEST & Request.Form("login")



' Applications des ACLs, en arriere plan car ca peut etre long !

Response.Write("
Creation du script d'application des ACLs C:\Inetpub\wwwroot\techcity\xcacls_" & Request.Form("login") & ".cmd

")

Set server_shell = Server.CreateObject("wscript.shell")



server_shell.Run "cmd /c echo echo Excecution Cacls >C:\Inetpub\wwwroot\techcity\xcacls_" & Request.Form("login") & ".cmd 2>&1",,1

server_shell.Run "cmd /c echo xcacls.exe """ & ADMIN_HOMES_PATH_DEST & Request.Form("login") & """ /T /C /G SYSTEM:F ADMINISTRATORS:F FR-ERM\" & Request.Form("login") & ":C /Y >>C:\Inetpub\wwwroot\techcity\xcacls_" & Request.Form("login") & ".cmd 2>&1",,1

server_shell.Run "cmd /c echo xcacls.exe """ & ADMIN_PROFILES_PATH_DEST & Request.Form("login") & """ /T /C /G SYSTEM:F ADMINISTRATORS:F FR-ERM\" & Request.Form("login") & ":F /Y >>C:\Inetpub\wwwroot\techcity\xcacls_" & Request.Form("login") & ".cmd 2>&1",,1



' server_shell.Run "C:\Inetpub\wwwroot\techcity\xcacls.cmd >C:\Inetpub\wwwroot\techcity\xcacls.log 2>&1",,1

Response.Write("
Les ACLs seront appliquee dans 5 min (scheduled)...

")

Response.Write("Attendre egalement la fin de replication de AD ...

")



Response.Write("
Terminé !
")



%>

<% Response.Write("

" & "Cliquer ICI pour quitter" & "
") %>



<%

End If

%>

Simple ASP page to reset passwords

bouffon69 (Sylvain Le Courtois) — Thu, 20 Sep 2007 07:01:29 GMT

// This page allows to reset an AD account password.



Reinitialisation de mot de passe

href="files/v2006.css" type=text/css rel=stylesheet>







border=0>



  
  
    

      




        
        
                      width=160> 
          

                        border=0>










              
              
                

                <%

                If Request.Form("login") = "" Then

                	Response.Write("Saisir le compte à reinitialiser")

                Else

                    Dim Group, Member, Domain, UserFound

                    ' 

                    Domain ="FR-ERM"

                    '

                    UserFound=0

                    

	                Set Group = GetObject("WinNT://" & Domain & "/Domain Users")

    	            For Each Member In Group.Members

    	            	' Response.Write(Member.Name & "
")

        	        	If UCase(Member.Name) = UCase(Request.Form("login")) Then

        	        		UserFound=1

        	        		If Member.AccountDisabled Then 

        	        			Response.Write(" " & Request.Form("login") &" est un compte desactive")

        	        			Exit For

        	        		Else

        	        			' Essai de reinit de mot de passe

        	        			Dim res

        	        			res=Member.SetPassword(Request.Form("pass"))

        	        			'Member.Put "pwdLastSet", CLng(0)

        	        			Member.Put "PasswordExpired", 1

								Member.SetInfo

        	        			Response.Write("L'utilisateur "& Request.Form("login") & " a changé de mot de passe !

Il devra changer de mot de passe au prochain login.")

        	        			Exit For

        	        		End If

        	        	End If 

            	    Next      

       	        	If UserFound = 0 Then

       	        		Response.Write(Request.Form("login") &" non trouvé dans le domaine "& Domain)

       	        	End If           	            	

                	

                End If

                %>

              

                
              
                Identifiant

               

                
                Nouveau mot de passe
              
                

 

                
                                  name=pass> 
                                  src="files/submit.gif" value=login border=0 name=ok>