Client Management Suite

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

Does this help ?

http://www.symantec.com/connect/forums/sql-report-last-log-user-primary-user-last-logon-time

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?

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
 
 
 

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