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 27, 2010
I found SetACL tool very handy. In addition to implementation of security settings in batch files (that’s what it was created for), I quite successfully used it in automation of infrastructure maintenance and testing jobs that occure daily and even hourly. As any command line tool, powerful but simple, it requires instructions written in its […] ...
Posted by Albert Gareev on Apr 22, 2010
Imagine an intelligent and emotional robot sitting next to you, helping you to drive through a city traffic, and even remembering your driving habits. Does it sound like a sci-fi to you? Well, not anymore. Meet AIDA – Affective Intelligent Driving Agent AIDA communicates with the driver through a small robot embedded in the dashboard. “AIDA builds […] ...
Posted by Albert Gareev on Apr 20, 2010
If on your project you are not restricted to using Microsoft only toolkit in your system administration, testing, or automation work, you may want to try SetACL as an alternative to CACLS. It has some more advanced features, especially when it comes to setting allowance of inheritable permissions. Area of use Security Configuration Assessment and Management, […] ...
Posted by Albert Gareev on Apr 14, 2010
Here is yet another discussion about automated testing, and whether it’s purely checking or some more, that Arjan Kranenburg published on his web-site. (You may also want to read Matt Heusser’s “How are you going to *test* that?” Update: the link is no longer valid. STP web-site closed public access to the blogs hosted there.) I posted my comments […] ...
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 Apr 08, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Question The question was asked here. How can I get data from Excel spreadsheet if it is accidentally open? It ruins whole batch execution. While opening manually I can go “read-only” and still access it. Is there any way to read data from an open and locked […] ...
Posted by Albert Gareev on Apr 07, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers Description Connect to Excel through COM – Open workbook – Check property. ...
Posted by Albert Gareev on Apr 06, 2010
Peeling an Onion Code In my previous post I presented code structure looking like layers of an onion. In this post I’m exploring ways to transform it to structures that have much less drawback while performing same (or richer) functionalities. Let’s begin from the very first issue: readability of an Onion Code. Generally speaking, test steps are […] ...
Posted by Albert Gareev on Apr 01, 2010
A few facts to now Most of cell phones now come with a built-in GPS receiver hardware unit and GPS tracking software module. Basically, you can assume that any smart phone whether it’s Blackberry, iPhone, or Nokia, (or whatever) model has it, and it’s turned ON by default. A GPS tracking equipped cell phone can precisely […] ...
