# Open iT LicenseAnalyzer (ServiceNow Store Application)

Use the following guides to verify that the Open iT LicenseAnalyzer application is working and deployed successfully.

# Checking Successful Data Receipt

To verify if all the sent data was successfully received and loaded to the Import Set Tables, follow these instructions:

1. Log in to the ServiceNow instance with an Administrator account.

2. In the upper-left corner of the page, click All.

3. In the filter option, type in System Definition. This will filter the displayed items.

4. Navigate through System Definition > Tables. This will redirect you to a page displaying a list of all system-defined tables.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Menu
   
   

5. In the search bar, choose Name as the criteria and type x_opeit. Press Enter.

6. Click the table name to check. The page will be redirected to the selected table definitions and configuration.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Data Receipt
   
   

7. Scroll down to Related Links and click Show List to view the contents of the table. It will redirect you to the table's data view.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Show List
   
   

8. Verify that the sent data is already loaded.

# Checking Data Receipt Logs

To check the status of all data receipt transactions, follow these instructions:

1. Log in to the ServiceNow instance with an Administrator account.

2. In the upper-left corner of the page, click All.

3. In the filter option, type in Import Sets. This will filter the displayed items.

4. Navigate through Advanced > Import Sets. This will be redirected to the sys_import_set table view.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Menu
   
   

5. Take note of the State column to monitor the status of the data receipt:

   • Loading - data is being loaded
   • Processed - data is successfully loaded
     
     

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Data Receiving Logs
   
   

# Checking Successful Data Transformation

To check if all the data is successfully transformed and loaded to the SAM tables, follow these instructions:

1. Log in to the ServiceNow instance with an Administrator account.

2. In the upper-left corner of the page, click All.

3. In the filter option, type in System Definition. This will filter the displayed items.

4. Navigate through System Definition > Tables. This will redirect you to the list of all system-defined tables.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Menu
   
   

5. In the search bar, choose Name as the criteria and type samp_eng. Press Enter.

6. Click the table Label to check. The page will be redirected to the selected table definitions and configurations.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Data Transform
   
   

7. Scroll down, then click Show List to view the contents of the table. This will redirect you to the table's data view.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Show List
   
   

8. Verify that the transformed data is already loaded.

# Checking Data Transformation Logs

To check the status of all the data transformation, follow these instructions:

1. Log in to the ServiceNow instance with an Administrator account.

2. In the upper-left corner of the page, click All.

3. In the filter option, type in Job Results. This will filter the displayed items.

4. Navigate through Software Asset > Administration > Job Results. This will redirect you to the samp_job_log table view.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Menu
   
   

5. Filter the column Name for OpeniT - Transform.

6. Take note of the Status column to monitor the status of the data transformation:

   • Completed - data transformation is completed
     
     

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Data Transformation Logs
   
   

# Checking Data Normalization

ServiceNow expects a clean and normalized data from its data source. If the sent product is not recognized as part of the normalized software list maintained by ServiceNow, the product will not be included in the dashboard for reporting.

To check if there are products that are not normalized, follow these instructions:

1. Log in to the ServiceNow instance with an Administrator account.

2. In the upper-left corner of the page, click All.

3. In the filter option, type in System Definition. This will filter the displayed items.

4. Navigate through System Definition > Tables.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Menu
   
   

5. In the Label column, type Software Discovery Model in the search bar. Press Enter.

6. Click Software Discovery Model. This will redirect you to the selected table definitions and configuration.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Software Discovery Model
   
   

7. Scroll down, then click Show List to view the contents of the table. This will redirect you to the table's data view.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Show List
   
   

8. Verify the list of products and take note of all the products with Normalization status as Match Not Found.

9. To manually normalize the product, click the Display name. This will redirect you to the product information page.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Normalization Status
   
   

10. In the Product column, search the product. Press Enter.

11. Click the product name if it exists. This will automatically close the window and set the value to the Publisher and Product field.

    

    ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Product Normalization
    
    

12. Click Normalize. Wait until the process is finished. It will display a confirmation message about the normalization.

    The Normalization status should be set to Manually Normalized.

    

    ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Normalized Product
    
    

13. Click Update.

    

    ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Update Normalized Product
    
    

If the Product is not listed in the Normalized Software Products list, follow these instructions:

1. Click the search (magnifying glass) icon beside the Publisher field. This will open a new browser window containing the list of Normalized Software Publishers.

2. In the Name column, search for the Publisher. Press Enter.

3. Click the publisher name if it exists. This will automatically close the window and set the value to the Publisher field.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Publisher Normalization
   
   

   If the publisher does not exist, click New, located at the upper-right corner of the window. Create the publisher by providing the fields for a New Company Record. Click Submit.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - Normalized Publisher
   
   

   The window will close and automatically set the value of the created publisher in the Publisher field.

4. Click the search (magnifying glass) icon beside the Product field. While in the Normalized Software Products list, click New on the upper-right corner of the window.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - New Product Normalization
   
   

5. This will redirect you to the Custom Software Product - New Record form. Provide the required fields (Publisher and Product) and other additional details.

6. Click Submit. This will close the window and set the value to Product and Publisher.

   

   ServiceNow Integration: Open iT LicenseAnalyzer Deployment Verification - New Product Normalization Form
   
   

7. Click Normalize. Wait until the process is finished. It will display a confirmation message about the normalization.

   The Normalization status should be set to Manually Normalized.

8. Click Update.