KennethvdHoven asked a question.
Hi, I like to know in which tables of the SNOW database I can find the fields 'Purchase price per license', 'Quantity' (user rights), 'License type'. If someone can help me with that, I would really appreciate that!
Hi,
In the Snow Database, this information is in the 'dbo.tblLicense' table.
The purchase price is called 'Purchase Value' along with 'LicenseCount' as the quantity.
Is there a reason you need to see this information in the database? You can find it from the SLM under 'All Licenses' report and using the column selector to add purchase price etc.
Expand PostHave you looked in the dbo.tbllicense table. purchase price per licence would obviously be purchasevaluebase / legallicensecount. there's collums in there for license type etc, you'll need to join on the dbo.tblparametertranslation table to make sense of it
Expand Post
Have you looked in the dbo.tbllicense table. purchase price per licence would obviously be purchasevaluebase / legallicensecount. there's collums in there for license type etc, you'll need to join on the dbo.tblparametertranslation table to make sense of it