HP servicedesk: use sd_event to create and update items

HP ServiceDesk offers the sd_event command-line tool to interact with its database. Using classes and mappings inside HPSD, you can configure exactly how sd_event can create and/or update items the database. For instance, to create new person registrations from the command-line, first create and configure the class and mappings inside HPSD.

Lees meer

VBScript: create Exchange 5.5 mailbox using ADSI and LDAP

For the below script to work, you need the AcctCrt COM components to be installed. You can download this component form the Microsoft site. strDomainNT4 = "TOOLS4EVER" strUsername = "avdvorst" strEx55Server = "EXCHANGE" strMailboxPath = "DN of your recipient container" strSite = "Name of site" strOrg = "Name of organization"

Lees meer

Databases: oracle dump database table layout

In SQL Server there is a nice feature which lets you generate an SQL script from any database using the SQL Enterprise Manager. Oracle can do the same using sqlplusw:

Lees meer

Databases: date and time functions

Unfortunately databases don't all use the same SQL language. In most cases, the notation of SQL queries is roughly the same, however in some cases there are differences, for instance when working with dates and times:

Lees meer

AD: which attributes are stored in the global catalog?

The Global Catalog (GC) doesn't store all attributes. Refer to http://support.microsoft.com/kb/256938 for all default GC attributes in Windows 2000 Active Directory. You can easily check if an attribute is stored in the GC using ADExplorer or ADSIEdit. Look in the schema naming context and check if partialAttributeSet=TRUE.

Lees meer