Posted by Albert Gareev on Jul 08, 2010
In the Checking structure of created folders example I used a text file as a source, containing manually prepared folder names to check for. Today I want to show how file/folder structure could be captured automatically. Data Record Declaration For this example, data will be stored in Dictionary object serving as a dynamic array of records. Sample file […] ...
Posted by Albert Gareev on May 05, 2010
In the previous post I warned about possible synchronization issues while copying a complex and/or large file-folder structure. To ensure reliability of the operation performed we may verify the structure that was created. We need to answer the following questions before designing the script. Which folders and files should it verify? Which way should it […] ...
Posted by Albert Gareev on May 03, 2010
How to create a complex folder structure by using a template In the previous post I provided code example that creates a folder and then applies security permissions on it. However, as per requirements, user folders often come with a predefined structure of folders and some files created by default. Sure, we can write script […] ...
Posted by Albert Gareev on Apr 29, 2010
In this post I provide code snippets for SetACL tool command line automation. Examples of command line instructions were taken from here. The code presented below is written in VBA for MS Excel. CreateUserFolder function can create folders on a local or network drive. After user folder is created, the function sets typical access permissions by […] ...
Posted by Albert Gareev on Apr 13, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) While processing User Account put the following code in the beginning of operations to disable it. And enable it back once you’re successfully done. This way, in case of an unhandled exception that breaks execution of a script, any User Account that wasn’t properly processed will remain […] ...
Posted by Albert Gareev on Mar 11, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) Description The function below is used to clear group membership for a user account. The account is removed from all groups except recognized ones . By default, “Users” and “Domain Users” are in the list. The function can be easily modifed to recognize and process membership based on […] ...
Posted by Albert Gareev on Mar 09, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) Description The function below performs 1-layer deep search of User Account object in all Organizational Units contained under parent Organizational Unit. The function can be easily modified for a recursive search if children OU hierarchy is unknown. Use objUser.Get(“distinguishedName”) to retrieve full LDAP path of found […] ...
Posted by Albert Gareev on Mar 01, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to modify Attributes of an Object Introduction In Microsoft Active Directory Object Classes have Attributes representing additional information about an object. It could be Firstname, Lastname – for a person, Address and Phone number both for a person and organization. Access to Attributes is performed through LDAP calls, […] ...
Posted by Albert Gareev on Feb 18, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to create Security Group Description Security Group object could be created within its container object – Organizational Unit. The example below is based on the assumption that we successfully retrieved an instance of Organizational Unit. An existing User Account will also be added to the newly […] ...
Posted by Albert Gareev on Feb 16, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to create User Account Description User Account object could be created within its container object – Organizational Unit. The example below is based on the assumption that we successfully retrieved an instance of Organizational Unit. Note. You need to login as an authorized person to successfully execute […] ...
Posted by Albert Gareev on Feb 14, 2010
Basic Active Directory Queries How to retrieve Organizational Unit How to retrieve User Account How to retrieve Security Group Working with Active Directory Objects How to create User Account How to create Security Group How to modify Attributes of an Object Advanced Active Directory Queries Processing Security Group Membership for User Account Search for User […] ...
Posted by Albert Gareev on Feb 12, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to retrieve Security Group Description Build LDAP Query – Execute Query – Catch Errors Note. You need to login as an authorized person to successfully execute the script. Common definitions How to retrieve Active Directory Security Group (Excel/VBA source code) Note that Security Group is an object […] ...
Posted by Albert Gareev on Feb 11, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to retrieve User Account Description Build LDAP Query – Execute Query – Catch Errors Note. You need to login as an authorized person to successfully execute the script. Common definitions How to retrieve Active Directory User Account (Excel/VBA source code) Note that we enlist directory tree nodes […] ...
Posted by Albert Gareev on Feb 10, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to retrieve Organizational Unit Description Build LDAP Query – Execute Query – Catch Errors Note. You need to login as an authorized person to successfully execute the script. Common definitions How to retrieve Organizational Unit (Excel/VBA source code) Note that we enlist directory tree nodes backwars when […] ...
Posted by Albert Gareev on Feb 09, 2010
Infrastructure – the basic, underlying composition of elements and their connections that form a system. In IT “infrastructure” is a layered definition. It includes electrical and communication lines, and equipment. It includes computer and networking hardware, as well as server and operating systems software. Common use application software is also a part of infrastructure. On […] ...