Display FirstName Lastname - Users Online Module [Lead: Scott McCulloch]

Forum DotNetNuke® Pro... Users Online Mo... Display FirstName Lastname

1/23/2006 2:15 AM

	Darren Lock
4 posts

Display FirstName Lastname

Would it be possible to have the module display FirstName/LastName as our users are all Intranet users and their Usernames are obscure domainname/personnel number.

7/26/2006 8:59 AM

	Andrew Proctor
1 posts

Re: Display FirstName Lastname

I managed ths by making a small change to the stored procedure dbo.GetOnlineUsers. I changed this:

SELECT
    UO.UserID,
    U.Username

To this:

SELECT
    UO.UserID,
    U.DisplayName AS Username

Probably not an ideal way of doing it, and it'll almost certainly get overwritten at the next update, but for now it works for me and displays wahtever I have in the Users.DisplayName field for that user (for me, its Firstname & " " & lastName)

HTH

7/26/2006 12:58 PM

	michael jackson
172 posts
Brillnat.com

Re: Display FirstName Lastname

If you don't want to mess with the module code, you could put the following sql statement into the reports module (dnn4)

something like:

select u.Firstname, u.LastName from usersonline as UO inner join users as U on UO.UserID=U.Userid where UO.PortalID=0

(change the portalid to your portalID in the example)

Or I have a module that is similar to the text.html module but allows data access and you could put that query into it and then format the output anyway you like.

Michael Jackson
Brillnat.com
Custom module development
Database access tokenized HTML modules

Page 1 of 1

Forum

DotNetNuke® Pro...

Users Online Mo...

Display FirstName Lastname