• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 24 subscribers
  • Views 160 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

FAQ's - has anyone created a report for these or modified the search screen display?

jeepmom00


My IT Department is tasked with creating a number of FAQ's per month.  The challenge in tracking this is when I approved the FAQ, the name that shows on the main FAQ screen changes from the person who created it to my name in the Updated column.  I would like to either:

- add the Created By field to the FAQ display screen

- create a report that shows/counts the number of FAQ's created by person for a time period

Any ideas?

  • 0

    If you have any experience with SQL, you can use this query as example and modify it for your needs:

    SELECT [FAQ_DATE],[QUESTION],[TECH_ID],[Helpdesk].[dbo].[TECH].USER_NAME

      FROM [Helpdesk].[dbo].[FAQ]

      INNER JOIN [Helpdesk].[dbo].[TECH]

      ON [Helpdesk].[dbo].[FAQ].TECH_ID=[Helpdesk].[dbo].[TECH].CLIENT_ID

      WHERE [FAQ_DATE] > '2012-12-01'

      AND [FAQ_DATE] < '2013-05-01';

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.