Name: Expanding the power of Governance Core Apps
Uploaded: 2025-05-15T18:46:04.160Z
Duration: 1 h 32 s
Description: Expanding the power of Governance Core Apps

Transcript for "Expanding the power of Governance Core Apps": Hi, everybody, and welcome to our session today. We're gonna be covering a little bit about today about getting started, the governance core apps. Sorry about that. Getting started on this webinar. We're gonna get going in just a few minutes. But while everyone's still funneling in and joining, it'd be great if you all could let us know what kind of experience do you have with the governance core apps, and are you using them currently? Maybe you've never downloaded them and you've only just heard about them. Maybe you have installed them but haven't fully set them up. Or maybe you're someone who's like, I love these apps. I use them all the time. Just give us a note because we wanna get an idea of those joining us, like, how much experience do you have with them. And while people are answering the quest answering that poll, I can let you know a few things about our webinar today. Josh will be joining us as our speaker. He's one of the Quickbase gurus here who will let you know a lot more about governance core app. It's his baby in creation. We're gonna be running today until probably, like, a forty five minutes of presentation and, some time for q and a at the end. So we'll be taking questions throughout the session today. You can do that, right on the right where our our, the the chats appears. You also see options for, documents and q and a. Q and a is where you can put your questions in as we go through the session today. You can also find us in the, chat if you need anything while we're going through today's session. And then the documents has a whole bunch of awesome resources for you, including if you're interested, you can find some great information there, on the getting to the the GCA apps, including how to start downloading them. So make sure if you are looking for more resources, you can find them in the upper right. I see we've got some great we've got a lot of people joining us today who have not tried the the GCA yet, which is great. So this is gonna be a good introduction for you, and you're gonna get to see what you would get out of taking the time to install these apps and sort of what kind of insights you can expect to see once you get things set up. Now is the perfect time to get started. So, like, it's a great opportunity for you to do so. If you, like I mentioned, in the links, there is a option for you to get the GCA instruction app. That app includes all the instructions you're gonna need to get started. So if you do nothing else when you leave today, make sure you grab that link because that'll help you get your get started with the GCA. Alright. So we're a couple minutes in. Listen, we've got a good group of people who joined us. So I'm gonna take this minute to hand this hand everybody off to Josh. He will be running the session for today. Thank you so much. Perfect. Hey, everybody. So we'll get right into the the presentation itself and hopefully, some healthy q and a at the end. So just a just a brief overall review of what I'm gonna go through. In Empower, I did a session on, just the governance core app and promised the the folks there that I would have audit logs ready and locked and loaded on the exchange. Still working through that. I I forecast by the end of the month, that I'll have that out on the exchange. And I'm gonna show you all, that feature and functionality today as it takes a little bit of time to to put it all together, you know, to make it ready for prime time, if you will. So thanks everybody for, for joining. I'm gonna go through what the governance core apps are, and then, like I said, go into a live demo and then also talk about how we're gonna, you know, support version control, like Dwight had alluded to on the notes or on the on the chat that he downloaded an earlier version and wants the more current version. So, you know, showing you some tools and feature and functionality to facilitate that. Yeah. Let's let's hop right in. So, let's get up in here. I'm Josh Miller, principal industry advisor of strategy, at Quickbase. I've been here about three years. Prior to this, I was at FedEx for twenty one years. Instead of those years, managed, Quickbase and the overall ecosystem there. Grew it from from a pretty small installation to, something that was a little bit bigger. I think when I left, it was 72 applications, and around 14,000 users. So it still lives on today, even after I'm gone. So I really allude to, you know, just having good policy and standards and, you know, creating a culture of awareness around Quickbase and not just, you know, managing it by yourself, not sharing, the wealth or helping you know, getting help from other people to support support what you're trying to to to run with Quickbase. And, yeah, for the folks that were actually in Empower, some of this is gonna be a repeat, and I'll get into some other fun stuff that I've made. Modifications to the slide deck like this one, for instance. Yeah. Governance is a pretty big word. I was just actually get done with my masters, and, one of the things that they talked about is that one of the questions is what is governance? So, governance generally used to demonstrate to management, customers, and auditors that your information security program is operating as outlined in your policies, procedures, and practices, not a run on census. I promise. But, yeah, I I think that when you unpack that, it's really just having policy and procedure around the software you support because, you know, eventually, you're gonna run-in IT. Right? Whether you've built Quickbase organically within your organization, or somebody from another company came and they use Quickbase in the past, or IT purchases the solution. No matter what you're gonna run-in the IT, and it's it's really important to create a good standard and methodology, as early as you possibly can just to ensure that, you know, IT feels confident that you're protecting their data, and making sure that the solution that you put in place is is secure and protecting what's what's very important to the organization. And that's obviously not making the front, page of a newspaper because you don't have a secure environment. So yeah. And after the fact, I will breeze through a handful of these slides. I just wanna make sure from a context perspective, you'll have this deck after after this is said done too. So, yeah, if I breeze through, that's why. Alright. So governance core apps. In general, I just wanna explain what they are. I mean, I'll summarize this as best as I can. I think, ultimately, my goal is to have a common foundation that we utilize at Quickbase so that terminology is the same and that we can all kinda use this this foundation collectively to to scale, you know, as a team, as a community. I think I think so often, you know, there's so many applications out there that you can manage your ecosystem and, you know, there's a lot of cool things that clients have done. But, you know, if the terminology is not there and there's not consistency in the messaging of what governance means or, you know, how to maintain or, you know, or or organize an environment, make it really hard, to to improve upon it. So my goal is really just to create a foundation that that we can utilize as a community and and grow it together and benefit from one another's work. So yeah. So what what runs the governance core apps, at its core, are admin console connected tables. So what admin console connected tables are, I'm gonna kinda balance it between, you know, the the the screen and and the and the slide deck. So these are what are called admin console connected tables. So if you click on this, for instance, you see these are applications associated with this from. Right? So here's and then here's some attributes associated with that that specific, you know, that specific table. Users, user access, user tokens, pipelines, connected tables, audit logs. So when you think about these, some of the the insights that you can gain is, like, how many people are, you know, not in our company that are using our realm? Or how many apps are EOTI? Or how many user tokens do we have, and how many of them have descriptions, and how many don't. So not only does it help you to enforce hygiene, but just to get all this data in one place, it saves a ton of time for for me to ask a question like, hey. How many user tokens does a certain individual own? And how many user tokens are associated with that application? It could take you some time to to to find that that out, you know, with the with the tools that we have provided. So I thought why not put it into Quickbase. Right? Manage Quickbase by utilizing Quickbase, then you have the flexibility to, you know, to scale at your own pace. And it's governance isn't a one size fits all. So what what my goal is to create this foundation, to allow people to scale from. So, yeah. These are examples of some of the insights you can gain from these admin console connected tables. And this is just one piece of the three applications that make up the governance core apps. So when you see admin console sync on, there's nothing you do in here. This is just raw data. It's like a data repository. Because I know in the future that more of these will come. Think groups or, you know, potentially, platform analytics, you know, insights. Those could come in as a connected table, and I wanna have a repository or a place where those things live. And then the second piece of this is Roman sites. The Roman sites is sort of where all the magic happens, allows you to take this information and create sort of a methodology around it. You know, here you can see I've I've got the verses I'm working on. I just wanted to share with the the folks on this call. You can see audit logs has been added, trustees, actions, and I'll get into that here momentarily. But for the most part, these tables that are here correspond here. And then I've added a little bit more on this side just to ensure that you guys get the analysis or the information that you are potentially looking for and just create that baseline. So, that's realm insights. And like I said, we'll get we'll get into a demo here momentarily. And then realm logger, it's just a it's a souped up audit log, is what I would call it. It allows you to so each of the each of these tables feeds into Realm and sites, you know, on a daily basis or whatever cadence you define. So it tells you if those ran effectively on a daily basis. And then it also captures all the things that have been deleted. So if you look at this one twenty four, for instance, a 24 apps have been deleted. What are they? Right? And here's some information around that. It's it's pretty hard to get at this information. If you ask me, like, if I were to ask anybody on the call, hey. Could you tell me the the last six months of deleted applications? Probably have to go into audit logs, look for the deleted apps action, full seven days of data at a time on an export. You can potentially run an API. I just it's too complex. Here it is right here. And then, obviously, if somebody accidentally deleted something, you can go to tech support and say, hey. Here's the app ID. So there's there's that's just an example of, deletion. There's delete users, user access, user tokens, so on and so forth. And with this version, there are actually some changes that I'm logging. And I'll get get into that in a little bit. Alright. So that's that's the three applications that comprise the governance core apps. Admin console sync them, repository for admin console connect the tables, realm insights, sort of where all the magic happens. That's how you can synthesize data and make business decisions off of the data. Realm logger, sipped up audit logs. Alright. Yeah. And in the future, as you scale, there are other opportunities to to sort of bolt on to this core. But I really think that it's important to have this core foundation initially, so that you can effectively build other solutions around, around that core. So these applications I have prototypes of each of these, and there's actually a definition in the appendix. So I'm not gonna bore you with what all of these are. But if you scale your ecosystem, they might be things worthwhile. Instead of building everything in huge application where you're dealing with juggling roles, users, and all that good stuff. Try to keep it simple. No one will break an application up, and don't be scared to break an application up. They can connect to each other. It's okay. Alright. So, yeah. How to access and learn about the DCA? So two things. First, you can go out to the exchange. I would wait until the end of the month just because you're gonna get one that's a lot more robust than the current version. You click here, you go to exchange, and then you would just type TCA, which is governance core apps. GCA. Oh, GCA. Sorry. And then GCA instructions, download that. That'll give you everything that you need, to to install the governance core apps. It it provides you the instructions, helps you to build all pipelines, so on and so forth. And if you run into challenges, there is an opportunity there to, you can you can schedule time with me. And just to show you what that looks like just for the folks on the call. So, going into a d I'm just going into the app. I didn't wanna download another one. I have plenty on my in my realm. So DCA instructions, this is the app that you would get. And if you go to, click here, if you would like help with installation or additional clarification, you can actually just schedule time, to some random person. You can schedule online, and then it'll it'll give you access to my calendar, and then you can, you know, schedule some time to to to go over TCA type stuff. Alright. So that's the governance core app. The other piece that I would strongly recommend, even for the people that have it downloaded, if you go to, if you just go to help, there are some resources out there on Quickbase University. So you can click here, and then let's sign in real quick. And at the bottom here, there's a governance track. You click inside of here. There's a, you know, a whole ordeal here where I'll I'll build we'll build out these micro learnings as we scale so that you have information on how it works, what the purpose of it is, the value, so on and so forth. So, yeah. That's overall, that's how you access it. That's what the government core apps are about. So I wanna be really clear. This is really just a crawl mechanism, initially. Installing the DCA, I'm only gonna move at the pace of the admin console, connected tables. Which ones are available here is what's gonna drive what realm insights looks like. So if you go back to to insights here, you can see this strongly mirrors what what is available here in the admin console connected table. So from a crawl perspective, just having this foundation and allowing you to build off of it off of it as you see fit. There's really some cool use cases where people have built some some pretty neat stuff, you know, off off of the the base that they initially installed. So, it's all you know, just understand this thing. Start to utilize it. You know, you're not gonna get much benefit from it if you install it and it just sits there and you don't, you know, try to utilize it. And walk is more like set notifications up off of, you know, if an EOTI application comes into your realm, you do get a notification, I'm pretty sure. But if not, you could set that up as a notification. You could set up, you know, a new user token being added. Just like any record that new record being added, instead, you have all of these these attributes that you now could leverage to be notified if, you know, something occurs that's important to your organization. And then, obviously, run is you could set policies in an application and let it do the work for you. So, and and I think I think oftentimes people wanna to kinda get to that run quicker than not. I'm I'm I'm well aware of what run could look like. You know, these are the only tables that are currently in the, the enrollment sites right or incorporated in the GCA. But, yeah, of course, you could add tables, fields, reports, relationships, events, roles, groups. And when you start to think of all that stuff, you know, if I would have built that all at one fell swoop without, letting products sort of drive the narrative, it just it can become overwhelming. I think you it's important to move at the pace in the need of your business. So just something to keep in mind. So yeah. So I'm gonna go into a demo now, of the DCA itself. Try my best to, to run through from a presentation perspective just so we can I like q and a? It's kind of my jam. So we'll we'll get there soon. Probably, I'm not gonna, like, speed through this to get there, but, I like to answer questions about governance because it's a pretty pretty broad topic. Alright. So this is realm insights, and it's really where I'm gonna do most of my showcasing, just because, you know, as we talked about earlier from a presentation perspective, you think about the the DCA. It it's comprised of those three applications that we talked about. Sorry. I, was on delay. But but these three these three applications, admin console sync, realm logger, and realm insights, this is where most of the magic happens. What I would say that's very important is I would only let realm admins have access to this. If you wanna have your your app managers get access to this information, and all the attributes associated with their their applications or what they own, you can totally do that. I would recommend just making connected tables off of realm and sites, and letting them manage it here. Because you just don't wanna have multiple roles in here. Like, just just let the speed just for realm admins, and then scale scale accordingly. Alright. So this this is apps. Right? This is users, as far as the tabs go. User tokens, pipelines, connected tables, auto logs is what I've added, and I will show that here in a second. And I try to keep the same basic flow. Right? And, you know, if I'm teaching Quickbase, I want folks to to try to create standard in hygiene. It would be really weird if I created a bunch of reports and didn't give them descriptions or didn't put them in folders. And, yes, by the way, there will be reports in here that are not in folders because this is this is where I'm I'm prototyping before I, deploy. But but if you look at this this theme from from tab to tab, you can see, for instance, apps. How many apps and what app managers are there, for instance. So what this empty means is that the owner it's they're no longer a user, in the in the system. So there's 10 applications that are owned by somebody who's not here. Last access range. So this just helps you to identify, you know, I have 89 apps that have never been accessed. Why don't why do I have them? So it really helps with cleanup. From a user range perspective, what this shows is I've got 36 applications that have 251 to a thousand users. So not that this needs more attention, but I think it's just good to know, you know, what's going on in your space. This is just created per month, total app, so on and so forth. This is a new, report gauge per KPI that I added, and it it directly correlates with the audit logs. So I'll show that here in a second too. So five applications in my space are EOTI. If I click this, it just takes me to it. And and I understand this doesn't need to just be, like you know, the analogy I've used in the past is, like, it's not StarTrack. It's not like you're looking at a dashboard on a daily basis and be like, what where am I going on my journey today? You know, I I I would rather be notified if policies or, you know, standards are breached, instead of just constantly, you know, logging in here looking. But this this helps you to get insights on the realm to not only do cleanup, but to stay in that cleanup and make sure moving forward that, you know, you're you're practicing good hygiene. You know, this shows, for instance, groups. I've got 50 apps that are utilizing groups, a 86 that are not. I have one app that has a manager that's denied. So on and so forth. You get the point. And then users, kinda the same look and feel. The reason this is a a loss is because Quickbase staff does not count as a paid fee, and this is a Quickbase, realm. Over here, you can see number of users with denied status, how many super users I have, how many realm and then Zap creator, so on and so forth. So it just it puts this information in a quickly accessible way. And I think that anytime you can reduce clicks, from a UI perspective, you're winning, if you're getting the same result. So my goal really is to mitigate, the amount of research that you have to do to to get it some of this information. User tokens, same deal. This is kind of interesting. How many user tokens have no description? Well, I have 35 that don't have a description. Or, you know, all 55 of my my tokens are active. Five haven't been utilized since February. I click on my fuse range, for instance. I've got eight that have never been used, and that was actually filtered off of the the report that you just saw. But eight that have never been used, why do I have them? Right? So just that kind of analysis, if you go through these buttons and kinda clean up shop, it it just helps to, yeah, to to to quickly access, you you know, how many user tokens per user do I have, so on and so forth. You're gonna see that consistent look and feel through each of these tabs. So pipelines, you know, total active pipelines, I've gotten 95 that have never been triggered. Once again, why do I have them? Pipelines for pipeline owner, pipelines created within the last forty eight hours, told to have an active owner. Yeah. Download the application. You can drill into all this and and look at it and how it pertains to your realm. So I will go into an application and kinda show you under load what a record would look like, against a certain, application, for instance. So inside of here, let's go to this one. You can see it's got 690 users, nine user tokens, 13 connected tables, source connected tables, and then, 15 total. So if you go in here and view a record, you can see a handful of things up top. And for those that do have the DCA, I've updated the header. So when they when the screen squishes, if you will, or, scales, this stuff's all retained. Thanks, thanks, Anthrax for I don't have TPC too. So you can see you get this this header. There's probably 30 attributes up top, you know, that you've captured in this little header. Now you have tabs across the the bottom. These tabs only show if there's values associated with them. So if there were no users, this user tab wouldn't show. If there were zero user tokens, this user token tab wouldn't show. So on and so forth. But, yeah, you can see there's nine user tokens associated with this application. I don't I don't even know from a product perspective how you would get after that. Like, if I were to ask you how many user tokens are associated with this specific application? It'd be pretty hard to get that information. And here it is, readily available. Here's all the user tokens. And anytime you see a white button, that just will take you elsewhere within the application to another place, if you will. So if I click app manager, for instance, it's gonna actually take me to the users table, keep me within realm and site, and show me that user. So this user has honor one app they have access to, manage 61 apps, and 33 user tokens, 53 pipelines, six connected tables, so on and so forth. Same methodology. If they don't own anything and there are zeros, these stands won't show. I'm so excited to show you the auto log access, but I'll refrain for a second because that'll be the the the second portion of this for the folks that have seen this before. So quick navigation buttons, I think this is something to to keep in mind. There's not a ton for users, but when you think about quick navigation buttons for an app, I wanna look at the realm diagram. I click this. I just mitigated woah. Look at that crazy application. So, obviously, you know, because you you can scale and and and rearrange this and save that layout, but that would take you a lot of clicks to get to that space within here. You'd have to go to app settings, in app management, if I'm not mistaken, show relationship diagram. So now you can just get there within one click. And that's that's every application as all of these buttons that you could utilize and report as you see fit. Alright. It's really a lot to unpack, to showcase this. But, yeah. So that's that's basic navigation, in some of the feature and functionality. There's there's a ton of reports that I've set up, within each table. Yeah. So now I'm gonna gonna shift, and I'm gonna go in the audit logs. And this is what's coming at the end of the month. Thanks for all those who've been patient. Unpacking the audit logs table is just yeah. It's been fun. But it's it's a lot of information, and I hope you like what you see. And even reacting in the comment when you see this because I still have time to, to make little tweaks and changes, within the next fifteen days. But alright. So here's audit logs. Audit logs came about. It did come at the January. However, from a data perspective, we were kinda feeling stuff out. And I would say, really, by the March, we got a lot of the data. It's the, you know, not discrepancies, but, you know, maybe some fields didn't have URLs or, you know, all that. A lot of that got mitigated and, and rectified. So, had really about two months to to to put this into action. So this is the auto log step. There's not a ton on this, but I wanna break this down for you all. Create, update, and delete. When you think of IP, in general and I'll just search this real fast, fraud, IP. Read, update, delete. This is pretty important from a from an IT perspective. It's something that they know. They wanna be able to know what's being created, what's being what's being looked at, what's being updated, and what's being deleted. So what I did was, I I just created Todd, if you will. I didn't have any read actions. But, these are all create actions, update actions, delete actions. Obviously, it's only for the last two weeks. You know, you're gonna get a a pretty hefty volume of of of tables here or not tables of records. So just something to keep in mind as you scale, I, from a performance per perspective, wanna make sure that, you know, you have how do I say this? That you have just the information that you need, for maybe a two week window or whatnot. But you can you can set these however you see fit. But I did last two weeks so that this dashboard flows quickly. You know, obviously, you're getting into two years of data and this is querying all this. It's gonna take some more time. And also, what's the value of it. Right? Like, is it bringing value in the short term? Maybe not. And if you wanna delve deeper, you can. Alright. Act by user. So this just shows every action that a user has exercised, if you will. So one thing to note, and this link's gonna be provided to you, there is if you go to if you go to admin console, I just wanna show you all the actions that are included, in the audit logs. So you go to audit logs, and then you go to, accents here. This will take you to an application that is strictly around all of our audit log information. So all the blue items are the actions that are be captured in audit logs. I just click this typically. I'll click this blue button. Is it in ACC? Is it in the ACC table? Yes. It is. Alright. Here are all the actions that are available to you. Just coming into the admin console sync connect or admin console connection table. So that's all the ones that are available to you. And when you look at this, you need to start to really think through how could I utilize these. Well, I've I've kinda given you a jump start, if you will. I put I categorized all the create, update, and delete actions. You know, I've added some extra fields functionality so we can just sort of qualify these. Obviously, if I just click into this one, for instance, 470 create actions. I don't know if that brings value to you or not. I wanna see all the beautiful things that you guys will create from this. But this is a field create. This is what they did, so on and so forth. Here's the URL if you wanna go directly to it. Still working on stylings and all duds. Not yet. So we'll go through these. So action history history is this just shows you this is all of the actions and how many has been executed or, you know, added. And you can see how these are all the same. So this has only been loading for about two months. So after after two months, this number is gonna be the same. So there's been 2,383 field property accesses within the last three months on. And I'll get to this filter part, here momentarily. So that's that. I've actions by category and subcategory. So, hey, I just wanna see all my create. Okay. Here's all your create, pertaining to apps, fields. Like I said, I'm I'm trying to just plant some seeds here. I there's no way that I can extract all the good things that you could potentially glean from this. I mean, my thought is really just having, for instance, like, an algorithm of some sort that says, oh, look. These apps have not had recent actions. I have 211 act applications that haven't that don't have recent actions. Now the thing to keep in mind with these audit log actions is from a performance perspective, I made this table specifically to to control my time period of each each action. And and I'll show you this this sort of and it's, how how this works. So let's say, for instance, so you just saw 211 applications that have zero actions. All the actions that are in the audit log table, they have zero. There's none that have been so that would tell me maybe there's not a lot of movement in these applications. Let let me just take a look at this. Right? Like, nobody's creating anything. Nobody's updating anything. Nobody's deleting anything. Maybe it's an app I should delete. You know, just depends on the circumstances. Alright. So if I'm in audit logs, this table, application actions. And this is really important for you guys to to understand how this works. So these are all the applications and all the actions that I could find related to applications associated with them. Right? So we see the deletes, all the stuff. There's there's a bunch of stuff. However, these under the hood I'm just gonna tell you, probably getting into more than you care to know, but I like to give you details. There's a custom filter. It's equal to check. So what this means is is that this checkbox is checked, you're gonna actually see you'll see the actions associated with that specific action type based off of the filter that I set to drive this this activity. So let's look at field created, two forty eight for RV trailer PDI checklist. So if I go to my actions table, and I'm gonna show you how to get there here. It's just filters. It takes you to the same place. And we look for that specific action, two forty eight. I'm gonna change the filter range that I on field create, right now, it's giving me a month worth of data. Right? So if I change this to seven days, I just click that button, change it to seven days for field create. Right? It's it's eight because it's just one one day in arrears. So now if I go inside of here, we see that two forty eight. I click refresh. So when I click refresh, I don't know if that number will change or not. Let's hope it does. It didn't. So 248 still have been created within the last seven days. Now I can actually say, alright. Well, I just wanna see for the last day, for instance. Now I I I say that it's safe to say. So I can just put a I did a grid at it, so I'm gonna put two in here. And then I'm gonna hit save or apply changes. So now if I go back into here, I click refresh. Two forty eight is where we were. Hopefully, that is, the two forty eight. Zero. Zero fields have been where the that app and right here. Zero now. So these filters are super important. They drive they drive what you see in all of these reports. So it's just something to keep in mind. So if you look at application actions, I'm gonna go back and I'm gonna reset this to one month just because that's let's say it's important for my IT or whatever to have a month of data that you could just run a quick report on. So that'd be perfect. Right? So one month, I click this. Now they could actually audit to the last month of data that's warehouse inside of this, you know, obviously, this application actions. And you'll see how that that application that we, just showcased the the action for field create will be back. There it is at the top. 248. So you could just run this report or they can have their own dashboard and be like, we care about I don't know. How many relationships have been created, how many tables have been created within this certain time period. So just know that this drives all of that. Now we're gonna go one level deeper inside of this record. I'm gonna take you into let's just go here, for instance. So I'm viewing the application again. This is familiar territory, but there's a new tab here. It's called audit log action. Took me forever to fill. So click here to see records. So how many tables are created in this application based off of this filter? Right? So if I I just type table, for instance, these are all the actions that are available. It's got a one month period. So within the last month, there's been three tables created. These data points above are based on the filter set in the actions table, Adjust the days in the past field to determine what's displayed here. Do this by clicking a preset filter. Blah blah blah blah blah. That's what you're seeing here. The other piece is, if there's a number, you can click on it. And what does it do? It takes you into those three records. It will create. Here's what they did. Oh, I wanna go to that table. Cool. It will take you to that specific table. Yeah. Anyhow, pretty pretty cool. And then these, no entries available. That's just the dotted circles. So I'm effectively taking probably fifty, sixty actions and put it in this little this little widget here, if you will. And then NA just means there's not an action available within the admin console connected table. So there never be a value here. Do you know how many users have been invited to this application? Or, you know, based off of the filter. Right? Like, if I type user, user invite, that's on a thirty one day filter, and I click three. There's the three users that have been invited and who who they were and what application. And yeah. So you get the point. Right? And the same holds true if I click on to the app manager. Remember the white button takes you to this person. Click on this. I'm in the users table here. And now I click audit logs, actions, the new tab that I've added. You get that same same view. Persons created went to the table settings of these applications, 17 of them, over the course of what's, once again, set on this filter. So if I type table, table settings access, it's a thirty one day period that that we're we're seeing there. So I clicked on it. Here are the applications that have been accessed and what they are. And then there there is a a cool feature here where all of these I've I've been able to parse out user token ID, pipeline ID, table ID, and app ID from the URL. So I've already done that work for you. So actions with pipeline ID, for instance. These actions are available, and I've already mapped them to pipeline. Pipelines created, deleted, disabled, enabled, updated, and auto disabled. So all of these actions so let's look at pipeline update, for instance. You can start to see, like, why is this person updating the pipeline all the time? You know, maybe they are working through something. Whatever. Right? So you can you can kinda see. And like I said, I'm still working on the UI, but you get the point. These are I've mapped them to user token. The only the user token actions, I think, are yeah. Activate, create, deactivate, delete, and transfer. So those are all the actions that I'm capturing within the, the audit log table. Actions with table ID. So I've been able to map all of these to a specific table, and that's what these are. So for those out there who have evolved their governance core apps and added tables inside of realm and types, they could use this to map these specific actions against that specific table. So yeah. Yeah. I think that's find it. There's still more. So this is all actions. You saw that I made a new button here because there's just so much that I felt you could report on from a, audit log perspective. And like I said, it's not one size fits all. You figure out what's important to you. So I don't know if this time line would bring value to you or not, but maybe you wanna see all of this stuff within the last month, the activity around it. Right? So I click apply. I wanna see the last month. You see how these charts all change. Yeah. There's really a spike here, four eight. What the heck was going on here? Click here. Take a look at your audit logs. You're looking at it's thinking all these tables have been created. Right? You could organize this report as you see fit. You can organize it by application, so on and so forth. I left some of that work to you all just because, it's endless to keep to keep proofing this stuff out and building it. So I wanted to kinda keep it as simple as possible. This is kinda cool. All actions by day of the week. You can see that Monday is a busy day for us, collectively, and you would think that, but maybe there was just a spike. So maybe I just wanna see the last week and see if this this this changes. Right? Like, this report, it totally did. So it was just an anomaly or a lot of things were created one Monday. Somebody got real, you know, into it and wanted to build some stuff. But you can see that that's, you know, the stuff's not consistent. So, you know, this stuff that you can analyze and and take a look at. These are all the create actions that I could get a hold of. There they all are. These are all the update actions that I could get a hold of. And like I said, these are all. So this is gonna take a while to load as you continue to grow. So it might be something to think about. Here's all the delete actions that exist in their in all their glory. And then here's Realm. So these are Realm specific things like, oh, a service account was accessed one time, or there's been seven user token transfers, or somebody created a document document template, new group access, so on and so forth. These are more realm related. Like, oh, super user was assigned. You could get notified. Right? You just set up a notification. If one of these actions come across, you get notified. So that that's that's the power of bringing all this within Quickbase. But yeah. I know it's a lot to unpack. Thank goodness there's a recording. You'll get the deck. You'll get, some of the resources I alluded to. One thing, I I did put a blog post out there in the world, around, what's called a user agent. So the user agent is a pretty long string of stuff. If you look at user agent I don't have the link available. I think it's in the docs, actually. Let me see here. Oh, user agent. Here we go. Opening this up. This is the little blog post I did. There's a there's a field called user agent. And I just talked about how to break it down and what it means because some of the stuff might be important to your IT. You could start to see, like, oh, people are not all running the same browser version or they're using their cell phone versus their desktop, so on and so forth. So, that'll be provided to you also. But I'm I'm done presentation. Two minutes longer than I want it to be. But, yeah. What questions do we have, Evan, if any? Oh, there are absolutely questions. I got some for you. Alright. Let's go. So I got some good ones for you coming in fast. Someone's first one one of the ones that that things really make sense is someone had installed the Realm Insights app late last year before the audit logs and action stuff got added. How would they go about getting this stuff set up in their current version? What a great question. So glad that I didn't present this here. These are add ons. So my my goal, like I said, by the end of the month, you downloaded version one, let's say, of GCA. I'm working on creating a place that you can go to. It's, you know, it it's it's here. This is what it's called FAQ and enhancements. And the way that you get there is if you go into your realm insights, and this is regardless of the version that you have, I intentionally embedded it embedded it embedded this, click here. If you click here, it brings you to this page. Now I see all of this because it's not EOTI. I'm actually logged in. So let's go back. This is what your experience would be. So you can click here to enroll. And what enrollment is is you would just sign up to be notified when that new changes happen. Right? New add ons, so on and so forth. So that's that's one piece. What I'm trying to drive here too is, like, people have new ideas or, hey, there's an issue that needs to be fixed. If I collect all this in one space, then, you know, we can evolve this together. This is the ideas. So, hey, it would be nice if these things could happen. This is patches and updates. So there's been three things that have been discovered that would be ideal to to, you know, to fix within your application. None of them are gonna, like, break anything, but just for from performance perspective, it's stuff that I would say, long term. Short term, I should say. And if you look here, this is what the question was about. So transfer user token, for instance, is an add on. There was a new functionality added for user token transfer. This is actually available out there to you folks now. But if you click on resource, resources, or, you know, let's say what the record looks like. If you view this record, this contains all the stuff that you would need to lift it up from where you are to this next feature or functionality. And with audit logs, which is add on five, which I'm still working on, that is gonna prompt the version two of GCA. Just because what you just saw is just there's so many assets that are associated with it. Right? In this situation, transfer user token includes these assets. So it affects two apps. There's a code page. There's fields, forms, so on and so forth. So if you click on resources, the thought is is that because you signed up, right, you enrolled, filled this out, said notify me, which 24 people have thus far from Empower. Thank you all. Sorry. I'm a little delayed on this, but auto log says yeah. It's been fun. So if you look at add ons yes, I know that. Alright. So click view. You can you get the instructions to to download or to to install this or, obviously, you know, if you have service hours, we could we could help you install it, take an hour or two. This one in itself takes probably about an hour to install. Obviously, this isn't ideal. It's manual. I would love to be able to click and deploy with the solutions API to everybody's realm that's subscribed as long as, you know, the foundation's ready to receive it. So hope that answers the question. Not here yet. And I'd be more than happy to take a look at your application and be like, maybe we just download the version two. Right, to to make it easier if you haven't built a lot of things around the, you know, around the fringes of the the the version that you have. Great. I have some other questions for you. So I also had one coming from David. He was curious. If he's already built an app that pulls in the user list table, so if he's used the, admin console sync to pull a table somewhere else, will that prevent him or will it cause him any troubles from building a GCA app and using it to pull on the data? Yep. Once again, you can contact me. But in in short, what you would do is you would run a pipeline. You would disconnect that table and just run a pipeline that comes from here and just update that with whatever cadence you have. So nothing from a data perspective. The integrity wouldn't be affected. It would just be updated with a different mechanism. So And the Yeah. One was curious. John was curious to the follow-up. Does this work when you have multiple accounts on your realm? So can you use the GCA or, like, is it gonna be a different experience if you've got multiple accounts under your realm? So we're running into this right now, with the client. So if it's a realm and there's multiple realms under your realm, it will work fine. If they are accounts, which are they act as realms, but they're called accounts, They don't even have access to these tables. And I know it's something that product's looking into, but I don't really know. In your specific instance, in a dream state, each realm would be associated with kind of a, you know, a top level realm. And all of those would be capable of having the GCA, and then maybe that top level realm gets, you know, gets a sample set or, you know, summaries of all that data in one in one application. So I'd have to look at the infrastructure. That could be a takeaway if you wanna email me. We'll provide the email, and then we can follow-up and see see what your current situation is. But if it is a true account, they don't have these currently. But if it's a realm and you have multiple realms, then that's totally doable. Awesome. And then Curtis had the question of how long would you estimate that it takes to set up or configure the GCA initially? Like, what is your what is your original investment of time? No. Great question. So I've had people install in an hour. You know, and I don't know if anybody that's on this call could speak to the direction or how it works. But, yeah, I've had people that have little experience in building Quickbase applications. They follow the instructions. And, you know, this is probably the hardest part. Once you create this, you know, that probably takes thirty minutes. And then after that, it just it builds all your pipelines and you download some apps from the Exchange to roam the site to roam longer. So I'd say about an hour. Awesome. And then I had someone Sean had a more specific question about when you're pulling events over for users, how does it how about when the users were given access to an app via a user group? Is they start are they still able to see that? Does it look different? Yeah. Yeah. Yeah. Great. Great question. So once again, we'd we'd wanna take a look at the the the specific action that that's triggered by that. Right? So what's coming across right now are these blue, actions. Now if you have enterprise, you can pull from an API perspective. You could pull any of these acts that are available. Right? So group access grant, group access for vote, so on and so forth. These are actually available in ACC. Access grant. Revoke, update, group invite. I think user invite, access update, access grant. So we'd have to kinda look at that, one off and and just try to see if one of those actions is triggered based off of what you're what you're alluding to. But I would recommend taking a look at this, this application, which is accessible to you through the, audit logs and admin console. And one thing I added here, click here for spreadsheet. You click this, and this will actually give you all the actions that are available in sort of a little definition. So I'd start there, see if it's available. And then if it has that checkbox, it's available in the admin console connect tables. If it is an action that's not available, you can get it get at it by either downloading that specific action, you know, from from your auto logs tab in, in admin console, or you could utilize an API to pull that specific action. Now a lot of IT folks, for instance, wanna see login fail. That's that's a lot of data. Right? So just be mindful. I want all the actions. Well, you might need a bigger database to warehouse it because, you know, if I gave you every action within that admin console connected table, it would reach capacity for some clients within two days. Cool. And then, Kelly had a question which was, would it be difficult to configure this to use on a single or a few select apps versus all the realms apps? Well, it would just be a filter by report, because you're gonna get off. But say, for instance, you're you're solely concerned of your tier ones or something to that effect and you have, like, a different mechanism or a way you get after it, you could reconfigure this to filter everything else out and actually put like, you're gonna get all the data. Now if you wanted to I just don't I don't know what the use case is. It would it would be good to to kinda talk through that. But you could filter these tables to just say, I only wanna include these handful. But I would caution, you know, if you're thinking departmental or bring them all in and then filter them based off a report. Yeah. I was imagining you could build a dashboard specific to that app. Oh, okay. Oh. That way you can have your, like, tier one most important map gets its own. Yeah. Yeah. Board of data. I think it's Oh. Yeah. And it also I think it relates to, to, we recently released in app audit logs that some of you may have missed because it just came with the launch. But, now inside of each of your applications, you're as an app admin, you can actually see audit logs for that specific, application. It's under app management. And it's actually it's tricky. I told them they need to move it, but it's the, like, the very bottom of the app management page is an option option to see the auto logs for just this application. Super great for if you're an app admin and you wanna be able to narrow your focus or if you come from a big account and you're like, oh, it's oh, it's so hard to, figure out how to parse all this data, you can just jump right in. And, it'll give you an app access to the audit logs that are sort of for your application. Yep. It also can be really helpful if you're not a Realm admin, but you would like to see some of these insights for one of your apps. You can do that as the app admin in the app. The only thing you'd wanna make sure to chat with one of your Realm admins about, if you wanna track data changes, they just have to turn that on for you. They They have to turn that on in the account to say that this app tracks data changes, but you can get a lot of the stuff with user accesses, records or reports being updated. It's really awesome. I've been using it in a couple of my apps just to figure out, like, what stuff's getting used. Yep. But it's just kinda hidden right now. Yep. What else Sam's got one if you work for a large corp and not a realm admin. Is the TCA app still worth it? I mean, depends on if you're managing your entire realm. If you just wanna see the apps that pertain to you, I think it would be worth it. It's pretty good to just know what the heck's going on in your realm. Like, what kind of sprawl? Because more sprawl, those are more points of failure, more risk. Right? So run a tight ship. And, you know, even in concert with your realm admin, talk to them. You you don't as a realm admin, you have to be a realm admin to get these set up. But then once that's set up, you don't you don't need to be a real madman per se to see all this information. I would just keep it limited to the people that need to see the entire, infrastructure of the of the realm. Anything else, Evan? You got any more? I think we've hit all the questions that we have that come in when I look through the list, which is good because we made it to exactly 02:00. So I feel like we we ran exactly the time. Yeah. Just to let you all know too, like, I'm gonna start really teasing out each of these areas and kinda talking through them. So stay tuned. Try to do more of these webinars because I think it's just beneficial to kinda obviously get it recorded and get support documentation around it, but get your feedback too and make sure I'm moving in the right direction. Alright. So it seems we have a good we hit a good place to wrap up. Thank you everybody for joining us today. Just a little bit of housekeeping, you all can access this recording on demand using the link you used to join us today. It'll be available in about an hour once everything gets to process. Otherwise, you'll also get an email tomorrow with your link, and you'll be able to find on our events page should you wanna share this with anybody else. We obviously encourage you to do it. Example, Shane, if you want to convince your realm admin to help you with this, maybe you wanna send them this webinar and tell them they should check it out and see what they're missing out on. Otherwise, we hope you'll join us for our future webinars, which you'll get some more information on as follow-up. Thank you so much for joining us today. Thanks, everybody.