Hi all,
I'm trying to create a custom report from Server Configuration Monitor data and I'm attempting to use SQL.
There is a column in the SCM_ElementContents table called "Content" that I'd like to add to the report, but when I convert it to varchar from varbinary, the data appears to be encoded and I'm not sure how to get that data to display. Does anyone have any pointers to info on this?
The content that I would like to have displayed is console output from a PowerShell script.
Here's an example query:
SELECT convert(varchar(1000),c.Content,2)
FROM [dbo].[SCM_ElementContents] c WITH (NOLOCK)
JOIN [dbo].[SCM_ActiveElementMetadataWithBaseline] m WITH (NOLOCK) ON m.ElementContentID = c.ElementContentID
WHERE m.PolledElementID=1224 AND m.NodeID=177 AND m.VersionID=2541