Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Data is getting truncated in exported file (.xls/.txt/.xlsx/.csv

  1. #11
    Thanks for your last reply. It appears that Exporter Pro does not support translating the 'msDS-userpasswordexpirytimecomputed' into an actual date. We will fix this on the next update.

    As for the 'pwdlastset' vs %SYM_AD_PWD_AGE%, I copied all of the accounts with a pwdlastset and the value of %SYM_AD_PWD_AGE% into Excel, and created a new column with the formula =Today-A1, and the results we the same as our calculation, rounded up or down accordingly.

    I also checked and in Hyena v8.8 the calculation has not changed. The 'pwdlastset' is coming directly from AD, and Hyena bases the calculation of the password age based on the same attribute value 'pwdlastset'.
    Kevin Stanush
    SystemTools Software Inc.

  2. #12
    Please add both pwdlastset and %SYM_AD_PWD_AGE% to an AD query, and run that for all of your users. Then, sort on the pwdlastset column and select all of the accounts that have a date in that column, and Edit > Copy the pwdlastset and %SYM_AD_PWD_AGE% to the clipboard, paste into a file, and email that to I'll put into Excel. Make sure a TAB is set as the field delimiter. I just need those two columns, nothing else. Hyena uses a Microsoft function to calculate this difference, so I don't know why it would be off, even considering time zone and DST settings.
    Kevin Stanush
    SystemTools Software Inc.

  3. #13
    Also, check to see if the date/time displayed for pwdlastset is the same in Hyena as Exporter Pro for a couple of accounts. I wanted to make sure the date functions are returning the same value.
    Kevin Stanush
    SystemTools Software Inc.

Similar Threads

  1. Data truncated when copying event log description
    By pprasad in forum Reporting, Exporting, and Printing
    Replies: 3
    Last Post: 02-08-2011, 08:14 AM
  2. Replies: 1
    Last Post: 04-09-2010, 09:06 AM
  3. Exchange Features Exported
    By MarshaK in forum Exchange Integration
    Replies: 1
    Last Post: 01-28-2008, 01:03 PM
  4. Exporter Pro "Unable to open 'Output File' file"
    By Dee in forum Managing Users - General
    Replies: 1
    Last Post: 06-13-2006, 12:50 PM
  5. Missing exported data
    By Braunyaur in forum Reporting, Exporting, and Printing
    Replies: 5
    Last Post: 09-29-2003, 07:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts