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

Document ID : KB000053727
Last Modified Date : 14/02/2018
Show Technical Document Details

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.

    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.

    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.

    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".

    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".

    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
    ================

    Figure 5