MiscPSSDiagInfo ... ServerProperty. Error may occur collecting data and it isn't clear what we might be missing

[gambit9009]

miscpssdiaginfo captures info under --ServerProperty--

If you get an error, the table might be broken into 2 tables. (by design)
You may see that table split by something like...

RegQueryValueEx() returned error 2, 'The system cannot find the file specified.'

We could possibly improve the way it is collecting this info or at least have better error handling or reporting. Like what value was this line going after that got this error? What info might we be missing?

There is a comment on line 78 ...

--we need to get this into a different rowset because it may fail

We are trying to read the registry here ...

EXEC xp_instance_regread

There may be other areas to approve, but talked about starting there.

[gambit9009]

@hacitandogan We will assign this to you