Hi, how and where do I check the build number for application/software (Database software: eg. Ibm db2) ?
this is what is shown in the described SMACC section:
Does this help?
this should be looked up in your Inventory Server.Open the SMACC for Inventory and search for those computers.With a doubleclick you get details.Now select the item Software and search for your application.
I did as per your instruction, but I couldn't see the column for build number. The column available is Name, Manufacturer and Version.
Thank Marcel. Yes able to view using SMACC.
Kindly advice how do I derive the report and information on all the database usage with build number/version in an organization using SLM.
we currently only differ between license relevant versions in Snow License Manager. There are no minor versions displayed. However your wish is shared by several other customers. There is an ideas in our ideas board, which is currently under review by product management.
Application minor version numbers displayed in SLM
I kindly advise you to stand by, while this is being discussed.
As minor version information is being normalized during the processing from Snow Inventory to Snow License Manager, there is no chance of getting this information from Snow License Manager at the moment.
In the meantime - if you would like to search raw data for applications - you can use the following query to get minor application versions from the database.
--set application name heredeclare @ApplicationName nvarchar(100) = 'example application'--set computer name heredeclare @ComputerHostName nvarchar(100) = 'example computer'SELECT dc.HostName, da.Name as 'Software Name', da.FullVersionFROM [SnowInventory].[inv].[DataSoftware] swleft join inv.DataClient dc on sw.ClientId = dc.ClientIdleft join inv.DataApplication da on sw.AppId = da.ApplicationIdwhere da.Name like '%' + @ApplicationName + '%'and dc.HostName like '%' + @ComputerHostName + '%'
In my case, for the Application 'Office' and my computer, I get the following information:
Hope this is valuable for you. If you need any assistance, please let me know.
Noted and please keep us updated on the progress of the discussion and when SLM will be able to view this info moving forward.
all new features of our products will be posted in the release notes. So please keep an eye out on the release notes for Snow License Manager. I will try to update this thread.
Retrieving data ...