Home Analyst Portal

Retrieve Tier Description within a sql query

Justin_ClarkeJustin_Clarke Customer Advanced IT Monkey ✭✭✭
Hi all,

I have a requirement to be able to associate an owner to each of our support groups(Tier Queues). This will be used to create dashboards showing open IR/SR's and who the owner of the support group is. Was thinking i could use the description field to store the owner in and be able to query this via sql to create my dashboards.

Does anyone know if the support group description is synced into the servicemanagement database or how i could pull this information?

Also any other options are welcome. Other thought was a custom field but thought this might be worth a try first

Thanks in advance.

Justin

Best Answers

Answers

  • Justin_WorkmanJustin_Workman Cireson Support Super IT Monkey ✭✭✭✭✭
    edited January 2019
    @Justin_Clarke
    I've attached a query against the ServiceManager database that I think might fetch what you're after.  Should work in a dashboard too.   
  • Justin_ClarkeJustin_Clarke Customer Advanced IT Monkey ✭✭✭
    Hi @Justin_Workman ,

    Thanks for the query. Looks good but the owner field seems to be showing the status and not the description of the support group. Screenshot of where i have set the description FYI and an output of the query on a dev server. 





    Thanks for you help. 
  • Geoff_RossGeoff_Ross Cireson Consultant O.G.
    Hi Justin,

    I think you would be better off creating a custom class that has a support group property, you can link to the existing Incident Tier Queue Enum, and then an owner field (you get this for free if you build a custom Config Item class). Then you can look this up when you create your work item report.

    Geoff
  • Justin_ClarkeJustin_Clarke Customer Advanced IT Monkey ✭✭✭
    Thanks @Justin_Workman This query worked a treat.

    I will look into the Custom Class @Geoff_Ross if i require more than just reporting data. thanks for the input. 
  • Justin_ClarkeJustin_Clarke Customer Advanced IT Monkey ✭✭✭
    Thanks again for the query, 

    Just a question, is there any easy way to pull the last modified date out of the service manager DB?
  • Justin_ClarkeJustin_Clarke Customer Advanced IT Monkey ✭✭✭
    Thanks Justin for your quick response. 
Sign In or Register to comment.