2 Replies Latest reply on May 6, 2014 10:08 AM by GregoryWalter

    Group and Count by Part of Computer Name

    Rookie

      I am looking to create a report that groups and provides the total count of computers in a specific building. Our computers are named has having the first two characters as the building "code" so I would be looking to group and get a total count of all computers that have the first two characters of their display name matching.

       

      Example: One building is BI with computers named BI123, BI234, BI345, etc. Another building is CC with computers named CC123, CC234, CC345, etc. I would like to be able to put a group with "BI Computers - Total Count: XX" followed by a list of each one of those computers. Then another grouping with "CC Computers - Total Count: XX" followed by a list of each of those computers. Continued this way for each building.

       

      I haven't been able to find a way to get just the left two characters (or for future reference any specific characters from a value) to be able to group items by like this.

       

      Any help is appreciated.

       

      Thank You.