How do I modify account expiration dates in the UpdateWin2k spreadsheet?
How can I modify the AccountExpirationDate account expiration property for multiple user accounts?
Directory and Resource Administrator 7.x
The UpdateWin2k spreadsheet enables you to retrieve from Active Directory properties from various classes, such as Computer, Contact, Group, OU, and User. You can batch update multiple properties to Active Directory from this spreadsheet.
The Directory and Resource Administrator (DRA) SDK includes the UpdateWin2k spreadsheet. For more information about the DRA SDK, see NETIQKB311, What is the Software Development Kit (SDK) and what can it do?
To modify the expiration dates for user accounts listed in the
For each account with an expiration date you want to modify, change the value listed in the appropriate cell in the AccountExpirationDate column.
- You can set the AccountExpirationDate value using the Excel date/time format or you can supply the date as a unicode value.
- You can set the AccountExpirationDate value to Never Expire by entering a space or a zero (
0) in the cell.
- You can update the
UpdateWin2k.xlsfile manually or you can import values from another spreadsheet or csv file.