Ability to export list of installed, paid applications in instance

[Community Alums]

I would like to export a list of applications that are installed and paid. I can get the list when I go to System Applications > All Available Applications > All and then select under Filters, I select the following:

Listing type = Applications
Obtained = Installed
Price = Paid

How can I export this list?

[Matt102]

Hi,

[I suspect] In UI16 navigate to Store Applications (sys_store_app.list) and add filter by Price type == Paid:
https://<instance>.service-now.com/sys_store_app_list.do?sysparm_query=price_type%3Dpaid

...std export via Column header context menu > Export...

hth,matt

[Community Alums]

Hi Matt,

Thank you for the reply.  This was helpful.  

Unfortunately, the numbers aren't matching up.  When I go to (sys_store_app.list) and filter by Price type = Paid, it gives me 16 records.  

When I go to System Applications > All Available Applications > All and then select the following filters, Obtained = Installed and Price = Paid, I am receiving 183 records.

An example is Agent Assist Recommendation.  It shows up in the System Applications > All Available Applications > All but not in the Store Applications.  I'm guessing the reason is because it is not a store application.

Thanks,

Mike

[Matt102 · Accepted solution]

Hiya,

One thought. I've oft been frustrated in the past, not being able to see everything that we have installed. Upon logging a Hi ticket I have seen that some apps/plugins are only visible (and installable?) by an SN Agent, who has the maint role.

Then again it may be that base OOB install may contain may base (system) applications (dependant on your base OOB licence) not counted as store apps. So total apps = OOB apps + store apps

Potential other tables that might help; sys_app, sys_plugins and v_plugin

hth,matt

[Matt102]

Another thought, I've seen apps with a hierarchy...

Buy one parent and get the kids for free?