select sys.Name0, sys.Full_Domain_Name0, OS.Caption0 from v_R_System sys INNER JOIN v_GS_OPERATING_SYSTEM os on os.ResourceID = sys.ResourceID where OS.Caption0 like '%server%'
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, August 30, 2016 12:45 PM To: mssms@lists.myitforum.com Subject: Re: [mssms] RE: Help with a few SQL queries Server names for 1 and Computer names for 2. Thank you! Brian On Aug 30, 2016, at 12:37 PM, Marcum, John <jmar...@bradley.com<mailto:jmar...@bradley.com>> wrote: What do you want to know? Just the computer names for 1 and 2? From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Brian McDonald Sent: Tuesday, August 30, 2016 12:25 PM To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com> Subject: [mssms] Help with a few SQL queries Hello, I need to compile a few reports. 1) List of all servers by domain 2) All Office 2013 with x86 Architecture Does anyone have any samples they can share for each of these? Thanks, Brian ________________________________ Confidentiality Notice: This e-mail is from a law firm and may be protected by the attorney-client or work product privileges. If you have received this message in error, please notify the sender by replying to this e-mail and then delete it from your computer.