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.

Where to find DetailsUrl field for SRM?

I have created a report from data in SRM using a Custom SQL Query and I want to add the node link to the names of the Storage Arrays in the report; however, I am receiving the following error when attempting to do so:

NAME - 'Details Page Link' data presenter requires 'db|DetailsUrl' field(s) to be present within the datasource

Where in the database can I find this information so I can include it in the query?

  • I am not sure if this is the same, but you can try this sample which shows the notes on a node using custom SQL with the detailsURL of the node:

    ======================

    SELECT CONCAT('<a href="',b.caption,'</a>')">thwack.solarwinds.com/.../View.aspx as 'Caption',

    a.Note,a.AccountID,a.TimeStamp

    FROM NodeNotes a

    INNER JOIN NodesData b on a.NodeID=b.NodeID

    ORDER BY a.TimeStamp DESC

    ======================

    Note: Do not enable the details page link on the column anymore.

    This will automatically create a hyperlink of the node in caption.

    Hope this helps emoticons_happy.png