1 Reply Latest reply on Jul 23, 2014 2:58 AM by MarXtar

    Reporting - Group devices by similar names

    Specialist

      We have our pc's named with a fairly standard naming structure

      AA_BBBB_CCDD_EE

      aa = Office Location code

      BBBB = Department code

      CCDD = Building & Floor code

      EE = incremental numbers.

       

      I'd like to run a report where it groups the pc names by the second set - department code.

       

      Is there a way to construct this as either a query or report without having to break out each individual code that exists?

       

      Thanks!

      Dave

        • 1. Re: Reporting - Group devices by similar names
          MarXtar ITSMMVPGroup

          Hi Dave,

           

          No standard way I'm afraid because sorting would be based on the starting characters.  If you had Data Analytics you would be able to create rules that processed the names to populate a field containing the data you wanted to sort against.

           

          If you had a small enough subset of these names you could create individual queries that search for LIKE such as *BBBB* but you would then just have one report per department.

           

          Mark McGinn

          MarXtar Ltd/MarXtar Corporation

          http://landeskone.marxtar.co.uk

          LANDESK One Development Partner

           

          The One-Stop Shop for LANDESK Enhancements