We have a list of valid Sites in Remedy. A team member made the decision to turn off all location info from AD and just authenticate to AD. All new/modified records from AD will read “Update ” in the staging table. We do not have data admin. This would raise a question – How are the Remedy records going to change from “Update” to the actual Site Location? Manually? Are there any people who are not using AD to locate the Site? Normalizing the data does not apply here – because AD location info is being disabled. Any suggestions on this approach? *** Date: Thu, 26 Mar 2015 16:28:12 +0000 From: "Hennigan, Sandra, CTR, DSS" <[email protected]_ (mailto:[email protected]) > Subject: Re: Major Issue: AD Remedy
The Site is required to add a new CTM:People record. If using ARDBC, create a staging form. Push AD data to the Staging form. In Remedy, for each Company whose data comes from AD, add a default Site - something like "Need to Update". Using workflow, update your Staging form records with the default Site by Company instead of what AD holds. Have the Staging form push the completed data set to CTM:People. Use a "Need to Update" search against CTM:People to return which records to update. By choosing to change AD data manually for Remedy, the Remedy admins end up "owning" data. No one else is required to consider data integrity. WRONG approach. See if you can get your customer to designate a data owner and determine the data gold source. Push AD data to your Staging form. Run some workflow to normalize the data from what AD presents to what Remedy needs. Push the data set to CTM:People. Run reports and use CTM:People data content to require a change to AD. Example: AD Office field reads Alex and Remedy Site needs to have Alexandria. Create workflow against your Staging form to modify Office = Alex to Site=Alexandria prior to pushing the data. Thank you, Sandra -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Koyb P. Liabt Sent: Thursday, March 26, 2015 11:32 AM To: [email protected]_ (mailto:[email protected]) Subject: Major Issue: AD Remedy ** Hi, We have some bad data in AD. Our team plans to disconnect the location information that we are receiving from AD, and upload new location information into Remedy from a spreadsheet. From that point location updates will be done manually, but authentication will still continue between AD and Remedy. I have never not seen AD location information used. I see this leading to a Remedy administrative manual effort. Does anyone have any thoughts, or things that we need to be warned about? Is anyone not using some type of repository to load the People location data? _ARSlist: "Where the Answers Are" and have been for 20 years_ ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at _www.arslist.org_ (http://www.arslist.org/) "Where the Answers Are, and have been for 20 years" ------------------------------ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
