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
Store

Duplicate Composite Keys

rawwinton

Hi,

Why does solarwinds have multiple primary keys and how do I select distinct in SWQL?

Regards,

Rawwinton

Find more posts tagged with

Accepted answers

All comments

tdanner

Could you post the query you used to get that data?

rawwinton

SELECT SubnetId, ParentId, FriendlyName, URI

FROM IPAM.Subnet

muralikvp

Based on number of users created in Orion, IPAM will duplicate such number of subnets in IPAM.Subnet. You may use IPAM.GroupReport SWIS entity.

This SWIS entity is filtered with respective to SWQL studio login .That means if you have entered through 'admin' account then IPAM.GroupReport will give information related to admin account.

I have posted below Sample Query that will give exact information like IPAM.subnet

SELECT GroupId as subnetid, ParentId, FriendlyName,URI

FROM IPAM.GroupReport

rawwinton

Hi,

i did try to run the query but it returned me an empty result set.