Powershell help - export to CSV not working - exporting EXE version number - help required...

gower666 

Hi, Gary.

Please ensure you post sample code in a code box, as it's impossible to make sense of when it's dumped as unformatted text in the thread. This is what the second script looks like after posting:

And when that wall of text is copied-and-pasted into an IDE, it comes through as a single line, which is just as unreadable - particularly if the semicolon hasn't been used to demarcate separate commands.

Moving onto your new question, you can easily piggyback off the example scripts above.

While I'm not a fan of the SMB approach as it's slow and doesn't scale well, here's a modified SMB example that gives you the creation and modification timestamps.

For the creation and modification dates, we're simply grabbing them from the existing file object returned from Get-Item.

I've also demonstrated how you can check multiple files through pre-pending a string array in front of the Get-Item, where the relative file paths are specified as separate strings.

There's other, neater ways this can done, but by sticking as close as is possible to the original scripts above, I'm hoping it helps understand the concepts underpinning the changes, the most important being that you're working with objects.

Before getting into the example script, notice how there's multiple timestamps to choose from on the file objects returned by Get-Item? This data is what we're going to leverage.

Example

$ExportPath = "D:\Data\Temp\forum\fileInfo.csv";

Get-Content -Path "D:\Data\temp\forum\forum.txt" |
    ForEach-Object {
        $Name = $_;

        @(
            "c$\Data\SteamSetup.exe"
            , "c$\Data\query.txt"
            , "c$\Data\secedit.inf"
        ) |
            ForEach-Object {
                Get-Item -Path "\\$Name\$_" -ErrorAction:SilentlyContinue |
                    ForEach-Object {
                        [PSCustomObject] @{
                            Version = $_.VersionInfo.FileVersion;
                            WhenCreated = $_.CreationTime;
                            WhenChanged = $_.LastWriteTime;
                            FileName = $_.VersionInfo.FileName;
                        }
                    }
            }
    } |
        Export-Csv -Path $ExportPath -NoTypeInformation;

Output

Cheers,

Lain