myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Join computer name, user name and full user name?

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Join computer name, user name and full user name? Page: [1]
Login
Message << Older Topic   Newer Topic >>
Join computer name, user name and full user name? - 9/8/2008 3:49:11 PM   
Winston Smith

 

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline 		Mgmt wants me to generate an inventory report that shows (among other things) computer name, user name and full user name. We had a consultant in about 8 months ago that said it would be a breeze, but he slipped out the back door without actually delivering.

This thread deals with a related issue, but not what I'm trying to do.

Basically, what he wants is Hardware Inventory Report 01A but with the additional elements of 'user name' and 'full user name'.

Anyone able to do anything like this successfully?
Post #: 1
RE: Join computer name, user name and full user name? - 9/8/2008 4:45:24 PM   
rtruss


Posts: 250
Score: 11
Joined: 11/4/2004
Status: offline 		Are you using SCCM or SMS?

Here is how you can get the user name (userid) in your report.

Add v_R_System.User_Name0 as "AD Logon ID" to your report.

I don't do a whole lot with SMS reports, we usually create our own via SQL calls from vbscript.

_____________________________

Roger Truss
Assistant Windows Administrator
SMS Admin
Trend Micro Admin
ImageUltra Admin

Please rate my post ;)

(in reply to Winston Smith)
Post #: 2
RE: Join computer name, user name and full user name? - 9/9/2008 12:10:01 PM   
mreavis


Posts: 778
Score: 77
Joined: 9/10/2002
From: Olathe, Kansas
Status: offline 		1st you need to ensure that you are bringing the users name in your AD User discovery. this will depend on how your AD is setup. I recomend user AD Explorer to verify that you have the correct AD Attributes in your discovery.

once you have the informaiton in the database, you will need to join v_R_User to one of the tables in your report, then add the appropriate field from the table. I use the Full_User_Name0. As for how to do the join, not sure what you are starting with, but if you post your existing query, I am sure we can guide you.

_____________________________

Michael Reavis
SMS Admin
MCSE, MCDBA, MCDST
Johnson County Goverment

(in reply to Winston Smith)
Post #: 3
RE: Join computer name, user name and full user name? - 9/16/2008 4:57:10 PM   
Winston Smith

 

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline 		The following syntax displays the web report I have been trying to create

select
    VRS.Name0, VRS.User_Name0,
    VRU.Full_User_Name0
from
    V_R_System VRS,
    V_R_User VRU
where
    VRS.User_Name0=VRU.User_Name0

(in reply to mreavis)
Post #: 4
RE: Join computer name, user name and full user name? - 9/16/2008 4:58:05 PM   
Winston Smith

 

Posts: 53
Score: 0
Joined: 12/18/2007
Status: offline 		My next task will be to merge that into the HArdware01A Report. any suggestions? :)

(in reply to Winston Smith)
Post #: 5
RE: Join computer name, user name and full user name? - 9/16/2008 5:17:13 PM   
mhudson

 

Posts: 537
Score: 12
Joined: 4/1/2007
From: College Station, TX
Status: offline 		You will need to do an inner join based on ResourceID



_____________________________

Matthew Hudson
http://sms-hints-tricks.blogspot.com/
http://www.sccm-tools.com

(in reply to Winston Smith)
Post #: 6
RE: Join computer name, user name and full user name? - 9/17/2008 11:07:26 AM   
jkaiser

 

Posts: 141
Score: 2
Joined: 6/26/2002
Status: offline 		I did similar thing on the SMS 2003 HW9a Report titled "Report Name Hardware 9A - Search for Computers"

I will upload that mof file.  Note that this is for 2003 with SP3 installed and I was using the enhanced User discovery add-on from Systemcentertools.com.......BUT with that ability to pull extra user info from AD that is baked in to SCCM2007 you should be able to use parts of this report.

Thx,
Jon



Attachment (1)

(in reply to mhudson)
Post #: 7
RE: Join computer name, user name and full user name? - 9/17/2008 11:52:45 AM   
MeenEnta


Posts: 105
Score: 0
Joined: 9/9/2008
Status: offline 		I couldn't import your attached object into my Web reports, we also are on SMS 2003 SP3.

The console Froze.

(in reply to jkaiser)
Post #: 8
Page:   [1]
All Forums >> [Management Products] >> System Center Products >> System Center Configuration Manager >> Join computer name, user name and full user name? Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.313