SQL: conditional statements in select queries using case

When you need conditional statements in an SQL query, for instance to do some date calculation within the SELECT statement, you can do:

Lees meer

ADSI: error 8250 "the server is not operational"

This error can be generated when the domain controller you use in scripting suffers from sub-optimal performance. In bulk scripts when lots of requests are done on a single domain controller, ADSI can generate this error. If the domain controller you are using is virtualized, try performing the same operation on a physical domain controller.

Lees meer

LDAP: how-to bind to Active Directory

When using scripts and Active Directory, there are several ways to connect to a domain or forest:

Lees meer

LDAP: managing exchange features using protocolsettings attribute

Active Directory stores the contents of the "Exchange features" tab in various attributes. The protocol settings for Outlook Web Access, POP3 and IMAP4 are stored in the attribute "protocolSettings" (multi-valued). If you leave everything to default, this attribute is not populated for new user accounts. If you change a setting this attribute will get a value.

Lees meer

UMRA: have unit managers create their own temporary employees

Usually when a new employee enters the company, operations will receive a request for a new user account. When an external or temporary employee needs a user account, usually the unit manager will know the details only a few days in advance. Therefore it is a good idea to give the unit manager a secure form-based method of creating temporary user accounts. UMRA Forms is the solution:

Lees meer