Mar 31, 2021
11:37 AM
1 Kudo
After importing the EOSL package into FNMS, you will see an additional table named [SoftwareTitleEOSL] in the [FNMSCompliance] database. When joining this table with the [SoftwareTitle] table as shown in the SQL below, you can retrieve additional application related properties for your report, including StartOfLifeDate EndOfSalesDate EndOfLifeDate SupportedUntil ExtendedSupportUntil With the current ARL and EOSL package, the statement below should return about 19.500 rows where the [EndOfLifeDate] is not empty. SELECT
st.FullName
,st.SoftwareTitleID
,stp.ProductName
,stv.VersionName AS Version
,ste.EditionName As Edition
,stc.DefaultValue AS SoftwareTitleClassification
,ge.Path AS Category
,st.IsLicensable
,st.ReleaseDate
,st.IsSharableToLibrary
,st.AutoManageLicensePriority
,st.TitleRequiresStrictMatching
,st.HasInstalls
,eosl.StartOfLifeDate
,eosl.EndOfSalesDate
,eosl.EndOfLifeDate
,eosl.SupportedUntil
,eosl.ExtendedSupportUntil
FROM [SoftwareTitle] st
JOIN [SoftwareTitleType] stt ON st.[SoftwareTitleTypeID] = stt.[SoftwareTitleTypeID]
JOIN [SoftwareTitleProduct] stp ON st.[SoftwareTitleProductID] = stp.[SoftwareTitleProductID]
LEFT JOIN [SoftwareTitleVersion] stv ON st.[SoftwareTitleVersionID] = stv.[SoftwareTitleVersionID]
LEFT JOIN [SoftwareTitleEdition] ste ON st.SoftwareTitleEditionID = ste.SoftwareTitleEditionID
JOIN [OperatorManageState] oms ON st.[OperatorManageStateID] = oms.OperatorManageStateID
JOIN [SoftwareTitleClassification] stc ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID
JOIN [GroupEX] ge ON ge.GroupExID = st.CategoryID
JOIN [SoftwareTitleEOSL] eosl ON eosl.SoftwareTitleID = st.SoftwareTitleID
... View more
Mar 31, 2021
08:57 AM
3 Kudos
As you may have noticed, supporting OVIRT and QUEMU already has been entered as an idea titled 'Extend KVM virtualization support for other manufacturers' that that you can vote for.
... View more
Mar 24, 2021
06:11 PM
1 Kudo
Add them to the [FNMSCompliance].[ResponsibilityType] table 😊 .
... View more
Mar 24, 2021
06:07 PM
1 Kudo
Yes, the views in the "Management View" area in the FNMS Web UI are stored in the [EcmSettings] table in the [FNMSCompliance] database. If you truncate this table, all customized views in the FNMS Management View Index section that have been saved by any user will be lost. Basically, this works similar to when a user customizes a view by adding additional columns or by applying a filter. In the [EcmSettings] table, FNMS stores the ID of the current user ([ComplianceOperatorID] column), the view and action ([SettingKey] column) in a URL like format like (ctx://Applications/List_Grid/Installed/View/67) and the actual settings for the view in XML format ([SettingValueString] column). Unfortunately, there is no documentation specifically on the meaning of the XML data in the [SettingValueString] column in this table.
... View more
Mar 23, 2021
05:13 PM
2 Kudos
Hi Coravix, The information you are looking for is stored in the [SoftwareTitle] table in the [FNMSCompliance] database. The SELECT below will pull all relevant information for the TechSmith Snagit products from the database. Updating the information in the [SoftwareTitle] table is not recommended though. This information is coming from the Flexera ARL and information in your local environment will be overwritten when a new version of the ARL is imported into your system. A new version of the ARL is typically published once a week. A better alternative would be configuring additional custom fields to the 'Application' object for storing the information. Custom fields will be available from the 'Column Chooser' in standard views in FNMS, like in the 'License Compliance > Applications > All Applications' view. Obviously, you can build custom reports using SQL that will show this information, too. Custom fields are not available from the standard FNMS ReportBuilder tool. SELECT
st.[FullName]
,st.[SoftwareTitleID]
,stt.[DefaultValue] As SoftwareTitleType
,stp.[ProductName]
,stv.VersionName AS Version
,ste.EditionName As Edition
,oms.DescriptionDefaultValue As OperatorManageState
,stc.DefaultValue AS [SoftwareTitleClassification]
,ge.Path AS [Category]
,st.[IsLicensable]
,st.[ReleaseDate]
,st.[IsSharableToLibrary]
,st.[AutoManageLicensePriority]
,st.[TitleRequiresStrictMatching]
,st.[SupportedUntil]
,st.[ExtendedSupportUntil]
,st.[SoftwareTitleActionID]
,st.[HasInstalls]
FROM [dbo].[SoftwareTitle] st
JOIN [SoftwareTitleType] stt ON st.[SoftwareTitleTypeID] = stt.[SoftwareTitleTypeID]
JOIN [SoftwareTitleProduct] stp ON st.[SoftwareTitleProductID] = stp.[SoftwareTitleProductID]
LEFT OUTER JOIN [SoftwareTitleVersion] stv ON st.[SoftwareTitleVersionID] = stv.[SoftwareTitleVersionID]
LEFT OUTER JOIN [SoftwareTitleEdition] ste ON st.SoftwareTitleEditionID = ste.SoftwareTitleEditionID
JOIN [OperatorManageState] oms ON st.[OperatorManageStateID] = oms.OperatorManageStateID
JOIN [SoftwareTitleClassification] stc ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID
JOIN GroupEX ge ON ge.GroupExID = st.CategoryID
WHERE stp.[ProductName] LIKE '%snagit%'
... View more
Mar 19, 2021
02:40 PM
Hi Janice, For #1: Especially for SUN and Oracle Java, it is common that the 'ProductVersion' and 'FileVersion' properties for file evidence linked to an application is not consistent with the application version itself. The SQL statement below retrieves all applications where the version numbers don't match. With ARL #2590, this statement returns 440 rows. You can see the results in the Excel file attachment 'JavaFileEvidence VersionNoNotMatching.xlsx'. For #2 & #3: If you change the WHERE condition in the SQL script to check for non-empty [FilePath] data, you'll see a lot of strange file path data including the one that you reported. This does not result in problems with application recognition as the file path is not used for this purpose. I have no idea who 'brian.t.gallagher' might be 😁 and why local Java file evidence information from his computer has been picked for the FNMS ARL :-). Basically, providing [FilePath] information with the ARL especially for Windows seems to be a waste of disk space and network bandwidth though. SELECT
st.[FullName]
,stt.[DefaultValue] As SoftwareTitleType
,stp.[ProductName]
,stv.VersionName AS Version
,ste.EditionName As Edition
,oms.DescriptionDefaultValue As OperatorManageState
,stc.DefaultValue AS [SoftwareTitleClassification]
,ge.Path AS [Category]
,st.[ReleaseDate]
,st.[HasInstalls]
,fe.FileName
,fe.FileVersion
,fe.ProductName
,fe.ProductVersion
,fe.Company
,fe.FilePath
,eer.RuleDefaultString AS EvidenceExistenceRule
FROM [SoftwareTitle] st
JOIN [SoftwareTitleType] stt
ON st.[SoftwareTitleTypeID] = stt.[SoftwareTitleTypeID]
JOIN [SoftwareTitleProduct] stp
ON st.[SoftwareTitleProductID] = stp.[SoftwareTitleProductID]
LEFT OUTER JOIN [SoftwareTitleVersion] stv
ON st.[SoftwareTitleVersionID] = stv.[SoftwareTitleVersionID]
LEFT OUTER JOIN [SoftwareTitleEdition] ste
ON st.SoftwareTitleEditionID = ste.SoftwareTitleEditionID
JOIN [OperatorManageState] oms
ON st.[OperatorManageStateID] = oms.OperatorManageStateID
JOIN [SoftwareTitleClassification] stc
ON st.SoftwareTitleClassificationID = stc.SoftwareTitleClassificationID
JOIN GroupEX ge
ON ge.GroupExID = st.CategoryID
JOIN SoftwareTitleFileEvidence stfe -- provides the [FileEvidenceID]
ON stfe.SoftwareTitleID = st.SoftwareTitleID
JOIN [FileEvidence] fe
ON fe.FileEvidenceID = stfe.FileEvidenceID
JOIN [EvidenceExistenceRule] eer
on eer.EvidenceExistenceRuleID = stfe.EvidenceExistenceRuleID
WHERE
1 = 1
AND (fe.Company LIKE 'Oracle%' OR fe.Company LIKE 'SUN%')
AND stp.ProductName LIKE '%JAVA%'
AND LEFT(stv.VersionName,1) <> LEFT(fe.FileVersion,1)
ORDER BY fe.Company, st.[FullName]
... View more
Mar 18, 2021
07:58 AM
You must download the FNMS 2016 R1 SP1 version of the “Business Adapter Studio” (BAS) tool. Later versions of BAS (FNMS 2017 R1 and higher, including FNMS 2020 R1) are throwing the error that you describe when trying to insert data loaded from a Web Service into the target database. This issue has been submitted to support (Case #01235581) and has been filed as an enhancement request (JIRA "FNMS-45808 Add Support for FNMS Cloud API in Business Adapter Studio").
... View more
Mar 16, 2021
09:48 AM
3 Kudos
See the discussion thread on ' Identify Windows 10 sub version for Lifecycle Planning' from last week, please 😎 .
... View more
Mar 11, 2021
03:11 PM
2 Kudos
Hi Rob, All native FNMS reports are stored in the [FNMSCompliance].[ComplianceSavedSearch] table. The 'Device Installation Details' report that you are interested in is executing a stored procedure named 'ReportDeviceInstallationDetail'. This stored procedure has two parameters (@ComputerId, @RowLimit). The second @RowLimit parameter (maximum number of rows to be returned in the report) is optional. To test this, for @ComputerId you need a valid 'ComplianceComputerID' value from the [ComplianceComputer] table. Let's assume that @ComputerId=5. To retrieve installation details for this computer, you only have to execute the following statement from Microsoft SQL Server Management Studio (SSMS): EXEC ReportDeviceInstallationDetail 5 Performance of this stored procedure is lousy though. If you want to use the SQL of the stored procedure for running it on multiple computers, you should consider rewriting it and/or storing the output of the stored procedure in a caching table.
... View more
Mar 10, 2021
06:16 AM
2 Kudos
Hi Rajesh, A unique identifier is - as the name implies - a UNIQUE identifier for an object. If you configure your Business Adapter to use both the domain name as well as the user account name as the matching criteria, the combination of both properties is your unique identifier. After updating the first match, the business adapter will disregard the rest. If you work in an on-prem FNMS system, your best option is to first import the data into a staging database or -table in the target environment and then use SQL for updating the target objects directly. If you work in the Cloud, you don't have that option though.
... View more
Mar 10, 2021
01:04 AM
3 Kudos
Hi Joseph, Flexera has announced supporting the Windows Build # with the upcoming next FNMS release. FNMS 2021 R1 is tentatively scheduled for end of Q2 2021. If you look into any NDI file created using a recent Flexera agent on a Windows computer, you should see that the Windows Build # is already extracted from the HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion branch of the Windows registry. This property is not imported into the [FNMSInventory] database and not exposed to the FNMS UI (yet). And I believe that Flexera would like us to post this sort of feature request into the Ideas portal instead of posting as an article in the forum (regardless if we like this concept or not ..). The Ideas portal will become visible only after you use your account for logging into the community.
... View more
Mar 09, 2021
04:05 PM
1 Kudo
Hi Dan, To my knowledge, if you open an "Action" in the "Discovery and Inventory Rules" part of FNMS, the following activities are kind of a cheat, and don't belong there: Microsoft Hyper-V Microsoft SQL Server The reason why I consider these activities to be a "cheat" - "misleading" actually might be a more polite way to describe it - is that if you enable any of these activities, FNMS will not do any IP port scanning, but will try to do a remote inventory on the target computer. The 'discovery' of these applications relies on the remote inventory results. The Flexera agent executed on the target system(s) remotely will report the Hyper-V or SQL Server on the target system. You can achieve the same result by enabling "Gather hardware and software inventory from all target devices" in the "General hardware and software inventory" section of this document. All prerequisites for doing a remote inventory - like having a valid account for the target system configured in the Beacon password store - apply here. For proving this, the best way is to monitor the Beacon activity when the rule is executed on the Beacon. On the "Action", you have to: Disable "Gather hardware and software inventory from all target devices". In the "Microsoft SQL Server" section, enable "Discover Microsoft SQL Server" and/or "Discover Microsoft Hyper-V" Create a rule by combining this "Action" with a valid "Target" that covers some computers running SQL Server. Preferably, these target computers should NOT have a Flexera agent installed (yet). Trigger the download of the rule to the Beacon that is responsible for scanning devices in the "Target". After the rule has been downloaded to the Beacon, you can trigger execution of the rule manually from the Beacon UI. When looking at the Beacon LOG files after following these steps, you will see that when the rule is executed, the Beacon tries to do a remote inventory (try to execute the Flexera agent remotely) on target devices. Even if you did not enable "Gather hardware and software inventory from all target devices". This is different from the real discovery of Oracle databases - where the Beacon tries to connect to the Oracle listener on the target devices using the IP ports specified in the "Action" as described by @ChrisG.
... View more
Mar 05, 2021
12:50 AM
2 Kudos
Hi Faten, Inventory on a device is usually collected by an agent. The agent can be the Flexera agent, but could also be another agent like SCCM. The inventory date is when the agent did run and collected these data. We often refer to these data as hardware, installer, file and WMI evidence. The Oracle inventory date is when an Oracle database has been scanned by SQL scripts. There are two alternatives for collecting Oracle inventory data: When a Flexera agent detects an Oracle database on the device when collecting hardware and software inventory data, it will try to execute the Oracle GLAS (LMS) SQL scripts on the Oracle database for collecting the Oracle specific inventory data. This is often referred to as 'Oracle introspection'. There also is the traditional way of collecting Oracle inventory data remotely by executing the Oracle GLAS (LMS) SQL scripts from a Beacon. This is more complex to configure and will require creating a dedicated Oracle account on each Oracle database that needs to be configured in the Beacon password store. It also requires an Oracle client that is compatible with all Oracle databases to be scanned to be installed on the Beacon, and the typical Oracle IP ports to (default 1521) to be open between the Beacon and the target Oracle databases. Because of this complexity, most companies prefer installing a Flexera agent on their Oracle servers these days. For the first scanning option, the Inventory date and the Oracle Inventory date can be different for example if the Oracle database is not running when the Flexera agent runs on a device. In these cases, the Inventory date will be more recent than the Oracle inventory date. Generally, if the Oracle database is scanned by the Flexera agent, both dates should be consistent though. In case your Oracle Inventory date is much older than your Inventory date, there potentially is an issue with scanning the Oracle database that you should look into. In case the Oracle database scanning is done remotely (second option), the timing for collecting hardware and software information by an agent and the timing for scanning Oracle databases remotely is configured independently. In this case, both dates will generally be different.
... View more
Mar 02, 2021
11:01 AM
1 Kudo
No, for defining a target in FNMS, you don't have to manage subnets. You can use one of the alternatives that can be selected when you configure a target. However, you might be confusing different ways for monitoring software usage: Collecting usage data for applications that are used interactively is done by a background task. On Windows, this task is a Windows service named "Flexera Inventory Manager security service" that is running permanently. This Windows service will track usage for applications that are used interactively only. Collecting usage data specifically for Oracle database products relies on the Oracle introspection performed by the Flexera agent - using the Oracle GLAS (LMS) SQL scripts - as you suspected. This is relevant for licensing, as Oracle rules define that certain database Options like 'Partitioning' are licensable only if they are installed AND used. Usage for Microsoft server products including Microsoft Exchange and SQL Server is based on the Flexera Agent evaluating Microsoft Client Access (CAL) connections to the server. This is a third - independent - way to collect application usage data that can be used for certain Microsoft server products only. Technically, the Flexera agent looks at LOG data on the server that track client access. This CAL tracking feature can be enabled or disabled by configuring a target in FNMS only, you cannot switch it on when installing the Flexera agent. Costs for tracking usage data in terms of additional database/disk usage is low. Keep in mind that for countries with "challenging" legal restrictions like Germany and France, you typically need approval from the 'Workers Council' before switching usage tracking on (using option #1 on the list above).
... View more
Mar 02, 2021
10:21 AM
3 Kudos
Hi Mathias, It's probably nice to "be on a roll" 😄 ? For enabling the usage tracking, you don't have to redeploy agents or reconfigure agents individually. This feature can be enabled or disabled remotely by using the FNMS 'Target' feature. Basically, you: Go to 'Discovery & Inventory > Inventory > Discovery and Inventory Rules' On the 'Targets' tab, use the 'Create a target' button for configuring a new target Give your target a name and use one of the options under "Define machines to target" for selecting target computers. Using 'Site or subnet' usually is a good choice. Under "Application usage options", select 'Allow application usage tracking on these targets' There is no need for using this target in a rule in FNMS. As with the other options that you can configure for a target, usage tracking will be enabled on a device if: At least one target matches the device where usage tracking is allowed. No target matches the device where usage tracking is denied (Do not allow) Keep in mind that applications are tracked if they are being used interactively only. In a datacenter, you probably have servers running applications like Oracle databases or Microsoft Exchange. These server applications are used by connecting to them over the network. This sort of 'usage' will not be tracked.
... View more
Latest posts by erwinlindemann
Subject | Views | Posted |
---|---|---|
103 | Mar 31, 2021 11:37 AM | |
69 | Mar 31, 2021 08:57 AM | |
46 | Mar 24, 2021 06:11 PM | |
51 | Mar 24, 2021 06:07 PM | |
110 | Mar 23, 2021 05:13 PM | |
117 | Mar 19, 2021 02:40 PM | |
70 | Mar 18, 2021 07:58 AM | |
68 | Mar 16, 2021 09:48 AM | |
52 | Mar 11, 2021 03:11 PM | |
109 | Mar 10, 2021 06:16 AM |
Activity Feed
- Got a Kudo for Re: EOSL information needed. Apr 06, 2021 09:25 PM
- Got a Kudo for Re: ovirt hypervisor and virtual machines. Apr 01, 2021 06:55 AM
- Got a Kudo for Re: ovirt hypervisor and virtual machines. Mar 31, 2021 08:28 PM
- Posted Re: EOSL information needed on FlexNet Manager Forum. Mar 31, 2021 11:37 AM
- Kudoed Re: ovirt hypervisor and virtual machines for kclausen. Mar 31, 2021 09:12 AM
- Got a Kudo for Re: ovirt hypervisor and virtual machines. Mar 31, 2021 08:58 AM
- Posted Re: ovirt hypervisor and virtual machines on FlexNet Manager Forum. Mar 31, 2021 08:57 AM
- Kudoed Re: Basic FNMS for On Prem 2002 Questions for a Stone Cold Newby for mfranz. Mar 29, 2021 12:46 PM
- Kudoed Re: User created role preventing devices from consuming licences for mfranz. Mar 25, 2021 05:40 AM
- Got a Kudo for Re: FNMS Management View Index views. Mar 25, 2021 03:47 AM
- Got a Kudo for Re: How do I create new Responsibility types for Contract Properties. Mar 25, 2021 03:46 AM
- Posted Re: How do I create new Responsibility types for Contract Properties on FlexNet Manager Forum. Mar 24, 2021 06:11 PM
- Posted Re: FNMS Management View Index views on FlexNet Manager Forum. Mar 24, 2021 06:07 PM
- Got a Kudo for Re: Edit application properties. Mar 24, 2021 08:35 AM
- Got a Kudo for Re: Edit application properties. Mar 24, 2021 07:53 AM
- Kudoed Re: Audit checklist for FNMS platform for mfranz. Mar 24, 2021 07:30 AM
- Kudoed Re: Error "There is a problem on the beacon. The beacon could not determine if an upgrade is required." for mengmeng_ge. Mar 24, 2021 07:27 AM
- Kudoed Re: Step by Step guide, how to update FNMS to the next version for ChrisG. Mar 23, 2021 05:15 PM
- Posted Re: Edit application properties on FlexNet Manager Forum. Mar 23, 2021 05:13 PM
- Kudoed Re: FNMS Application Usage Metering for Ronny_OO7. Mar 19, 2021 03:33 PM