NetFlow detail records retrieved using PowerShell and Orion SDK appear to contain duplicates.
Granularity of Orion.Netflow.Flows.ObservationTimestamp appears to be minutes not seconds, and this appears to be creating duplicate records.
If granularity of Orion.Netflow.Flows.ObservationTimestamp is not the issue then why are we retrieving duplicate records.
...
SELECT
f.ObservationTimestamp
, ...
FROM
Orion.Netflow.Flows f
WHERE
f.ObservationTimestamp >= @BeginDate
AND
f.ObservationTimestamp < @EndDate
ORDER BY
f.ObservationTimestamp ASC
...
$rs |
select @{n='ObservationTimestamp';e={$_.ObservationTimestamp.ToString("yyyy-MM-dd HH:mm:ss.fff")}},ot,
... |
Export-CSV -NoTypeInformation $AttachmentPath
P.S.
Beware: apparently SolarWinds support cannot or will not answer such questions. Not sure why we are paying for support!