Office Hours: INOW Database Querying

This month’s Office Hours features INOW database querying for Perceptive Content (ImageNow). This presentation includes live demonstrations of common database querying that can help you troubleshoot user or content issues, build custom reports, or just get a better understanding of the relational structure of data and content inside ImageNow.


Okay. Let’s get started. Quite a big audience today. Welcome to RPI Office Hours. This is our second monthly webinar series. This one is a little bit deeper dive into querying the ImageNow database. Let’s have a real quick slide deck and then we’ll jump right in. I’m going to really glade through these. First, just a little bit about us, almost all of you know this information already, RPI is a professional services firm specializing in the Infor products as well as Kofax and Hyland, which we are partners with Hyland. Our headquarters are in Baltimore, however, we do have additional offices in Tampa and right here in Kansas City. We offer the entire array of professional services offerings.

We are, for Hyland specifically, very experienced with Perceptive Content, which we’re talking about today, enterprise search, Brainware, and on-based across a variety of vertical decisions, so virtual tables, higher education, healthcare, manufacturing, et cetera, et cetera. We’re extensively experienced across our team.

Most of you know me. My name is John Marney. I’m the manager on our team of consultants, developers and project managers working with ImageNow for over eight years on top of the other workload solutions that we offer, Kofax TotalAgility and OnBase and others. And I am a new father, almost five months old.

Upcoming activities with RPI. In September, as part of our webinar Wednesday series, on September 4th, we have, in the morning, Migrating Your Enterprise Content Data to the Cloud. What this is going to go over is, especially for you perceptive content folks, you wanted to have your OSMs or your database, like an Azure server or something like that, the ability to set that up and integrate it with your existing environment. Then, in the afternoon, we have a presentation on What’s New in Kofax ReadSoft Online. ReadSoft Online is a subscription-based invoice processing solution, which we’ve deployed quite a few of, and it’s really cool. This summer, they did a new release with a lot of new features.

Other events that we have coming up. We are hosting a two-day workshop, it’s free, right here in our Kansas City office, October 8th and 9th for Kofax robotic process automation. It’s training and hands-on, includes some food. The only thing you have to pay for is to get here and stay here. We are already over halfway full from registrations. If you’re interested at all, please go get signed up. We’re evaluating doing a second session if we go over capacity.

Then, please come see us at CommunityLive in September. We are having a happy hour on Monday evening at Bar 32, which is at the top floor of the hotel where the event is taking place. Please go register at and come say hello to us. I’ll be there.

Finally, for our Infor clients, RPI will be an Inforum September 23rd through 26th. If you’d like to schedule some time to meet with us, please go to our website There’s a handy dandy scheduler right there.

Okay. So, that’s most of my slide deck. Let’s get into this.

What are Office Hours? And what are we doing today? Office Hours are really whatever you want them to be. It can be as informal or formal as you need. It is a demonstration. It’s our training. It could be helpdesk, if you’re encountering some difficulty that you are encountering that you’d like a help with. It’s a working session. It can be fairly technical. Especially today, if you don’t have any SQL knowledge, you may get a little lost. There will be frequent rabbit trails and other topics, and that’s perfectly okay. I want to cover the things that are most beneficial to the audience. Hopefully, a little bit of silliness. I don’t take myself too seriously I don’t want you to take me too seriously. And it really can be whatever you want it to be.

Final slide, I’m not responsible for your actions. I say this because I’m going to give you knowledge to empower you to go conquer your ImageNow database, but if you take that and go crazy with it and delete a bunch of stuff that you shouldn’t, then I’m not taking responsibility for that.

Practice safety first. Select statements in your production are probably okay as long as they are returning to future data sets. Don’t run inserts. Don’t run deletes. However, if you ever get into a situation where you think you need to, I’m happy to support you in doing so. And it’s always better to go use your test environment as playground than in doing things in production. Learn from my example.

Okay. I’m going to hop over to my virtual machine where I have some stuff prepared. Okay. I’m hanging my shared screen. There we go. Okay. Please, please, please, I’m going to do a quick demonstration of a couple basic queries, but at any point please just pop in throw questions into the GoToWebinar and I’m happy to take question