Databases
StackOverflow2013
Postsdbo
PODiscrepancy in Date Created attribute between Powershell script output and Windows Explorer
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODiscrepancy in Date Created attribute between Powershell script output and Windows Explorer
    primarykey
    data
    text
    <p>I wrote a simple powershell script that recursively walks a file tree and returns the paths of each node along with the time of its creation in tab-separated form, so that I can write it out to a text file and use it to do statistical analysis:</p> <pre><code>echo "PATH CREATEDATE" get-childitem -recurse | foreach-object { $filepath = $_.FullName $datecreated = $_.CreationTime echo "$filepath $datecreated" } </code></pre> <p>Once I had done this, however, I noticed that the CreationDate times that get produced by the script are exactly one hour ahead of what Windows Explorer says when I look at the same attribute of the same files. Based on inspecting the rest of my dataset (which recorded surrounding events in a different format), it's clear that the results I get from explorer are the only ones that fit the overall narrative, which leads me to believe that there's something wrong with the Powershell script that makes it write out the incorrect time. Does anyone have a sense for why that might be?</p> <p>Problem background:</p> <p>I'm trying to correct for a problem in the design of some XML log files, which logged when the users started and stopped using an application when it was actually supposed to log how long it took the users to get through different stages of the workflow. I found a possible way to overcome this problem, by pulling date information from some backup files that the users sent along with the XML logs. The backups are generated by our end-user application at the exact moment when a user transitions between stages in the workflow, so I'm trying to bring information from those files' timestamps together with the contents of the original XML log to figure out what I wanted to know about the workflow steps.</p> <p>Summary of points that have come out in comment discussion:</p> <ul> <li>The files are located on the same machine as the script I'm running (not a network store)</li> <li>Correcting for daylight savings and time zones has improved the data quality, but not for the specific issue posed in the original question.</li> </ul>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USestanford
    1. USestanford
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODiscrepancy in Date Created attribute between Powershell script output and Windows Explorer
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs there any correlation between Daylight Saving Time & Daylight Standard time and the reported timestamps being off? What if you convert them all to UTC (and convert the Explorer-displayed timestamps to UTC for comparison)? **EDIT:** I just tried your code on my system and things match up.
      singulars
      1. PODiscrepancy in Date Created attribute between Powershell script output and Windows Explorer
      1. USalroc
    2. COThe files I'm working with were all written in May-June, so I suppose it's possible that a daylight savings correction is sneaking in somewhere.
      singulars
      1. PODiscrepancy in Date Created attribute between Powershell script output and Windows Explorer
      1. USestanford
    3. COAre these files on a network share, or local?
      singulars
      1. PODiscrepancy in Date Created attribute between Powershell script output and Windows Explorer
      1. USalroc
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload