This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have one saved search with the last login of users (columns: user id, last login date), and a second search with the universe of users (user id, entity id). *I want to JOIN both saved searches*. What's the best way to do it?

(Note: I need the second search because the first one doesn't get the users that have never logged into NetSuite)

This company offers a free bundle for user license management that tracks last successful login, stale users, license type usage etc

<https://www.mgbcpro.com/bundles|https://www.mgbcpro.com/bundles>

I think you just search MGBC user license management and it’s free to download

(It sounds like that’s what you’re trying to achieve at least)

Also there a Login Audit record join at the bottom of the fields list in an employee search that should help you join login data with employee data in a search

Neat! Very useful, currently testing it in Sandbox :slightly_smiling_face:

<@U01C2BDKR1R>  Good to hear, glad you liked it.....I just sent you a DM earlier I had a different question for you about workflows if you don't mind