Report on List of Publishers in Software Asset Workspace (Tokyo)

[Carolina Messer]

What table do the Publishers that show up in the Software Asset Workspace under the License Usage tab reside on?

How can I get a list (count) of the Publishers that show up under the License Usage Tab in our Software Asset Workspace?

I need to create a report to add to our dashboard. I've looked at the license position report and cannot isolate just the number of Publishers, it only brings back a count of all Products...any ideas on what table the Publishers that show up in the License Usage Tab are pulled from?

Thank you in advance!!

[Stephen42]

Hi Carolina

I accomplished something similar by creating a report using  samp_product_result table.  This drives off of the Reconciliation, so you will need to define a filter of Created, Relative, after, 1 days ago  to only get the most current info

If you Group By Publisher, set aggregation to 'SUM' , and in my case, I sum Unlicensed installs to provide me the listing.

From this, I created a pie chart, including Data Table, and have created a dashboard tab.

I hope this helps.

-Stephen 

[Stephen42]

Sorry, I should have noted that our reconciliation job runs daily, hence why I filter after 1 days ago.   If your job runs weekly (which I believe is default) or you run it manually, you may need to change the filter.   Either way, I think this table has the data you are after.

-Stephen

[Engelica Adalia]

@Carolina Messer I was able to match the Publisher counts in the License usage (under Software Asset Workspace) using the Software Model table [cmdb_software_product_model] with the following filters (Group by Publisher): 
License under management = true
Status = In Production
Product.Product type = Licensable (dot walk to Product type)