I had a report somewhere for that. I'll see if I can dig it up... -Phil
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Tuesday, April 22, 2014 11:32 AM To: mssms@lists.myitforum.com Subject: [mssms] RE: Get the SYSTEM_OU_NAME without the duplicate rows I literally had the same issue last week, and just filtered in Excel for the sake of time. Would love to see some SQL magic to do the trick. Daniel Ratliff From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Krueger, Jeff Sent: Tuesday, April 22, 2014 11:25 AM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] Get the SYSTEM_OU_NAME without the duplicate rows Does anyone have any SQL Fu handy that will give you the longest value in the dbo.v_RA_System_SystemOUName? Trying to put together a report where I want to add the OU a system is in but that view has separate rows for each sub ou a given system is in. Jeff Krueger IT - Endpoint Design Services Henry Ford Health System jkrue...@hfhs.org<mailto:jkrue...@hfhs.org> 248.853.4466 ________________________________ CONFIDENTIALITY NOTICE: This email contains information from the sender that may be CONFIDENTIAL, LEGALLY PRIVILEGED, PROPRIETARY or otherwise protected from disclosure. This email is intended for use only by the person or entity to whom it is addressed. If you are not the intended recipient, any use, disclosure, copying, distribution, printing, or any action taken in reliance on the contents of this email, is strictly prohibited. If you received this email in error, please contact the sending party by reply email, delete the email from your computer system and shred any paper copies. Note to Patients: There are a number of risks you should consider before using e-mail to communicate with us. See our Privacy & Security page on www.henryford.com<http://www.henryford.com> for more detailed information as well as information concerning MyChart, our new patient portal. If you do not believe that our policy gives you the privacy and security protection you need, do not send e-mail or Internet communications to us. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information. ________________________________ PRIVILEGED AND CONFIDENTIAL. This email and any files transmitted with it are privileged and confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. If you are not the named addressee you should not disseminate, distribute or copy this e-mail or any of its attachments.