What table stores "Unpinned publishers"?

Kody
Tera Expert

Hello,

 

I understand that table [samp_pinned_user_publisher] stores "Pinned publishers" in Software Asset Workspace from the blog below.
https://www.servicenow.com/community/sam-blog/list-of-servicenow-sam-tables/ba-p/2283573


However, I cannot find what table(s) stores "Unpinned publishers".
Does any docs page or else describe it?

Unpinned publishers.png

6 REPLIES 6

SANDEEP DUTTA
Tera Patron
Tera Patron

Hi @Kody ,

You can try with samp_sw_publisher table.

Thanks,
Sandeep Dutta

Please mark the answer correct & Helpful, if i could help you.

Hi Sandeep,

 

Thank you for reply.

The screenshot I attached shows 52 publisher names but samp_sw_publisher table has 1,797 records.
What brings the difference?
Unpinned publishers2.png

dreinhardt
Tera Sage

Hi @Kody,

"unpinned publishers" is just a view in the workspace based on all licensable software models with consumption or active entitlements added. On top the list includes all discovery models with product type "licensable" and active installs without a software model.

 

What would you like to achieve with this table?

 

Best, Dennis

Should my response prove helpful, please consider marking it as the Accepted Solution/Helpful to assist closing this thread.

Hi Dennis,


Thank you for your reply.

Will the number of Available licenses increase if I import or manually enter entitlements?

And what kind of import/input will decrease the number of available licenses?

Do you think these actions can be confirmed in PDI and Demo instances?