Hi Team,
Greetings! I hope you are doing well.
I am reaching out to seek your help and suggestions. I have created a modern dashboard, but I am encountering an issue where not all nodes are displayed for non-admin users.
I built the dashboard using an SWQL query, and the data displays correctly for both myself and other admin users. However, the data is not showing for group-based users or non-group-based users (e.g., NOC-readonly). Meanwhile, all other modern dashboards created in the same way are visible to all users. I did not find any account limitations for the affected users. I reported this issue to the SolarWinds support team nearly 12 days ago, but I have not received a solution yet—only email exchanges have occurred. Now, my team members are continuously doing follow-up for this issue with me and asking me to resolve this issue as soon as possible.
Admin user Modern Dashboard screenshot.
Noc-readonly Modern Dashboard Screenshot.
Below is the query which I used while creating the above and other Modern Dashboard.
SELECT
n.DetailsURL,
n.Caption,
n.IP_Address,
MIN(si.StatusName) AS Status,
MIN(n.Status) AS StatusImg,
ADDMINUTE(330, MAX(e.EventTime)) AS [Down at],
n.CustomProperties.Department,
n.ObjectSubType
FROM Orion.Nodes n
LEFT JOIN Orion.Events e ON n.NodeID = e.NetObjectID AND e.EventType = 1
LEFT JOIN Orion.StatusInfo si ON si.StatusID = n.Status
Where n.CustomProperties.Department IN ('CORP_12')
And n.Status IN (2, 1, 3, 14)
AND [n].CustomProperties.Ownership = 'Admin'
AND [n].ObjectSubType = 'ICMP'
GROUP BY
n.DetailsURL,
n.Caption,
n.IP_Address,
n.CustomProperties.Department,
n.ObjectSubType;
