![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/q-for-powertip.jpg\" "\\"Hey,")
\n <\/P> \n
Hey, Scripting Guy! I\u2019m using the Win32_ComputerSystem class to get the name of the logged-on user. The name comes back formatted like this: Domain\\Name<\/I>. How can I extract just the user name? Hey, KW. As our much-beloved and highly-respected editor reminded us the other day, instead of spending all our time telling people how to extract paragraphs formatted with a specific style from Word documents<\/B><\/A> we promised that every now and then we\u2019d take time to address more basic questions. Having made that promise we then just as quickly forgot about it. (But, in our defense, it\u2019s awfully hard to resist the thrill and excitement that comes with extracting paragraphs formatted with a specific style from Word documents.) <\/P>\n So we\u2019ll make amends today. As many of you know, you can use a simple little script like this to determine the user currently logged-on to a computer:<\/P> Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)\nSet colItems = objWMIService.ExecQuery(“Select * From Win32_ComputerSystem”)<\/p>\n For Each objItem in colItems\n Wscript.Echo objItem.UserName\nNext\n<\/PRE>\n Note<\/B>. One caveat. This works pretty good on Windows XP and Windows Server 2003. On Windows 2000, however, it always returns Null unless an administrator is logged on to the computer. Therefore, this is not the answer to the age-old question, \u201cHow can I determine who\u2019s logged on to a particular computer?\u201d (Unless, of course, all your users happen to be local administrators.) Unfortunately, there\u2019s really not a good answer to that question.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>\n As KW noted, though, the value of the UserName<\/B> property comes back looking like this:<\/P> That\u2019s fine if you want both the domain name (FABRIKAM) and the user name (kenmyer). But what if you want only the user name? How can you separate the user name from the domain name?<\/P>\n Believe it or not, this is pretty easy. With the UserName property the domain name and the user name will always be separated by a \\. This, by the way, is true even if the user is logged on locally; in that case the computer<\/I> name and the user name will be separated by a \\:<\/P> Because of that we can use the VBScript Split<\/B> function to split the UserName into an array; all we have to do is tell the Split function to split the name at the \\. That will give us an array consisting of two pieces: the domain name and the user name. All we have to do then is echo back the second piece – the user name – and we\u2019re in business.<\/P>\n Confused? Let\u2019s take a look at the script and then we\u2019ll walk you through it:<\/P> Set objWMIService = GetObject(“winmgmts:\\\\” & strComputer & “\\root\\cimv2”)\nSet colItems = objWMIService.ExecQuery(“Select * From Win32_ComputerSystem”)<\/p>\n For Each objItem in colItems\n arrName = Split(objItem.UserName, “\\”)\n Wscript.Echo “Domain: ” & arrName(0)\n Wscript.Echo “Name: ” & arrName(1)\nNext\n<\/PRE>\n We begin by connecting to the WMI service on the local computer. (Although we could just as easily connect to the WMI service on a remote computer. To do that just change the value of the variable strComputer to the name of the remote computer.) We then use the ExecQuery<\/B> method to retrieve all instances of the Win32_ComputerSystem class (there will be only one such instance).<\/P>\n Next we set up a For Each loop to walk through all the instances of the Win32_ComputerSystem class. In the first script we showed you – the one that echoed both the domain name and the user name – all we did in this loop was echo the value of the UserName property. This time we\u2019re going to do things a little different: we\u2019re going to use the Split function to create an array out of the UserName property. This line of code splits the UserName value at the \\ mark, and creates an array named arrName:<\/P> Incidentally, the Split function will split a string as many times as needed; that is, as many times as it finds the target character (in this case, the \\). For example, suppose we had the following string:<\/P> If we run the Split function against this string our resulting array will actually have four elements:<\/P> With the UserName property we\u2019ll end up with a two-element array, something like this:<\/P> In an array, the first element (FABRIKAM) is always element 0; the second element (kenmyer) is always element 1. To echo back the domain name, we simply echo back the value of element 0; to echo back the user name, we simply echo back the value of element 1. That\u2019s what we do here:<\/P> That\u2019s all we have to do: we can now echo back just the domain name, just the user name, or both. And best of all, our editor will quit bugging us about addressing basic scripting questions.<\/P>\n At least for awhile anyway.<\/P>
— KW<\/P>![\"Spacer\"](\"https:\/\/devblogs.microsoft.com\/scripting\/wp-content\/uploads\/sites\/29\/2019\/05\/spacer.gif\")
![\"Hey,](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/a-for-powertip.jpg\" "\\"Hey,")
![\"Script](\"http:\/\/img.microsoft.com\/library\/media\/1033\/technet\/images\/scriptcenter\/ad.jpg\" "\\"Script")
<\/A> \nstrComputer = “.”<\/p>\n
\n<\/THEAD>\n\n
\n \n <\/DIV>\nFABRIKAM\\kenmyer\n<\/PRE>\n
ATL-WS-01\\kenmyer\n<\/PRE>\n
strComputer = “.”<\/p>\n
arrName = Split(objItem.UserName, “\\”)\n<\/PRE>\n
element_1\\element_2\\element_3\\element_4\n<\/PRE>\n
element_1\nelement_2\nelement_3\nelement_4\n<\/PRE>\n
FARBRIKAM\nkenmyer\n<\/PRE>\n
Wscript.Echo “Domain: ” & arrName(0)\nWscript.Echo “Name: ” & arrName(1)\n<\/PRE>\n
\n\n
![\"Top](\"http:\/\/www.microsoft.com\/technet\/mnplibrary\/templates\/MNP2.Common\/images\/arrow_px_up.gif\"){kind=icon}
<\/A>