Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.
-
jorgepino #1
Ldap dates
I am trying to read the following variable as regular time
pass last set :: #pwdLastSet# :: 127554714130781250
Pass last logon :: #lastLogon# :::127554715379088523
account Expires :: #accountExpires# ::: 9223372036854775807
is there something i can use to make them readable (dd/mm/yy)?
thanks
jorgepino Guest
-
Between Dates
I am trying to query an online access database and return records that have occurred between dates. I am using another query which does work to... -
ASP/VBS Dates Between Dates
I'm trying to filter records depending on 2 dates requested from the querystring MMColParam1 (startdate) and MMColParam2 (enddate), i.e. a list... -
Dates again
Hello all I'm having trouble getting iis to understand the UK format of dates ASP off a MS Access database I have the following query:... -
Dates
Thanks to all those who replied. I ended up doing some research myself and found a good date module at... -
Help with Dates please
Hi, In a SQL table I have a field named departure and a date in inserted in it. What is the exact syntax to get only records with a future date... -
Michael #2 Re: Ldap dates
There are a couple of related bits of code. Some near the top setting the date
offset, then the formula near the bottom. It's not as perfect as I would like,
but it gets me close.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<style>
body, td { font-family: Arial; font-size: 12px; }
</style>
<title>Account Dump</title>
</head>
<body onLoad="document.Search.Criteria.select();">
<cfset ThisPage = GetFileFromPath(CGI.Script_Name)>
<!--- This is an arbitrary date chosen as the "base" of date calculation. --->
<cfset DatumDate = CreateDate(2000, 1, 1)>
<!--- This values equates to the number of seconds from when Windows begins
--->
<!--- time calculations. This actual value equates to the date of 1/1/2000.
--->
<cfset DatumOffset = 12591266400>
<cfparam name="Form.Criteria" default="">
<cfparam name="Form.ServerName" default="ueDC01">
<cfoutput>
<form action="#ThisPage#" method="post" name="Search">
<select name="ServerName" size="2">
<option value="DC01"<cfif Form.ServerName is "DC01">
SELECTED</cfif>>DC01</option>
<option value="DC02"<cfif Form.ServerName is "DC02">
SELECTED</cfif>>DC02</option>
</select>
<input type="text" name="Criteria" value="#Trim(Form.Criteria)#"><br>
<input type="submit" name="BtnDump" value="Dump Domain Data">
</form>
</cfoutput>
<cfif Len(Trim(Form.Criteria))>
<cfset StartOU="dc={DOMAIN}, dc={COM}">
<cfset AttArray = ArrayNew(1)>
<cfset ArrayAppend(AttArray, "accountExpires")>
<cfset ArrayAppend(AttArray, "adminCount")>
<cfset ArrayAppend(AttArray, "apple-mcxflags")>
<cfset ArrayAppend(AttArray, "apple-user-homeDirectory")>
<cfset ArrayAppend(AttArray, "apple-user-homeurl")>
<cfset ArrayAppend(AttArray, "altRecipientBL")>
<cfset ArrayAppend(AttArray, "authOrigBL")>
<cfset ArrayAppend(AttArray, "autoReplyMessage")>
<cfset ArrayAppend(AttArray, "badPasswordTime")>
<cfset ArrayAppend(AttArray, "badPwdCount")>
<cfset ArrayAppend(AttArray, "ciscoEcsbuDtmfId")>
<cfset ArrayAppend(AttArray, "ciscoEcsbuListInUMDirectory")>
<cfset ArrayAppend(AttArray, "ciscoEcsbuObjectType")>
<cfset ArrayAppend(AttArray, "ciscoEcsbuTransferId")>
<cfset ArrayAppend(AttArray, "ciscoEcsbuUndeletable")>
<cfset ArrayAppend(AttArray, "cn")>
<cfset ArrayAppend(AttArray, "co")>
<cfset ArrayAppend(AttArray, "company")>
<cfset ArrayAppend(AttArray, "codePage")>
<cfset ArrayAppend(AttArray, "countryCode")>
<cfset ArrayAppend(AttArray, "deletedItemFlags")>
<cfset ArrayAppend(AttArray, "deliverAndRedirect")>
<cfset ArrayAppend(AttArray, "department")>
<cfset ArrayAppend(AttArray, "directReports")>
<cfset ArrayAppend(AttArray, "displayName")>
<cfset ArrayAppend(AttArray, "distinguishedName")>
<cfset ArrayAppend(AttArray, "dLMemDefault")>
<cfset ArrayAppend(AttArray, "dSCorePropagationData")>
<cfset ArrayAppend(AttArray, "extensionAttribute1")>
<cfset ArrayAppend(AttArray, "extensionAttribute2")>
<cfset ArrayAppend(AttArray, "extensionAttribute3")>
<cfset ArrayAppend(AttArray, "extensionAttribute4")>
<cfset ArrayAppend(AttArray, "extensionAttribute5")>
<cfset ArrayAppend(AttArray, "extensionAttribute6")>
<cfset ArrayAppend(AttArray, "extensionAttribute7")>
<cfset ArrayAppend(AttArray, "extensionAttribute8")>
<cfset ArrayAppend(AttArray, "extensionAttribute9")>
<cfset ArrayAppend(AttArray, "extensionAttribute10")>
<cfset ArrayAppend(AttArray, "extensionAttribute11")>
<cfset ArrayAppend(AttArray, "extensionAttribute12")>
<cfset ArrayAppend(AttArray, "extensionAttribute13")>
<cfset ArrayAppend(AttArray, "extensionAttribute14")>
<cfset ArrayAppend(AttArray, "extensionAttribute15")>
<cfset ArrayAppend(AttArray, "facsimileTelephoneNumber")>
<cfset ArrayAppend(AttArray, "garbageCollPeriod")>
<cfset ArrayAppend(AttArray, "givenName")>
<cfset ArrayAppend(AttArray, "homeDirectory")>
<cfset ArrayAppend(AttArray, "homeDrive")>
<cfset ArrayAppend(AttArray, "homeMDB")>
<cfset ArrayAppend(AttArray, "homeMTA")>
<cfset ArrayAppend(AttArray, "homePhone")>
<cfset ArrayAppend(AttArray, "ipPhone")>
<cfset ArrayAppend(AttArray, "info")>
<cfset ArrayAppend(AttArray, "initials")>
<cfset ArrayAppend(AttArray, "instanceType")>
<cfset ArrayAppend(AttArray, "l")>
<cfset ArrayAppend(AttArray, "lastLogoff")>
<cfset ArrayAppend(AttArray, "lastLogon")>
<cfset ArrayAppend(AttArray, "legacyExchangeDN")>
<cfset ArrayAppend(AttArray, "logonCount")>
<cfset ArrayAppend(AttArray, "mail")>
<cfset ArrayAppend(AttArray, "mailNickname")>
<cfset ArrayAppend(AttArray, "managedObjects")>
<cfset ArrayAppend(AttArray, "manager")>
<cfset ArrayAppend(AttArray, "mAPIRecipient")>
<cfset ArrayAppend(AttArray, "mDBOverHardQuotaLimit")>
<cfset ArrayAppend(AttArray, "mDBOverQuotaLimit")>
<cfset ArrayAppend(AttArray, "mDBStorageQuota")>
<cfset ArrayAppend(AttArray, "mDBUseDefaults")>
<cfset ArrayAppend(AttArray, "memberOf")>
<cfset ArrayAppend(AttArray, "mobile")>
<cfset ArrayAppend(AttArray, "msExchADCGlobalNames")>
<cfset ArrayAppend(AttArray, "msExchALObjectVersion")>
<cfset ArrayAppend(AttArray, "msExchHideFromAddressLists")>
<cfset ArrayAppend(AttArray, "msExchHomeServerName")>
<cfset ArrayAppend(AttArray, "msExchPoliciesExcluded")>
<cfset ArrayAppend(AttArray, "msExchPoliciesIncluded")>
<cfset ArrayAppend(AttArray, "msExchRecipLimit")>
<cfset ArrayAppend(AttArray, "msExchUserAccountControl")>
<cfset ArrayAppend(AttArray, "msNPAllowDialin")>
<cfset ArrayAppend(AttArray, "msRADIUSCallbackNumber")>
<cfset ArrayAppend(AttArray, "msRADIUSServiceType")>
<cfset ArrayAppend(AttArray, "name")>
<cfset ArrayAppend(AttArray, "objectCategory")>
<cfset ArrayAppend(AttArray, "objectClass")>
<cfset ArrayAppend(AttArray, "otherFacsimileTelephoneNumber")>
<cfset ArrayAppend(AttArray, "otherHomePhone")>
<cfset ArrayAppend(AttArray, "otherIpPhone")>
<cfset ArrayAppend(AttArray, "otherMobile")>
<cfset ArrayAppend(AttArray, "otherPager")>
<cfset ArrayAppend(AttArray, "otherTelephone")>
<cfset ArrayAppend(AttArray, "pager")>
<cfset ArrayAppend(AttArray, "physicalDeliveryOfficeName")>
<cfset ArrayAppend(AttArray, "postalCode")>
<cfset ArrayAppend(AttArray, "postOfficeBox")>
<cfset ArrayAppend(AttArray, "primaryGroupID")>
<cfset ArrayAppend(AttArray, "profilePath")>
<cfset ArrayAppend(AttArray, "proxyAddresses")>
<cfset ArrayAppend(AttArray, "pwdLastSet")>
<cfset ArrayAppend(AttArray, "replicatedObjectVersion")>
<cfset ArrayAppend(AttArray, "sAMAccountName")>
<cfset ArrayAppend(AttArray, "sAMAccountType")>
<cfset ArrayAppend(AttArray, "scriptPath")>
<cfset ArrayAppend(AttArray, "showInAddressBook")>
<cfset ArrayAppend(AttArray, "sn")>
<cfset ArrayAppend(AttArray, "st")>
<cfset ArrayAppend(AttArray, "streetAddress")>
<cfset ArrayAppend(AttArray, "telephoneNumber")>
<cfset ArrayAppend(AttArray, "textEncodedORAddress")>
<cfset ArrayAppend(AttArray, "title")>
<cfset ArrayAppend(AttArray, "uidNumber")>
<cfset ArrayAppend(AttArray, "url")>
<cfset ArrayAppend(AttArray, "userAccountControl")>
<cfset ArrayAppend(AttArray, "userParameters")>
<cfset ArrayAppend(AttArray, "userPrincipalName")>
<cfset ArrayAppend(AttArray, "uSNChanged")>
<cfset ArrayAppend(AttArray, "uSNCreated")>
<cfset ArrayAppend(AttArray, "whenChanged")>
<cfset ArrayAppend(AttArray, "whenCreated")>
<cfset AttList = ArrayToList(AttArray)>
<cfldap
action="query"
name="Results"
start="#StartOU#"
scope="subtree"
attributes="#AttList#"
filter="(&(objectClass=user)(sAMAccountName=#Form. Criteria#))"
separator = "|"
server="#Form.ServerName#"
port="389"
username="{USERNAME}"
password="{PASSWORD}">
<p>Domain Controller: <cfoutput>#ServerName#</cfoutput></p>
<cfloop from="1" to="#ArrayLen(AttArray)#" index="ThisOne">
<cfset ThisValue = Replace(Results[AttArray[ThisOne]][1], "|", "<br>",
"All")>
<strong><cfoutput>#AttArray[ThisOne]#</cfoutput></strong><br>
<cfif Len(Trim(ThisValue))><cfoutput><span style="color:
##cc0000;">#ThisValue#</span></cfoutput><cfelse><span style="color:
#aaaaaa;">[no value defined]</span></cfif>
<cfif IsNumeric(ThisValue) and Len(ThisValue) eq 18>
<!--- Pull the first 11 digits of the time value. This gets us down to
seconds. --->
<cfset Offset = Left(ThisValue, 11)>
<!--- Get the difference between the datum value and the current value. --->
<!--- Add 86400 to add another day to the value for the correct result. --->
<cfset DiffSeconds = (Offset - DatumOffset) + 86400>
= Converted Date: <cfoutput>#DateAdd("s", DiffSeconds,
DatumDate)#</cfoutput>
</cfif>
<br>
</cfloop>
</cfif>
</body>
</html>
Michael Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
