Open VinxItak opened 2 years ago
$swis = Connect-Swis -Hostname $OrionServerName -Certificate (Get-SwisData -SwisConnection $swis -Query "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
$swis = Connect-Swis -Hostname $OrionServerName -Username xxx -Password yyy (Get-SwisData -SwisConnection $swis -Query "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
Does this issue will be addressed ?
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
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