I came up with this, but not sure how to get 1 hour time frames from the data. I want to see how many times in an hour for a...

Looks like if I add this in my query logic I'm getting the datetime desired

DATEADD(s,t_stamp/1000,'1969-12-31 20:00:00')

2024-02-01 01:00:00.000

2024-02-01 01:00:01.000

Struggle with doing the count of records per TagID within the hour that...

I would like just a query.

Yes -- Is it Unix epoch milliseconds?    Convert-DATETIME

A report that shows timespan of the analysis and then total for the TagID then Unique and Nonunique(differnt value)

There where 800 captures and 750 all had same value and, in...

yes, it submitted twice

Thanks for info.

1. yes
2. Can't find a good example.

   Thanks.

Thanks worked nice.

$source="c:\fileloading" #location of starting directory
$destination="c:\filecopy"; #location where files will be copied to
$files=@("*dys_ihhist*")

Get-ChildItem -recurse ($source) -include ($files) | Copy-Item -Destination ($destination + ($file.BaseName + "_" + (Get-Date -Format...

Thats maybe the issue I don't want a new directory just copy files from Source that conatain "$files=@("*dys_ihhist*")"

in there file name to DEST

Before:

dys_ihhist.txt  --> found on Source

Copy to Dest

dys_ihhist_072023.txt

Thanks Jeff.. correct on incorporating the solution.  I don't want a NEW folder created just a MMYYYY inserted into filename as it's copied to Dest folder.

Thanks again.

Any help getting this to work?

THanks.

I'm just trying to copy file with new MMYYYY into the folder filecopy

$source="c:\fileloading" #location of starting directory
$destination="c:\filecopy"; #location where files will be copied to
$files=@("*dys_ihhist*")

New-Item -ItemType Directory -Force -Path ($destination); Get-ChildItem -recurse ($source) -include ($files) | Copy-Item -Destination ($destination +...