2 Replies Latest reply on Oct 27, 2016 9:15 AM by adicicco@fisherco.com

    Log or Report

    adicicco@fisherco.com

      In Solarwinds Web Helpdesk 12.4.2.36 is there a way to run a report or view a log that shows what clients have logged into the client portal?

        • Re: Log or Report
          rodegard

          I am not aware of a report in WHD, but we run this SQL against the DB each month to see what clients are using the portal to create tickets (vs, the tech created or e-mail created tickets).

           

          SELECT
          CASE
          WHEN JT.CLIENT_CREATOR_ID = JT.CLIENT_ID AND JT.IP_ADDRESS <> '' THEN 'Y'
          ELSE 'N'
          END As 'WEBPORTALCREATED',
          JT.JOB_TICKET_ID AS 'TICKET NUMBER',
          LT.LOCATION_NAME as 'LOCATION',
          CONVERT (VARCHAR(80),JT.QUESTION_TEXT) AS 'TICKET REQUEST',
          CONVERT(VARCHAR(19),JT.REPORT_DATE) AS 'DATE OPENED',
          JT.ASSIGNED_TECH_ID AS 'TECH ID',
          TECH.USER_NAME AS 'TECH USER ID',
          TECH.FIRST_NAME + ' ' + tech.LAST_NAME AS 'TECH NAME',
          TG.NAME AS 'TECH GROUP',
          JT.CLIENT_CREATOR_ID,
          JT.CLIENT_ID,
          CT.USER_NAME AS 'REQUESTER USER NAME',
          CT.FIRST_NAME + ' ' + CT.LAST_NAME AS 'REQUESTER NAME',
          CT.EMAIL AS 'CLIENT EMAIL',
          ST.STATUS_TYPE_NAME AS 'STATUS',
          PT.PRIORITY_TYPE_NAME AS 'PRIORITY'

          FROM  JOB_TICKET "JT"
          INNER join TECH
          ON JT.ASSIGNED_TECH_ID = TECH.CLIENT_ID
          INNER JOIN PRIORITY_TYPE "PT"
          ON JT.PRIORITY_TYPE_ID = PT.PRIORITY_TYPE_ID
          INNER JOIN STATUS_TYPE "ST"
          ON JT.STATUS_TYPE_ID = ST.STATUS_TYPE_ID
          INNER JOIN TECH_GROUP_LEVEL "TGL"
          ON JT.TECH_GROUP_LEVEL_ID = TGL.ID
          INNER JOIN TECH_GROUP "TG"
          ON  TGL.TECH_GROUP_ID = TG.ID
          INNER Join LOCATION "LT"
          ON JT.LOCATION_ID = LT.location_ID
          INNER Join CLIENT CT
          ON JT.CLIENT_ID = CT.CLIENT_ID
          WHERE JT.REPORT_DATE LIKE 'Aug% 2016%'

          1 of 1 people found this helpful