lordmilko
commented
1 year ago Hi @MPrica12,
When you look on the logs tab of the sensor in PRTG, how many instances of the sensor being in status "Down" does it show between April 1st and May 31st?
I would also note when you want to analyze sensor outages, the best way to do this is to generate a historical report, not look at the object event logs. You can obtain the same information you get by doing a historical report in the PRTG UI using the -Report parameter of Get-SensorHistory as documented here
MPrica12
What's going on?
Hello,
I'm trying to create an export of all of the instances each sensors went down from an .xlsx file in the last 2 months
I'm not sure what the issue is but when I try to make an export from PRTG using the API and following the documentation in the Get-ObjectLog section the data being pulled in the export is only from the last 3 days, as those are the only instances when the sensors seems to have went down, which is impossible as we are sure some of those sensors went down in more times in the last 2 months. Am I configuring something wrong in my script?
$EndDate = Get-Date -Day 1 -Month 4 -Year 2023 $StartDate = Get-Date -Day 31 -Month 5 -Year 2023
$Xls = Import-Excel "C:\Monitoring_documents\Files_work\test.xlsx"
$export = foreach($line in $Xls.Id){ Write-Host "Processing sensor " $line $Logs = Get-Sensor -id $line | Get-ObjectLog -StartDate $StartDate -EndDate $EndDate -Status Down $Logs | Select-Object DateTime, Id, Name, Status, Message Write-Host "Found sensor with down status in the period with ID " $Logs.Id start-sleep 2 }
$export | Export-Csv C:\Monitoring_documents\Files_work\Sensors_down_updated.csv
Due Dilligance