User activity audit8/17/2023 We can also use the audit logs to find opportunities to make our dashboards load faster, or help people find the data they need by making sure people are using dashboards they can trust. The Reviews question with a hover over the Open in Metabase button at the top of the screen. If we want more information, we can click into the question and select Open in Metabase. Orange’s download was a query titled Reviews. Towards the top of the list we can see that Dr. Click on the All downloads tab to see what Dr. Orange’s downloads was pretty big (for the Sample Database, at least): 1,112 rows of data. The Overview tab for the Downloads section showing three graphs. From the chart on the bottom left, we can see which users have been downloading that data. From the first chart (figure 7), we can see that only four questions have been downloaded. Let’s go to the Downloads section and look at the Overview tab. Brown's specific audit pages open to the Query views tab. The user page charts the user’s activity highlights, query views, dashboard views, and downloaded items. Brown’s name to drill through to detailed information about her actions in Metabase (figure 6). Green user appearing as the only result for the 'Mr. The members list includes the name, groups, date joined, last active date, and signup method of each user. Brown’s activity, we’ll click the All Members tab. This gives us a good idea of who our most active Metabase users are (figure 4). To see what data people have viewed, we’ll use the audit sidebar on the left to select Team members tab. Brown recently quit the company and we want to check what data she was looking at during her last week of employment. So be intentional about who you add to groups with SQL query access to your databases. All Metabase can know about native queries is the database it queries, so we’d have to check each query individually. Note that if someone used a native query (like a SQL question) to access the People table, we wouldn’t see it here. Orange has access to, and talk to them about the data they’d been viewing. Orange’s account, see what queries they’ve been viewing, revoke their access in data permissions, archive any wayward queries in collections Dr. Orange is not supposed to have access to the People table, we could do a deeper dive and audit Dr. The Audit Log for the People table.įrom the table audit log, we can see that the admin isn’t the only person who’s viewed the People table. The table audit log orders its rows by Viewed on date and time, with the most recently viewed queries on top.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |