Bluebeam SaaS Custom Integration - How to Populate Software Usage Table?

[Tejaswini Morey]

Hi Team,

I have developed a custom SaaS integration for Bluebeam using a custom Scheduled Job and Script Include. Currently, I am successfully importing subscription data into the Software Subscription (samp_sw_subscription) table and updating the Last Activity information.

My next requirement is to populate Software Usage (samp_sw_usage) records for Bluebeam users. The ServiceNow Software Usage data is stored in the samp_sw_usage table.What is the recommended approach to populate samp_sw_usage for a custom SaaS integration?

[pr8172510]

Hi @Tejaswini Morey,

For a  Bluebeam SaaS integration, ServiceNow provides a supported API specifically for populating Software Usage [samp_sw_usage].

Use the SAM-Software Usage Data Integration API

POST /api/now/sam_software_usage_integration/createOrUpdate

It creates or updates records in samp_sw_usage and supports multiple usage records in one request.

For Total Usage, provide:

• configuration_item
• norm_product
• month_used
• year
• last_used_time
• usage values such as usage_count / total_usage_time

For Last Used Date, provide:

• configuration_item
• norm_product

ServiceNow uses these fields to identify whether to create a new usage record or update an existing one.

So the recommended architecture is

Bluebeam API

↓

Scheduled Job / Integration

↓

SAM Software Usage Integration API

↓

samp_sw_usage

samp_sw_usage can contain usage data from third-party integrations, so a  Bluebeam integration is a valid use case.

 using the SAM Software Usage Data Integration API rather than directly inserting records into samp_sw_usage.

[MikeW0609686430]

If you are already pulling the Last Activity Date, what data requires populating into samp_sw_usage?