Highlighted
Active participant

List of SKUs that are not in SKU library

Jump to solution

We are working on reviewing the list of SKus that are not in the library, and determining which ones to send into FLexera to add them to SKu library. 

There is no way that I can see to run that list, without going into each product and re-entering the SKU to see if it is in SKU library. 

I can create an application list that shows me if Flexera added the application or "local" added, which would be us. 

How can I get that? Otherwise, I've been told that there is a URL that we can run the list of SKUs in Flexera. which I would then be able to match and find the ones missing. 

Not sure if the local SKUs are in the same table as the Flexera SKUs, but in either case, how can I create a report, and if it's custom, need the SQL to run it, since it doesn't show up in the tables in create report. 

1 Solution

Accepted Solutions
Highlighted
Frequent contributor

Re: List of SKUs that are not in SKU library

Jump to solution

Hi schilnr,

If you are working with the on-prem version of FNMS and have access to the [FNMSCompliance] database, you can look at the [SoftwareSku] table (SKU column). In the current (#440) release of the SKU library, this table contains 1845825 rows.

Any reference from SKUs to Software Vendors and to Applications is encrypted and considered to be Flexera Intellectual Property (IP).

Any "Local" SKU data that have been created by manually entering a SKU value into a purchase order (PO) and processing the PO to a software license will not show up in the [SoftwareSku] table. This table contains data imported from the libraries that are provided by Flexera only. If you want additional SKUs to be added, you must submit these additional SKU together with the Vendor and Application data to Flexera.

You can use the [SoftwareSku] table for checking if your own SKU data are available in the Flexera library or not.

Working with the FNMS Web UI, you can use the standard PO import template for importing some dummy POs into FNMS. After completing the import, you can see in the view if SKU data are recognized or not. In the "Unprocessed Purchase Orders" view, you can add a filter on "Alert = SKU does not match" for filtering on the SKUs that have not been recognized.

View solution in original post

16 Replies
Highlighted
Frequent contributor

Re: List of SKUs that are not in SKU library

Jump to solution

Hi schilnr,

If you are working with the on-prem version of FNMS and have access to the [FNMSCompliance] database, you can look at the [SoftwareSku] table (SKU column). In the current (#440) release of the SKU library, this table contains 1845825 rows.

Any reference from SKUs to Software Vendors and to Applications is encrypted and considered to be Flexera Intellectual Property (IP).

Any "Local" SKU data that have been created by manually entering a SKU value into a purchase order (PO) and processing the PO to a software license will not show up in the [SoftwareSku] table. This table contains data imported from the libraries that are provided by Flexera only. If you want additional SKUs to be added, you must submit these additional SKU together with the Vendor and Application data to Flexera.

You can use the [SoftwareSku] table for checking if your own SKU data are available in the Flexera library or not.

Working with the FNMS Web UI, you can use the standard PO import template for importing some dummy POs into FNMS. After completing the import, you can see in the view if SKU data are recognized or not. In the "Unprocessed Purchase Orders" view, you can add a filter on "Alert = SKU does not match" for filtering on the SKUs that have not been recognized.

View solution in original post

Highlighted
Active participant

Re: List of SKUs that are not in SKU library

Jump to solution

thank you very much. that helped a lot.

0 Kudos
Highlighted
Occasional contributor

Re: List of SKUs that are not in SKU library

Jump to solution

Hi,

I'm on prem 2018 R2....You reply is a little bit confusing. In your response, you stated 'Any reference from SKUs to Software Vendors and to Applications is encrypted and considered to be Flexera Intellectual Property (IP).' But then you refer us to going to the [FNMSCompliance] database, to look at the [SoftwareSku] table (SKU column). 

 

So are we able to look at a long list of SKU or not? I don't want to have my server contact log onto the FNMSCompliance database and have all the SKU numbers encrypted...

Please advise....

 

 

 

 

 

So are you saying that 

0 Kudos
Highlighted
Flexera
Flexera

Re: List of SKUs that are not in SKU library

Jump to solution

@rodris46  - The SKU number itself is not encrypted in the database.  But all of the related information about the SKU (description, publisher, use rights, etc.) - IS encrypted.