WPM: Current Screenshot location

The screenshots are stored in the database at dbo.Screenshots and SEUM_TransactionSteps However, WPM only keeps the current screenshot from the most recent poll. There is no history of the screenshots maintained. 

jvb that's not right, you've got loads of SSs captured for errors etc, only got to check the "Screenshots of Last 10 Failures" widget
s-bolyard

for followup s-bolyard if you need to you can output the screenshots as a byte array from the DB to some long term storage if you want and then there's some powershell or equivalent to turn that byte array back into a jpg

adam.beedell Good catch! I read and responded too quickly thinking s-bolyard was looking for the complete history of screenshots good or bad. Let me find the location of the images in the "last 10" widget and also see if we have any suggestions for extraction for longer term storage... The last 10 can cycle out quickly depending on the situation. 

Did some digging on the topic and it's interesting the difference between the SQL and SWQL structure. SWQL tells me i've got (at max) >2k screenshots for one transaction step, however I think in SQL this is because they're all the same.

in SWQL they're in tables under SEUM referencing "large" data

I happen to have messed with this a bit already and can confirm that export is fine, but i've been looking for a method to convert the byte array into an image such that it's embedded in an email and wouldn't require solarwinds auth. Would love it if you stumble across that.

This is the SWQL we have internally

SELECT TOP 1000 TransactionId, TransactionStepId, RecordingId, StepId,
TransactionSteps.Step.Name, WarningThreshold, CriticalThreshold, OptimalThreshold,
TransactionSteps.Transaction.LastDateTimeUtc, ScreenshotId, ScreenshotDateTimeUtc,
TransactionSteps.LargeData.Screenshot
FROM Orion.SEUM.TransactionSteps

SELECT TOP 1 TransactionId, TransactionStepId, DateTimeUtc, Duration, Status, ScreenshotId,
StepResponseTimeDetail.LargeData.Screenshot
FROM Orion.SEUM.StepResponseTimeDetail (nolock=true)
ORDER BY DateTimeUtc DESC

This is the SWQL we have internally

SELECT TOP 1000 TransactionId, TransactionStepId, RecordingId, StepId,
TransactionSteps.Step.Name, WarningThreshold, CriticalThreshold, OptimalThreshold,
TransactionSteps.Transaction.LastDateTimeUtc, ScreenshotId, ScreenshotDateTimeUtc,
TransactionSteps.LargeData.Screenshot
FROM Orion.SEUM.TransactionSteps

SELECT TOP 1 TransactionId, TransactionStepId, DateTimeUtc, Duration, Status, ScreenshotId,
StepResponseTimeDetail.LargeData.Screenshot
FROM Orion.SEUM.StepResponseTimeDetail (nolock=true)
ORDER BY DateTimeUtc DESC