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

[anfearard]

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 "" ?>

[trn]

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

BigFix API Computers in Group with Last Report Time

I’m afraid there’s a difference between “client relevance” (evaluated by the client - Properties, Analysis Properties, Fixlets, Tasks, Computer Groups, etc.) and “Session Relevance” (evaluated by the Server - in Console Dashboards or Web Reports or REST API queries). A bit more detail at https://forum.bigfix.com/t/besclient-version-relevance/39513/2?u=jasonwalker There are a couple of problems with what you’re trying to see, even if this could be done in terms of Client Relevance. You have th…

[anfearard]

Ah poop. Thanks for the reply

[JasonWalker]

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