Custom Report Gives The operator "native registry" is not defined

Hi Folks,

Am trying to do a report for the DBAs that lists the servers and versions of SQL. Using the below relevance in the web query works but not in the custom reports. Any ideas?

<?Relevance if (exists values "CurrentVersion" of keys "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion" of native registry as string as version) then (item 1 of item 1 of (it,("10.0","SQL Server 2008";"10.50","SQL Server 2008 R2";"11.00.2100","SQL Server 2012 - RTM";"11.0.3000","SQL Server 2012 - SP1";"11.0.5058","SQL Server 2012 - SP2";"11.0.6020","SQL Server 2012 - SP3";"11.0.7001","SQL Server 2012 - SP4";"12.0","SQL Server 2014";"13.0","SQL Server 2016";"15.0","SQL Server 2019";"14.0","SQL Server 2017")) whose (item 0 of it as version = item 0 of item 1 of it as version) | ("Unknown Version - " & it as string)) of (value "CurrentVersion" of key "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion" of native registry as string as version) else "" ?>

Custom reports use Session Relevance - you have attempted to use Client Relevance.

See this recent thread where @JasonWalker gives a good explanation of the difference

1 Like

Ah poop. Thanks for the reply

So…create an Analysis that uses this relevance for a property value, and use Web Reports to retrieve that property value.