Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Orion.Report table is empty when Certificate auth is used #309

Open
VinxItak opened this issue Feb 1, 2022 · 2 comments
Open

Orion.Report table is empty when Certificate auth is used #309

VinxItak opened this issue Feb 1, 2022 · 2 comments

Comments

@VinxItak
Copy link

VinxItak commented Feb 1, 2022

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

@VinxItak
Copy link
Author

VinxItak commented Feb 1, 2022

$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

@VinxItak
Copy link
Author

Does this issue will be addressed ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

No branches or pull requests

1 participant