Matching Entitlement Compliance Status to Entitlement in Reports

FelixP
Tera Contributor

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.

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hello,

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

Thanks!

View solution in original post

9 REPLIES 9

Community Alums
Not applicable

Hello,

Basically a reference field on table relates to different tables. I don't know if there is map which can define the relationship.

Thanks!

Thank you, Sir. This is really interesting! Where do you find such reference fields? This information would make my work much simpler. Could you also tell me the reference field from the table cmdb_sam_sw_install to the Entitlement table alm_license? That would really help me. I really appreciate your time and effort.😊

Community Alums
Not applicable

Hello Felix,

From Install table you have discovery model field>>> Discovery model >>> Software model. But from here You can not go to alm_license table as a software model record can be referenced to multiple license records. What is your requirment for report here? 

Thanks

Thank you Subham for telling me that, that is very useful to know! The Problem i have is my Boss wants me to generate two Reports 1. Which Discovery Models have no Entitlements and 2. Which Entitlements have no Discovery Models. How could i tackle this issue if you can not match them ? Maybe match Software Model to Entitlement or is this also not possible ?😅 The Issue is we have two Teams one for the Entitlements ( in which i work) and a Team that builds the Discovery Models. The Teams are not at the same Location, that is why he wants the two Reports to check for Data Quality. If this two reports do not work he wants instead Overlicensed and Underlicensed Publishers and the corresponding License Type. Is at least one or two of these reports possible ? I really appreciate your help, time and effort you put into helping me ðŸ˜ƒ Tanks a lot !

Community Alums
Not applicable

Hello,

i think there is way we can report this but need to check first. 

 

Thanks

Subham

Linkedin - https://www.linkedin.com/in/subhamagarwal5074/