Hi, I've the below request from one of our Developers, I'm not sure it's something that I'm able to do.
If so, anyone know the script??
Can a database view be created in the Ivanti database with the following information? The database view should list only active user information. Same user should have multiple records if the user has multiple levels of access. The key data that would be required is:
- Details that identify the user (First Name, Last Name, Full Name, User ID, E-mail Address)
- Details that identify the access level i.e. what the user can do within the application
o Access level names, e.g. Administrator, Self Service, Analyst, Change Manager, Configuration Manager, Problem Manager, License Manager etc.