SQL reporting error
I am trying to edit code in mysql workbench but I am getting an error for user R1 Error Code: 1142. SELECT command denied to user 'R1'@'nrsranch-it01.goropin.local' for table 'HD_TICKET_CHANGE'
I have changed the password for R1 to verify it is the correct password.
I have changed the password for R1 to verify it is the correct password.
I am trying to create a report that will show how many tickets were closed by 2 users in a year time frame sorted by month
SELECT T.ID, T.CREATED, T.TIME_CLOSED, OWNER.FULL_NAME as "Owner",
CLOSED.TIMESTAMP, CLOSED.DESCRIPTION,
CLOSER.FULL_NAME as "Closer"
FROM ORG1.HD_TICKET T
LEFT JOIN HD_TICKET_CHANGE CLOSED ON CLOSED.HD_TICKET_ID = T.ID and CLOSED.DESCRIPTION like '%Changed ticket Status from%to "Closed"%'
LEFT JOIN USER OWNER ON OWNER.ID = T.OWNER_ID
LEFT JOIN USER CLOSER ON CLOSER.ID = CLOSED.USER_ID
WHERE T.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 24 HOUR)
AND (CLOSER.USER_NAME = "jwinn" or CLOSER.USER_NAME = "twinn")
This is one I have for daily tickets
1 Comment
[ + ] Show comment
-
Can you run other queries without that error? If not, check to make sure that "Enable database access" is checked in Security Settings. - JasonEgg 8 years ago
Answers (0)
Please log in to answer
Be the first to answer this question
