Sources: http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/ http://www.sqlusa.com/bestpractices/datetimeconversion/
Author: David Kittell
Time ASP Execution
Source: http://classicasp.aspfaq.com/general/how-do-i-time-my-asp-code.html
Host File Update
Proxy Server host block list is now available at http://goo.gl/jXiOLp, make sure you do not use this in Windows host file. It’s a good idea to do this script in a directory that is specific to your host file project Make sure you chmod the shell script Mac OS X…
Delete Ektron User
In order to force a deletion from the Ektron user list you must follow the below path. DISCLAIMER: This will remove all content that was ever created/touched by the user.
LDAP Dates Converted
Dates that look like 127524839567199000 (pwdLastSet, accountExpires, lastLogonTimestamp, etc.) Example: 130186556607343750 converts to 40921.80861 40921.80861 in Excel with cell formatting of Date/Time will show as January 13th, 2012 7:24 PM Dates that look like 20050210223453.0Z (whenChanged) Example: 20080523192311.0Z in Excel with cell formatting of Date/Time will show as 7/18/2013 9:14…
LDIF Help
LDIF Directory Exchange General Parameters ================== -i Turn on Import Mode (The default is Export) -f filename Input or Output filename -s servername The server to bind to (Default to DC of computer’s domain) -c FromDN ToDN Replace occurences of FromDN to ToDN -v Turn on Verbose Mode -j path…
Exporting the Schema from the Source Forest
The LDIFDE command-line tool, which ships with Windows Server 2003 and Windows Server 2008, can be used to export the schema from the source forest. This tool creates a file that is formatted with the LDAP Data Interchange Format (LDIF). No special permissions are required to export the schema from…
Update Ektron License
After applying this update you will need to restart the services and in some case restart the server completely.
Ektron SQL – List All Users
If you’re looking for more specific access lists look at Ektron – User Access List