Get CQData with Powershell

Question

Hello

Hope you are all well.

I have written a Powershell Script to pull out some information

$D= @(

"AllStreams.Second UPN"

"AllStreams.Second Client App Version"

"AllStreams.Second OS Filtered"

)

$M= @(

"Measures.Total Call Count"

)

$MY="2023-12"

$OPFP="Drive\cqdResult.csv"

$data=Get-CQDData -Dimensions $D -Measures $M -OutPutType CSV -OutPutFilePath $OPFP -LargeQuery -MonthYear $MY -OverWriteOutput

There are 2 questions. Not all data gets pull out

• If I run exact the same script it only with the Dimension "AllStreams.Second UPN" without the other 2 Dimensions I get much more UPN.
• I would need the last logon for the UPN

Thank you very much
JFM_12