Retrieve Tier Description within a sql query
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.