search cancel

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


Article ID: 53727


Updated On:


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



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.


  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>

    Figure 1

  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.

    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>

    Figure 2

  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>

    Figure 3

  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>

    Figure 4

  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>

    Figure 5


Release: UASIT.99000-11.2-Asset Intelligence


1558711131830000053727_sktwi1f5rjvs16s4g.gif get_app
1558711130026000053727_sktwi1f5rjvs16s4f.gif get_app
1558711128064000053727_sktwi1f5rjvs16s4e.gif get_app
1558711126058000053727_sktwi1f5rjvs16s4d.gif get_app
1558711123877000053727_sktwi1f5rjvs16s4c.gif get_app