WMI Query

[Adam_Brown]

Hi guys,

I'm wanting to use, the Sysinernals App BGinfo, to display some info on the desktop (who'd of thunk it!)

One of the thinks i want to to display, is the name of the currently logged on user. Ive found this peice of WMI, but Its not working in BGinfo, any ideas?

SELECT FullName FROM Win32_NetworkLoginProfile WHERE LastLogon=(select max(LastLogon) FROM Win32_NetworkLoginProfile)

It's most likely something really simple!

[+BudMan MVC]

And the builtin UserName is not working?

why do you think you need to do a wmi query, when it has a builtin username you just click add on.

edit: Ah -- you want to pull the "fullname" just the account name. I'll take a look see.

edit2: Ok I think I found the thread found your info from.. Why not just use the vbs script the guy posted

http://forum.sysinternals.com/forum_posts....D=6669&PN=1

I tested this -- and works on my machine great.

I took the time to flesh this out into a proper script.

' ======================================
On Error Resume Next
Dim colWMI, objItem, colQuery, strUserID
Set colWMI = GetObject("WinMgmts:root/cimv2")
Set colQuery = colWMI.ExecQuery("Select UserName FROM Win32_ComputerSystem")

For Each objItem In colQuery
	strUserID = UCase(objItem.UserName)
Next

Set colQuery = colWMI.ExecQuery("Select * FROM Win32_NetworkLoginProfile")

For Each objItem In colQuery
	If UCase(objItem.Name) = strUserID Then
		WScript.Echo objItem.Fullname
	End If
Next
' ======================================

I probably could have made it smaller, but it works.  For purposes of BGInfo, you'll need to replace the one "wscript.echo" with just "echo".

This command doesn't access ADSI, instead getting everything from WMI.

--Magic--

Just save in a filename.vbs file -- add in bginfo.. Just change the one line WScript.Echo to Echo and works perfect.

Edited July 28, 2008 by BudMan