cancel
Showing results for 
Search instead for 
Did you mean: 

Query to show Users mapped to Computers

Jump to solution

Greetings,

I was wondering if anyone had a query (either in ePO or SQL) which will show the users that we've mapped to our laptops.  We will be in the process of migrating and upgrading our server so I wanted to ensure this data isn't lost, as we have over 1000 laptops with EEPC.

We're currently running ePO 4.6.6 and EEPC 7.0.2.

Thank you

Michael

0 Kudos
1 Solution

Accepted Solutions
ansarias
Level 13

Re: Query to show Users mapped to Computers

Jump to solution

Hello Michael,

You can get it from Managed System Query.

  1. Go to ePO Queries and Reports.
  2. Create new query.
  3. Result Type > Feature Group = System Management and Result Types as Managed Systems
  4. Chart as Table
  5. Columns will be System Name and User Name
  6. Under Filter tab select EEPC product version as latest one and Run the report.
  7. You will get a report of laptops which are having EEPC product installed with user name.
0 Kudos
4 Replies
ansarias
Level 13

Re: Query to show Users mapped to Computers

Jump to solution

Hello,

Could you please provide more details on requirement? So Are you looking for user ID which are running with EEPC product and also need with Laptop name.

0 Kudos

Re: Query to show Users mapped to Computers

Jump to solution

The fields I would prefer is:

User Name

Distinguished Name (So I know what AD they're in)

Computer Name

That's pretty much all I'll need.  If anything goes wonky, as it usually does here, then I can reattach users to the laptops.  I'm praying I don't need to but just in case.

Thank you so much,

Michael

0 Kudos
ansarias
Level 13

Re: Query to show Users mapped to Computers

Jump to solution

Hello Michael,

You can get it from Managed System Query.

  1. Go to ePO Queries and Reports.
  2. Create new query.
  3. Result Type > Feature Group = System Management and Result Types as Managed Systems
  4. Chart as Table
  5. Columns will be System Name and User Name
  6. Under Filter tab select EEPC product version as latest one and Run the report.
  7. You will get a report of laptops which are having EEPC product installed with user name.
0 Kudos

Re: Query to show Users mapped to Computers

Jump to solution

Thank you - by also using the Computer Properties / Domain I was able to see where they all are too.

I appreciate your assistance with helping me

Yours

Michael

0 Kudos