NCM Query on Cirrus.Nodes returns no data when authenticated as username@domain

Using either the SWIS API (python orionsdk) or SWQL studio, the following query returns no rows when a user is authenticated using a 'username@domain' format. The query does return data using 'DOMAIN\username' format for the same user, and for local accounts. This is on version 2024.2.0.

SELECT Top 10 NodeCaption FROM Cirrus.Nodes

A similar query on Orion.Nodes returns data fine using 'username@domain' format.

SELECT Top 10 Caption FROM Orion.Nodes

I have only been able to find posts from the past about users not including domain name at all, so I'm not sure if this is expected behavior or a bug. Would love to hear if others can replicate, and maybe if someone knows if this is a known issue or bug.

Thanks!

Find more posts tagged with

swis

SWQL

ncm

Accepted answers

All comments

adam.beedell

Works for me. Not sure what you'd need from ciccus.nodes though.

My guess is the windows account doesnt have NCM access

jeisenbath

Interesting, so using SWIS API or SWQL Studio, authenticating to the Orion v3 server type, you were able to query the Cirrus.Nodes table using username@domain as the user name format.

The account of course is NCM admininistrator, but I also don't follow the logic that it could be an issue with the account, seeing that the query works fine when using DOMAIN\username format to log in.

And it's not relevant to the issue about why I need it, but it was an issue another user (completely separate Solarwinds install and instance) raised on the Ansible Collection I maintain. I'm trying to track down if this is a bug, known issue I should document, or something wrong with both of our instances and accounts.

adam.beedell

Ah, I think I mistested that the first time

"A similar query on Orion.Nodes returns data fine using 'username@domain' format."

"the query works fine when using DOMAIN\username format to log in."

tested both this time - results with domain\username format, no results with username@domain format, likely bug