Answers.Body: <p>Check in the civicrm_log table in the database and if there's an entry there for it then the modified_id will be the contact_id of the person who did it. But civicrm_log only logs minimal info. If you have detailed logging turned on at administer - system settings - misc, then there'll be a log_civicrm_grant table that records every change.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-06T06:13:39.507Z
Answers.Text: Hi @demerit, I checked the civicrm_log file. All records have modified_id information. This information is passed to the entity_table table as civicrm_grant. But the biggest problem is that I can't pull this information from the CiviCRM reports area. It is very difficult to access this data with a query from SQL. It also requires a permit.
  In the meantime, I couldn't find a section called misc in System settings.
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-06T06:16:57.740Z
Answers.Text: The menu entry's full name is "Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.)" And yes you're right that currently there is no good way to access the info from the reports - you need to look at the SQL.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-06T09:52:05.770Z
Answers.Text: I found the menu. Thanks for more information. If I can't access this data on the CiviCRM Reports screen, my issue isn't solved. Checking through SQL will not be a solution for me at this time. Thank you for your interest.
Answers.UserDisplayName: Fatih ATEŞ
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-12-05T14:56:36.193Z
Answers.LastActivityDate: 2019-12-05T14:56:36.193Z
Answers.UserDisplayName: Demerit
Body: <p>I cannot see who has created the grant records on any individual. Here sometimes the cancellation etc for the grant is going on in the registrations. Or you can enter more than one grant. But it is unclear who created these records. How can I get this information</p>
  
  <p>For example: I created a grant for the person "A". The authorized person is checking this record. However, the data does not appear to indicate that the recording is mine or another person.</p>
  
Tags: <joomla><reports><grant>
Title: I Can't See Who Created Grant Records
ThreadText: # I Can't See Who Created Grant Records
  
  (Asked by: username_0 on 2019-12-05)
  
  I cannot see who has created the grant records on any individual. Here sometimes the cancellation etc for the grant is going on in the registrations. Or you can enter more than one grant. But it is unclear who created these records. How can I get this information
  
  For example: I created a grant for the person "A". The authorized person is checking this record. However, the data does not appear to indicate that the recording is mine or another person.
  
  **Tags:** joomla, reports, grant
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-12-05. Score: 1
  
  Check in the civicrm\_log table in the database and if there's an entry there for it then the modified\_id will be the contact\_id of the person who did it. But civicrm\_log only logs minimal info. If you have detailed logging turned on at administer - system settings - misc, then there'll be a log\_civicrm\_grant table that records every change.
  
  > **Comments:**
  > **username_0**: Hi @demerit, I checked the civicrm_log file. All records have modified_id information. This information is passed to the entity_table table as civicrm_grant. But the biggest problem is that I can't pull this information from the CiviCRM reports area. It is very difficult to access this data with a query from SQL. It also requires a permit. In the meantime, I couldn't find a section called misc in System settings.  
  > **username_1**: The menu entry's full name is "Misc (Undelete, PDFs, Limits, Logging, Captcha, etc.)" And yes you're right that currently there is no good way to access the info from the reports - you need to look at the SQL.  
  > **username_0**: I found the menu. Thanks for more information. If I can't access this data on the CiviCRM Reports screen, my issue isn't solved. Checking through SQL will not be a solution for me at this time. Thank you for your interest.  
  
  ---
  
  