This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Ho do you get a Screenshot of a failed step on the email alert?

Hello Everyone,

I have been trying to get the failed WPM recording screenshot on the email alert for couple of months now.  Can anyone provide any ideas to how to add a screenshot without having to log in to see it on the email alert?

I have one that works but the annoying part of the screenshot is that you have to log in to be able to see the screenshot:

<a href="https:/[ip address]/${ScreenshotUrl}"><img src="[ip address]/${ScreenshotUrl}" alt="Screenshot" width="640" height="480">

I was testing this code out but I'm not sure if its working because it only shows the top 1 screenshot and I keep getting a broken screenshot image; so I'm not sure if it even works:

 

<img src="data:image/png;baseq64, ${N=SWQL;M=SELECT TOP 1 TransactionId, TransactionStepId, DateTimeUtc, Duration, Status, ScreenshotId,

StepResponseTimeDetail.LargeData.Screenshot

FROM Orion.SEUM.StepResponseTimeDetail (nolock=true)

ORDER BY DateTimeUtc DESC FOR XML PATH('')),'<Screenshot>','')}">Screenshot</IMG>

If anyone can help, that would be great!

Parents
  • Oh good lordy this is harder than it used to be. It all comes down to security stuff and where it's being received

    I wrote some code for embedding it. That still gets declined by some things and can use up a lot of email space. Otherwise you can link to a location but if it's in SLW it's got to follow auth steps. So like if there's no auth on solarwinds it's easy, if it's secure you're stuck.

    I think the best solution involves spinning up a CDN thing somewhere

    We really need this as a feature

  • You were able to get this working before? AFAIK it is not possible. Speaking directly with the lead developer on this one, its not possible or supported. But a popular request. 

    Vote on the active feature request here:  Attach screenshot to alert email  

  • I have voted for this feature and hoping they will get it going soon....since the voting post is over 4 years old....

  • Got it working now but that's with quite a lot of asterisks. The last version I made stopped working randomly and it was to do with the image format changing without a known reason for the change (perhaps it could be like to do with image size or something)

    I'll fetch some code. Previous code from me is in this forum.

    It didnt really solve the problem I wanted it to so I'm not sure how reliable it is over time, that's due to the ticketing system we use though.

  •   Right this one does the thumbnail. Trying to rememeber exactly where I got to with the full size one, it's a dramatic understatement to say I had problems with the full size one

    <img src="data:image/png;base64,${SQL:
    Select
    REPLACE(
            REPLACE(
                    (
                        SELECT TOP 1 thumbnail
                        FROM [dbo].[SEUM_StepResponseTime_Detail]
                        where transactionid = ${N=SwisEntity;M=TransactionId}
                        and status = 2
                        order by DateTimeUtc DESC
                        FOR XML PATH('')
                    ),'<thumbnail>','')
            ,'</thumbnail>','')
    }"/>

    In there we've got like 4 conversions it's gross
  •   can I trade that for a PM about the chat with the Dev?

  • Code that worked a year ago for almost no time at all and which I think may be environmentally dependant. The screenshot one below is better but they work on the same principle.

    Screenshot:

    <img src="data:image/png;baseq64, ${SQL: Select REPLACE((SELECT TOP 1 Screenshot

    FROM [dbo].[SEUM_StepResponseTime_Detail]

    where transactionid = ${N=SwisEntity;M=TransactionId}

    and status = 2

    order by DateTimeUtc DESC

    FOR XML PATH('')),'<Screenshot>','')}">Screenshot</IMG>

    SQL -> Binary -> XML -> Base64 -> NVARCHAR(MAX) -> HTML -> PNG

  • Somewhere I've got something that's halfway between those two. I think I broke down a bit when it still wasn't received right on the other side

  • hmmm I still get a broken image screenshot.  Is it because I'm stimulating the email and it's not working??

  • If you havnt already, got to make sure you simulate on a failed transaction as i've got a status = 2 in there.

    If you're getting a broken link even on a failed transaction maybe there's another image format change. Try the Thumbnail one first.

  • Tried the reliable one across a wider range of stuff and I think it may actually be that you can vary the image format based on web player. Maybe.

    If the image format it's saved in matches what your macro is happy to accept it can work. Imagine format seems somewhat irregular though. It may be possible to match em up in a larger macro if they were all known.

Reply
  • Tried the reliable one across a wider range of stuff and I think it may actually be that you can vary the image format based on web player. Maybe.

    If the image format it's saved in matches what your macro is happy to accept it can work. Imagine format seems somewhat irregular though. It may be possible to match em up in a larger macro if they were all known.

Children
No Data