@rajaravanan
The [samp_sw_subscription] table is pulling data directly from the vendor site via the integration you setup (e.g. Adobe /Microsoft Integration Profile). Depending on how you provision licenses (e.g. AD/Azure group and synch's with the vendor portal), it's possible that you still have users in the vendor portal that are already inactive users in the [sys_user] table at some point (could be a timing issue). You can check your termination/leave/name change processes to improve discrepancies.
From a licensing perspective, if a user account is still in the vendor portal regardless of status on your own company table - it would still count as a consumption.
