I want to download start-histricalsearch data with powershell

Question

I want to download start-histricalsearch data with powershell

tarou chabi 731

Is there a way to download the information obtained by start-histricalsearch with Powershell?
I want to download as a CSV file as if I downloaded with GUI. Or I want to automate the download process with .bat etc.

Joy Zhang-MSFT 1,051 Reputation points

2022-02-03T06:40:08.223+00:00

Hi @tarou chabi ,

As AndreasBaumgarten has replied, it seems cannot download them via PowerShell, this point has been mentioned in a similar thread and there is a detailed explanation on it for your reference.
"You cannot download them via PowerShell, use the UI. Technically, you can get the download URL once the trace has completed, but in order to access it you need a valid token. Which in PowerShell is a bit tricky to achieve, especially if you are not using the MFA-enabled method".
tarou chabi 731 Reputation points

2022-02-03T08:32:25.64+00:00

Thanks a lot!!!!! I understood........

Accepted answer

1 additional answer

Your answer

Joy Zhang-MSFT 1,051 Reputation points

2022-02-03T06:40:08.223+00:00

Hi @tarou chabi ,

As AndreasBaumgarten has replied, it seems cannot download them via PowerShell, this point has been mentioned in a similar thread and there is a detailed explanation on it for your reference.
"You cannot download them via PowerShell, use the UI. Technically, you can get the download URL once the trace has completed, but in order to access it you need a valid token. Which in PowerShell is a bit tricky to achieve, especially if you are not using the MFA-enabled method".
tarou chabi 731 Reputation points

2022-02-03T08:32:25.64+00:00

Thanks a lot!!!!! I understood........

Answer 1

Andreas Baumgarten 123.9K MVP Volunteer Moderator

Hi @tarou chabi ,

maybe this helps to get it started:

$url = Get-HistoricalSearch -JobId xyz1234 | Select-Object FileUrl  
Invoke-WebRequest $url -OutFile "c:\junk\test.csv"

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

tarou chabi 731 Reputation points

2022-02-02T15:53:29.363+00:00

Thanks alot. But, I have already run an Invoke-WebRequest, but the downloaded information was not the message tracking information.
Andreas Baumgarten 123.9K Reputation points MVP Volunteer Moderator

2022-02-02T20:16:38.81+00:00

Hi @tarou chabi ,

please take a look here:

https://www.michev.info/Blog/Post/2860/expanding-the-functionality-of-the-start-historicalsearch-cmdlet

It sounds like i's not possible to get the download via PowerShell.

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten
tarou chabi 731 Reputation points

2022-02-03T03:40:36.267+00:00

Thank you very much. Is there any other way to download it?

Answer 2

@tarou chabi
Hi

Let's say $mySearch = Get-Get-HistoricalSearch | Where-Object {some condition}.
maybe, $_.ReportTitle.StartsWith('blah') or $__.NotifyAddress -contains '******@domain.com' you get the picture.
Then you could just loop as follows:

$mySearch |Foreach-Object {Start-Process <path to your browser app. For me it's msedge> 
-ArgumentList $_.FileUrl }

you will get $mySearch.Count save scv prompt windows as the one you get when you click on 'Download the report'. This will save you one click for each one.

It's also better to login to your admin account before running this loop as you will need to login and reload the others before timing out.

you could add to ArgumentList '--inprivate' for msedge or '--incognito' for chrome.

Hope this helps.

Share via

I want to download start-histricalsearch data with powershell

1 additional answer

Your answer