Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How can create report for primary login user for machine

Created: 26 Dec 2013 | 4 comments

I need to find out who is primary login to each machine with the report has domain, user, computer name, IP address, Primary login user.

which table I need to join with vcomputer?

I only need the first initial and last name for the primary login user, I don't need the domian

example: gpd\test, I need to strip out gpd domain, only keep test as primary user

 

Thanks

 

Lillian

 

Operating Systems:

Comments 4 CommentsJump to latest comment

rafaelfontana's picture

Actually the view vcomputer brings you the primary user for the machine. Do you need the first and last names registered for the domain user on Active Directory? Is that what you're trying to accomplish?

MS_ITMS's picture

Please check the Reports below

Reports  
 Discovery and Inventory  
 Inventory  
 Windows  
 User  
 Primary User  
 Primary User by Computer

Reports  
 Discovery and Inventory  
 Inventory  
 Windows  
 User  
 Primary User  
 Primary User on Multiple Computers
 
 
 

If the suggestion has helped to solve your problem, please mark the post as a solution.

MS_ITMS

SK's picture

As already mentioned, the vComputer view already uses the Inv_AeX_AC_Primary_User table to display its User column value, so that requirement is already taken care of.

In order to only display a certain number of characters found within a column, you need to use either the LEFT or SUBSTRING commands.

 

I believe that the following query suits your needs:

SELECT
[Name] AS Computer,[Domain],LEFT ([User],1) AS [User],[IP Address]
FROM vComputer

Connect Etiquette: "Mark as Solution" those posts which resolve your problem, and give a thumbs up to useful comments, articles and downloads.