Hello everyone. I would like a help. Is there any place/link where I can get a library of all FlexNet SKUs? My company just started uploading all our license in FlexNet, but we are facing a lot of difficulties to find SKU information with manufactures and resellers.
Thanks in advance!
Jul 05, 2019 09:26 AM
@mfranz, I can access FNMS compliance data base as a read only user and extract all SKUs register in FNMS or this information is encrypted?
What FlexNet team is requesting us is to fill out some templates to bulk load the information in the tool, but as I said I have software information as version, edition but not SKU for most of the softwares.
This is making our tool usage difficult.
Jul 05, 2019 11:06 AM
Yes, the SKU details in the FlexNet database are encrypted to protect IP held by various parties. The best place to get SKUs is from your vendors - FlexNet isn't in a position to be able to provide that data on behalf of vendors.
Jul 07, 2019 08:33 PM
We are trying to create a report from our All Purchases and normalize the data for Power BI reporting to reflect a Product Name vs. the Item Description, if the SKU matches an entry in FNMS. I know the data is encrypted, but is there any way to correlate the purchase part no to the Product name found in the SoftwareTitleInfo table?
Appreciate your help.
May 19, 2021 05:34 PM
Please would you mind elaborating a bit more on your needs here?
You seem to me to be trying to mix SKU recognition with application recognition (ARL) which isn't possible (as it would be a "one-to-many" type or potentially even a "many-to-many" type of relationship), but I may be misunderstanding your use case(s)?
May 21, 2021 06:59 AM
We are being asked to report on all of our purchases and grouping them by software title (Item Description) and representing that in a dashboard is impossible because you can't really group them, other than by SKU. But even that would be too large a dataset to represent well. We are looking for a Product Name or Product Family that can be derived from the SKU and then tied to the SoftwareTitleInfo table to pull that Product Name.
Does that make sense?
May 21, 2021 09:23 AM
Right, my one-to-many / many-to-many concerns still apply...
Do you have a naming standard for licenses created based on the purchases (SKUs)?
If you do, it may be easier for you to take the outset in doing this per license instead of per SKU, e.g. the Purchases tab in the License view allows for many more attributes that you could then include:
May 27, 2021 06:40 AM
What can help you at this stage is the table called dbo.SoftwareSku...the column name is 'SKU'. As others says all other columns information are encrypted by designed of IP protection. But the SKU list itself is not encrypted. So it can at least help you doing thing such as..." I have a list of SKU/Part Number....let me see how many are matched/covered by current Flexera SKU library"...you can import your list of SKU into a temp table and match with dbo.SoftwareSKU on SKU=SKU
Hope it helps.
Jul 08, 2019 03:00 AM
Jul 08, 2019 05:04 AM