Dynamic account

Showing results for 
Search instead for 
Do you mean 
Reply
Participant III
Posts: 20
Registered: ‎10-13-2018
#1 of 3 221
Accepted Solution

Dynamic account

Dynamic account

 

We need to create a SET of accounts where we want to group all accounts that start with "OUT", would anyone have this script?
I think the column used is target.

 

Is it possible to have more than two variables? Do we need to add accounts that start with OUT and AEX?

Highlighted
Centrify Guru I
Posts: 2,388
Registered: ‎07-26-2012
#2 of 3 219

Re: Dynamic account

[ Edited ]

@TiagoToledo01,

 

Let's teach you how to fish.

 

Earlier this year we created a WYSIWYG-driven SQL Report builder.  This comes handy in these situations.

The location is Core Services > Reports > New Report.

 

Getting Started

You're looking at the server table. We start by checking-off some fields (ID being the most important) and name.

server1.PNG

Note that the SQL statement is being built automatically on the other side.

 

Filtering

In your requirements, you need systems that start with OUT and AEX.  I will use in my example "dc" and "mem" since I don't have systems with those names in my test environment.

 

For this I click on the filter icon next to Name and add the proper filters.  Note: for this to work, I used the OR statement. Otherwise you'll get no results.

filt2.PNG

 

The SQL at this point, looks like this:

results.PNG

 

At this point, you can preview to see if the results thrown are the ones you want.  In my case, remember, DC and MEM.

res2.PNG

What you have accomplished?  You have the SQL query for your dynamic set.  All you need is to select the ID field.

 

Set Creation

Create the Set as Dynamic and See your Results.

final.PNG

End Result

tiago.PNG

 

I hope this helps.

 

Now, if you're a customer and received your training, remember that Dynamic Sets are organizational only.  This means that they can't be used for automation of member permissions.  Static Sets are the way to go here.

 

Finally, it looks like I misread your post and you're looking for an account set.  Same process but you're looking at the VaultAccount table.

 

 

R.P

Want to learn more about practical Centrify examples? Check out my blog at http://centrifying.blogspot.com
Follow Centrify:
Participant III
Posts: 20
Registered: ‎10-13-2018
#3 of 3 205

Re: Dynamic account