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

GROUP SITES DQ BY CP Address?

sja

Is there smart regex I can use to auto group by CP Address?

Or I need to copy&paste all the site/pop address?

like that

Find more posts tagged with

Accepted answers

mharvey

To do that, you'd have to use 1 query per group. The DQ within the group creation is generating for that sole group you are creating. There's not an automated group builder that would do this. There are way to get something done using the SDK, but I'm not all that familiar with it. Within the website, you'd have to create each group individually and list out each address within a query that would belong to that group.

All comments

mharvey

Are you creating a group for each address? If so, you'd just need to select the address in the Dynamic query. You'll have to repeat for each group you want to create. If you are wanting to group a node list by address, then you simply need to edit the node list or node tree resource and choose the Address CP as only of the sorting columns.

sja

Thanks for getting to me.

Each POP/Site have 5-10 nodes that share the same address CP.

Like to Auto generate those group based on that Address CP.

something like

Node A CP NY

Node B CP LA Auto Group = 1.Group NY

Node C CP NY 2.Group LA

Node D CP LA

/SJA

sja

Okay when I run that

Orion Object

QoE Application Virtual Cluster Custom Interface Poller Custom Node Poller VMware Datacenter Hardware Category Overall Hardware Status Hardware Sensor Virtual Host Interface Node Virtual Center Virtual Machine Volume

Address alertemail Caption CID Comments Contact Description DNS External Has Dynamic IP Hovedkontor Installation_Dato IOS Image IOS Version IP Address IP Version KundeadminErhvervLink Location Machine Type Node ID Node_Alarm_Type NODE_SERVICE Node_Tilhørsforhold Node_Type service_type SNMP Version SNMPv3Credentials SNMPv3Credentials - Description Status System Name Vendor

is is not begins with ends with contains matches

Press down arrow to use existing values.

I get all the nodes that has something in the address CP to 1 big group...

I want to generate a group for each unik address

mharvey

RichardLetts

I've uploaded a perl script here: add-group.pl to create dynamic groups

Here, nodes have a custom property 'Building' that contains a building code

I manually created the list of unique groups I wanted at ~lines 23..25+; the group name to be created is generated at ~line 40; and the query that defines the members of the group is at around line 56

/RjL

sja

Thanks Richard!