Metrics Dashboard
      Back to home
      1. Knowledge Base
      2. Analytics
      3. Metrics Dashboard

      How to map data with Advanced Reporting

      Learn how to set up Advanced Reporting with Domain names and usernames to map user-level data.

       

      First, you need to generate the report before mapping any data. Refer to this article to know how.

      How to Obtain User Domain Name and Username

      1. To map the data correctly, you need two key pieces of information:

        • Username.
        • User Domain Name.

      2. Obtain a list of all usernames where DataSnipper is installed. This can usually be provided by your IT department.

      3. To find the Username and User domain name of an individual/device level, open the Command Prompt and type:

        echo %username%,%userdomain%

        Once you hit enter, the values that appear are the username and the domain name (separated by comma) that you will need to map the data.

        Alternatively, as a non-admin you can open PowerShell and use the following to get Username

        Write-Output ([System.Security.Principal.WindowsIdentity]::GetCurrent().Name)

        The username is located between C:\\Users\\ and >.

      It's important to note that you should NOT use the whoami command to find the username, as it does not preserve case sensitivity. Since the Advanced Reporting system is case-sensitive, using whoami may lead to incorrect mapping and reporting errors.

      How to enter information in the Mapping Sheet

      1. Paste all usernames in Column A on the Mapping Sheet (2nd tab).
      2. Paste the corresponding user domain names in Column B.
      3. Additional columns such as office location or department can be filled in for more granular segmentation. These are optional columns.

      How to Map the Data

      1. After filling out the mandatory fields (Username and User Domain Name), click on the Map Data button.
      2. The mapped data will appear on the Mapped Data tab (3rd tab). Here, you can further segment user data based on parameters like office location, department, and more.

      Tips:

      1. The hashes are case-sensitive. If you know that the user should be mapped (active DataSnipper user), then trying multiple variations with different cases could help map the user (e.g johnsnow, JohnSnow, JOHNSNOW)
      2. Please check for any spaces in the cell for the username and domain name text strings. The spaces count as symbols and would result in the wrong hash
      3. Make sure the Macros are unblocked on the Advanced Report workbook before mapping data