I'm looking at importing AD groups into Cherwell but I want to exclude one nested OU from the import. I've attached an image displaying what is in our Application OU. I want to exclude all UAT groups from the import if possible. How do I go about doing this?
Hi Ashley - Do you mean you want to import Active Directory User Accounts in from AD but exclude accounts which are located in that nested "UAT" OU folder? If it is user accounts my other assumption is that you either are importing your entire directory (or want to) OR just want to import all user account below the "Application" OU. Can you confirm?
I'm wanting to import AD groups from within Manual Installs, Restricted and Unrestricted into one lookup table. Excluding all that are in UAT currently. If it helps, all of the groups within UAT end in _UAT. So if there's a filter to incorporate that function perhaps. Open to suggestions though.
Well, good news and bad news - the good news is yes this should be possible to complete. The bad news is you will not be able to complete this in Cherwell alone. I have done something similar actually querying Office 365 group distribution lists, consuming the lists and members and even updating and modifying them. It required that I create and execute PowerShell scripts on the fly within a OneStep, save the executed PS results as a CSV file locally on the Cherwell Server, then create and run another PowerShell script to push data back to the group DL. This was almost entirely accomplished in the Blue Client. Another thing to note is we are on Prem so if your are hosted you may not be able to easily query, save and manipulate items.
If you are hosted you may have to run PS scripts locally and then import them manually to work with them.
Did you do the import of CSV file to lookup table via blue client? If so can you please provide the steps to do it? I can guess how to do the operations via orange client, but have no idea how to do it with blue client
Hey there Evgeniy - Here's how I do it:
1. Create a Search which grabs records you want to put in a CSV.
2. Create a new OneStep, Set the Conditions to use the Specific Search created in step 1.
3. Add a block in the OneStep to "Run Another OneStep"
4. In this block call/create another OneStep and then add a "Write to File" block
5. Set the Path and Filename and extension of .csv with Format of "Plain text" and make sure "overwrite existing file" is NOT Checked.
6. in the Contents section place your variables or Business Object fields you want to capture in the CSV. At the end of the line after the final comma, place a carriage return.
7. Be sure to go to the "Pre-steps" tab in the OneStep and Add your column headers names with commas after. Be sure to put a carriage return at the end after your last comma. Make sure Overwrite existing file IS CHECKED on this tab.
8. Click OK/save both OneSteps.
Run the OneStep created in #2 above. it will step thru your search and grab the data you selected from each record one line at a time. At the end you will have as many lines in your CSV as you have number of lines in your search grid, but only will be showing data for the items selected in #6.
Hope this helps as I typed this up quick...