Orion.Report table is empty when Certificate auth is used

Vinx

Hi guys, as we don't have any answer on GitHub : https://github.com/solarwinds/OrionSDK/issues/309

In SWQL Studio (and using PowerShell too), when we authenticate using certificate, Orion.Report table give 0 row ; whereas using Admin account for example, table returns content. Orion (v3) certificate : SELECT TOP 1000 ReportID, Name, Category, Title, Type, SubTitle, Description, LegacyPath, Definition, ModuleTitle, RecipientList, LimitationCategory, Owner, LastRenderDuration, OrionFeatureName, DisplayName, InstanceType, Uri, InstanceSiteId FROM Orion.Report >> 0 row Orion (v3) [Admin] : SELECT TOP 1000 ReportID, Name, Category, Title, Type, SubTitle, Description, LegacyPath, Definition, ModuleTitle, RecipientList, LimitationCategory, Owner, LastRenderDuration, OrionFeatureName, DisplayName, InstanceType, Uri, InstanceSiteId FROM Orion.Report >> 4xx rows

KMSigma.SWI

Certificate authentication runs via the "_system" account.  That account is typically only used for internal workings and therefore the permission levels (specifically when we are talking about reports, modern dashboards, and few other places that are "keyed" to user accounts) aren't configured the same.

Long story short: certificate authentication isn't built for this kind of work.