Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Custom Query on a view does not display the correct number of pages for Service Now Alerts

Here is the SWQ:L query

SELECT
ai.IncidentNumber as [Incident Number],
ai.State as [Incident Status],
o.EntityCaption AS [ALERT OBJECT],
ai.AssignmentGroup AS [Assignment Group],
ai.AssignedTo as [Assigned]
FROM Orion.ServiceNow.AlertIncident AS ai
INNER JOIN Orion.AlertObjects AS o ON o.AlertObjectId = ai.alertobjectid
where (ai.State = 'Pending' OR ai.State = 'New' or ai.State = 'In Progress') and ai.AssignmentGroup = 'Field Infrastructure Services - Firewalls'

The query works, it is to display 5 rows. The query return 14 records at the bottom it display Page 1 of 0. If I click on show all, it shows all 14 of them. If I make the query removing the inner join and the field the inner join returns it display correct it says Page 1 of 3

SELECT
ai.IncidentNumber as [Incident Number],
ai.State as [Incident Status],
ai.AssignmentGroup AS [Assignment Group],
ai.AssignedTo as [Assigned]
FROM Orion.ServiceNow.AlertIncident AS ai
where (ai.State = 'Pending' OR ai.State = 'New' or ai.State = 'In Progress') and ai.AssignmentGroup = 'Field Infrastructure Services - Firewalls'