How to find a user's primary system based on the number of "logged in" count?

Products

• CA Automation Suite for Data Centers - Configuration Automation
• CA Client Automation - Asset Management
• CA Client Automation - IT Client Manager
• CA Client Automation
• CA Client Automation - Remote Control
• CA Client Automation - Asset Intelligence
• CA Client Automation - Desktop Migration Manager
• CA Client Automation - Patch Manager
• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Server Automation
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

This "How-to" explains the steps to create a report which will show any user's most "logged on" system, based on that we can determine which system is an user's primary machine.

Solution:

1. In the DSM Reporter window, right click on Report Templates.
   
   
2. Select New Report Template.
   
   
3. Give appropriate name. (For e.g. FindPrimaryPC)
   
   
4. Click on Fields tab.
   
   
5. Click on Add.
   
   
6. Select General Information.
   
   
7. Click on Unit Relations tab.
   
   
8. Expand Related Units.
   
   
9. Expand User Accounts.
   
   

   <Please see attached file for image>

   
   
   
10. Select Name and click on Add.
    
    
11. Select Registration Count and click on Add.
    
    
12. Select Last Agent Execution Date and click on Add.
    
    Note:
    You can also add "Last Registration Date" field while adding the fields.
    However, ensure it to add after adding the fields already mentioned in the steps to maintain the order of the fields.
    
    

    <Please see attached file for image>

    
    
    
13. click on OK on the Field Browser Window.
    
    
14. On the Properties window, click on Default View.
    
    
15. Select Custom HTML View.
    
    
16. On the Properties for HTML View, click on Groups tab.
    
    
17. Under the column, "Group | Based on", click on "Select to define".
    
    
18. Under section Group Settings, select "Related[User]> Name".
    
    

    <Please see attached file for image>

    
    
    
19. Now, click on Rows tab.
    
    
20. Check the option "Show Rows".
    
    
21. Under the section "Sorting".
    
    
22. For First Sort by. select "Related [User]> Name".
    
    
23. For Then sort by, select "Related [User]> Registration Count".
    
    

    <Please see attached file for image>

    
    
    
24. Click on OK on the Properties for HTML View window.
    
    
25. Click on OK on the Properties for the report window.
    
    
26. Right click on the Report name on the left hand pane and select "Run Report".
    
    
    Sample Output
    ================
    
    

    <Please see attached file for image>

    
    
    

Environment

Release: UASIT.99000-11.2-Asset Intelligence
Component: