I'm trying to create a report that would show what request type a Lead Technician is assigned to. This would be beneficial when people leave the company and are assigned to a request type that's buried in the request types tree.
I don't see how you can run an actual report to get this data, but two ways I see how you can get this information are to:
Hope this helps you out!
dawilsonvette also if you add the JVM argument "-WHDENableSQLTool=true" to the JAVA_OPTS section of the whd.conf file as mentioned here in the admin guide (JVM arguments - SolarWinds Worldwide, LLC. Help and Support)
You can go to http://YOURHELPDESKIPADDR/helpdesk/WebObjects/Helpdesk.woa/wa/DBActions/sqlTool, login as admin
and you have a sql query tool at your fingertips.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.