5 Replies Latest reply on Jul 2, 2009 2:35 PM by pserwe

    WANTED: Custom Grouping

    ACDII

      I like how I can have groups by device, but would be real neat is to group by customer. Is there a way to setup a custom group field so I can list nodes based on the customer instead of by device? It would also make it easier for setting up customer logins to view their devices.

        • Re: WANTED: Custom Grouping

          yeah, you can create custom properies in the "custom property editor".  Then create a new node list then use the custom property as the container.

            • Re: WANTED: Custom Grouping
              njoylif

              Stoned is correct...I use the first part of the node name...we are very customer connection centric and I group on a custom field (GroupNPM) which is based on our router naming convention - see diagram.  below is SQL I use to do this in a nightly job...

                UPDATE Nodes
                SET NPMGroup = (
                  SELECT SUBSTRING(
                      Caption, 1,( (
                          Select CASE
                          WHEN (CharIndex ('-', Caption, 4) > 0)
                            THEN (CharIndex ('-', Caption, 4)-1)
                          ELSE WHEN
                            (Caption LIKE 'PING%')
                            THEN (9)
                          ELSE
                            (LEN(HostName))
                          END ) )
                          )
                      )
                WHERE NPMGroup = 'Ungrouped'
                OR    NPMGroup is Null "

            • Re: WANTED: Custom Grouping
              ACDII

              Any way to sub catagorize?

                • Re: WANTED: Custom Grouping
                  njoylif

                  not sure what you are looking for?
                  I don't think you can view another level of categorizing...so in my example, have a group AP then subgroups XRT,ENT, etc...
                  I don't know that the app can do that.  You could certainly create that with custom properties (columns) and SQL to break out the names, but when you went to view, it would be one category or another (level 1...AP, level 2 ENT,XRT, etc..) so you would see all of AP stuff, including all nodes from subcategories, or if you group by level 2, when you expand, you would only get the nodes expanded under AP-XRT,AP-ENT if your SQL broke it out that way).
                  does that make sense?

                • Re: WANTED: Custom Grouping
                  pserwe

                  I categorize strictly with the use of a custom property.

                  In our case, it's all based on customer number.

                  From the customer number, anything else relevant can be derived via the NPM database or other systems.

                  Of course, we have a couple of very large ones, but overall it makes quite a bit of sense.