preload

Taking snapshot of a folder structure

Posted by Albert Gareev on Jul 08, 2010
0
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 […] ...

Checking structure of created folders (Excel/VBA)

Posted by Albert Gareev on May 05, 2010
1
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 […] ...

Creating folder structure from a template (Excel/VBA)

Posted by Albert Gareev on May 03, 2010
0
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 […] ...

SetACL command line automation examples

Posted by Albert Gareev on Apr 29, 2010
0
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 […] ...

Active Directory Scripting – a little trick for ...

Posted by Albert Gareev on Apr 13, 2010
2
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 […] ...

Active Directory Scripting – Security Group ...

Posted by Albert Gareev on Mar 11, 2010
0
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 […] ...

Active Directory Scripting – find User Account

Posted by Albert Gareev on Mar 09, 2010
0
  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 […] ...

Active Directory Scripting – modify Attributes

Posted by Albert Gareev on Mar 01, 2010
0
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, […] ...

Active Directory Scripting – create Security Group

Posted by Albert Gareev on Feb 18, 2010
1
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 […] ...

Active Directory Scripting – create User Account

Posted by Albert Gareev on Feb 16, 2010
0
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 […] ...

Active Directory – Sample Scripts (Excel/VBA)

Posted by Albert Gareev on Feb 14, 2010
1
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 […] ...

Active Directory Scripting – retrieve Security Group

Posted by Albert Gareev on Feb 12, 2010
0
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 […] ...

Active Directory Scripting – retrieve User ...

Posted by Albert Gareev on Feb 11, 2010
4
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 […] ...

Active Directory Scripting – retrieve ...

Posted by Albert Gareev on Feb 10, 2010
0
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 […] ...

IT Infrastructure Maintenance: Introduction

Posted by Albert Gareev on Feb 09, 2010
0
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 […] ...
Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported
This work by Albert Gareev is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported.