Matching Entitlement Compliance Status to Entitlement in Reports

[FelixP]

Hello Support Team,

I am currently working on creating a report related to entitlements within ServiceNow. I have successfully generated a report based on the alm_license table using a multi-level pivot format. In this report, I have set the select column to "Software Model.Publisher" and the rows to "Location" and "License Type."

My next step is to include the compliance status of the entitlements for each region. I would like guidance on how to leverage dot-walking to access the compliance status from the alm_license table to the relevant entitlement records.

Could you please provide me with the necessary steps or any additional information to achieve this? Your assistance would be greatly appreciated! I have provided a photo of the report and the dot walking view window from the alm_license table, if you could send the route from the alm_license table with dot-walking to the entitlement complient-status this would really help me.

Thank you for your support.

[Community Alums]

Hello,

Usually compliance status is tagged to Software model Result table after reconciliations as you can have multiple entitlement for a software model. In your case i did not get purpose of this report on entitlement table but from entitlement table you have access to License metric result table from there you can dot walk to software model result table & there in that table in status field you will find weather the software model attach to that entitlement is complaint or not.

Thanks!

Subham

[FelixP]

Hello Subham,

It seems there has been a miscommunication. I understand that you should be able to dot-walk from alm_license to software model result. The issue I have is that I can't find or don't know the route. I need someone to tell me which fields I should use to dot-walk from A to B, as shown in the picture I linked here.

I would appreciate it if you could provide the routing, something like: alm_license --- Software Model --- Discovery Map --- Compliance Status. This would help me access the compliance data.

If you could provide this information or send me a link to the table routing fields, I would really appreciate it.

Thanks,
Felix

[Community Alums · Accepted solution]

Hello,

I have already mentioned that alm_license>>license metric result>>software model result>> status.

Thanks!

[FelixP]

It worked, thank you so much! I have another question: How do you determine which tables are linked to each other? Is there a list or diagram that shows the relationships between tables and the fields they share, or is it something you learn through experience? 🙂