5 Replies Latest reply on Apr 18, 2017 6:36 AM by eber123

    List of Request Types

    gie

      I'm just setting up Web Help Desk for my organization and would like to get a list of Request Types that I can share with management for input / changes, but I don't see an easy way to compile a list of all types / subtypes.  Am I just missing something simple?

       

      Thank you!

        • Re: List of Request Types
          kellytice

          If you're technically inclined, you can pull a list from the WHD API:

          Web Help Desk REST API Guide

           

          I can do a really simple SQL query to dump out a list, but the problem there is that it doesn't show the Parent->Child relationships...so i need to write a better SQL query.       If i have some time i'll look at that.

          2 of 2 people found this helpful
          • Re: List of Request Types
            elee@sbctc.edu

            Alternatively, if you have back-end access to the database, you could query your Service Catalog directly.
            We use a workbook (connected via ODBC) that reads the database directly...so this gives us a slicer-capable and filterable Service Catalog that is always up-to-date:

            service_catalog_example.png

            I hope this helps!

            • Re: List of Request Types
              eber123

              Hello Gie,

               

              I was looking for a similar list. I am not so familiar with databases so I was looking for a different way. This is what I had done:

               

              1. Open Reports
              2. Choose or create a standard report (actually doesn't matter which one)
              3. Go to "Report Filters" tab
              4. Click on "New"
              5. Filter Attribute chose "Request Type"
              6. Highlight all Request Types
              7. Copy it into Word document
              8. Format

              The process takes for me 5 minutes (but it depends on how I want to format the output). The formatting is working quite well. The last document was 13 pages long and included all our Request Types nicely sorted.

               

              I know it is not the most elegant way, but it works for me.

               

              Regards,

              Eberhard

              1 of 1 people found this helpful