Some users may have issues creating a community account See more here.

Extra points for Application Usage Tracking (AUT) in FNMP

Extra points for Application Usage Tracking (AUT) in FNMP

Summary

In some circumstancse, the imported File Evidence for the usage tracking does not contain the installation match counts. It also does not necessary matched by an existing ARL rule which logically should be covered. Such File Evidence is still need link to the application manually for tracking the usage.

Symptoms

/* For main workflow how to configure application usage tracking, please check KB: Q200826 */

This article will describe something doesn't cover by above KB but is useful for configuration AUT. It applies from FNMP 9.2.3 to older version.

In some circumstancse, the imported File Evidence for the usage tracking does not contain the installation match counts. It also does not necessary matched by an existing ARL rule which logically should be covered. Such File Evidence is still need link to the application manually for tracking the usage.

From sql DB structure perspective, there are some file evidences entries after compliance importer is completed, Those FE exist in the ImportedInstalledFileEvidenceUsage, but not in the ImportedInstalledFileEvidence. Such File Evidence will be found FNMP UI with 0 match counts as Unassigned (unmatched). In ARL logic the matching on file evidence is by matching Primary Key (Name,Version,Company, Description & FileSize) , however such usage file evidence will not be run through ARL matching mechanism. In another word even we have a ARL rule can cover the raw entry, the current product will create a raw entry with 0 match counts into FNMP still.


The following sql query can be used to find such file evidence (only in ImportedInstalledFileEvidenceUsage not ImportedInstalledFileEvidence)

/* checking the format of File Evidence)

SELECT * FROM ImportedFileEvidence
WHERE ExternalFileID IN
(
SELECT ExternalFileID
FROM ImportedInstalledFileEvidenceUsage
WHERE ExternalFileID NOT IN
(
SELECT ExternalFileID FROM ImportedInstalledFileEvidence
)
)
/* checking the usage information eg: LastUsedDate */

SELECT *
FROM ImportedInstalledFileEvidenceUsage
WHERE ExternalFileID NOT IN
(
SELECT ExternalFileID FROM ImportedInstalledFileEvidence
)


Resolution

1. Pick the 'new' unassigned File Evidence
2. Link to the corresponding SoftwareTitle
3. Make sure this SoftwareTitle Recognition is already happened via other ARL (through Installer Evidence, File Evidence, WMI, Suite etc)
4. Setting the Usage Period correctly
5. Create a license and link this application to the license
6. Another full Inventory Import (Not Reconcile only)

See attached file as a demonstration.
Was this article helpful? Yes No
100% helpful (1/1)
Comments

@Kevin_Hou wrote:
SummaryIn some circumstancse, the imported File Evidence for the usage tracking does not contain the installation match counts. It also does not necessary matched by an existing ARL rule which logically should be covered. Such File Evidence is still need link to the application manually for tracking the usage.
Symptoms/* For main workflow how to configure application usage tracking, please check KB: Q200826 */

This article will describe something doesn't cover by above KB but is useful for configuration AUT. It applies from FNMP 9.2.3 to older version.

In some circumstancse, the imported File Evidence for the usage tracking does not contain the installation match counts. It also does not necessary matched by an existing ARL rule which logically should be covered. Such File Evidence is still need link to the application manually for tracking the usage.

From sql DB structure perspective, there are some file evidences entries after compliance importer is completed, Those FE exist in the ImportedInstalledFileEvidenceUsage, but not in the ImportedInstalledFileEvidence. Such File Evidence will be found FNMP UI with 0 match counts as Unassigned (unmatched). In ARL logic the matching on file evidence is by matching Primary Key (Name,Version,Company, Description & FileSize) , however such usage file evidence will not be run through ARL matching mechanism. In another word even we have a ARL rule can cover the raw entry, the current product will create a raw entry with 0 match counts into FNMP still.


The following sql query can be used to find such file evidence (only in ImportedInstalledFileEvidenceUsage not ImportedInstalledFileEvidence)

/* checking the format of File Evidence)

SELECT * FROM ImportedFileEvidence
WHERE ExternalFileID IN
(
SELECT ExternalFileID usps tracking
FROM ImportedInstalledFileEvidenceUsage
WHERE ExternalFileID NOT IN
(
SELECT ExternalFileID FROM ImportedInstalledFileEvidence
)
)
 
/* checking the usage information eg: LastUsedDate */

SELECT *
FROM ImportedInstalledFileEvidenceUsage
WHERE ExternalFileID NOT IN
(
SELECT ExternalFileID FROM ImportedInstalledFileEvidence
)


Resolution1. Pick the 'new' unassigned File Evidence
2. Link to the corresponding SoftwareTitle
3. Make sure this SoftwareTitle Recognition is already happened via other ARL (through Installer Evidence, File Evidence, WMI, Suite etc)
4. Setting the Usage Period correctly
5. Create a license and link this application to the license
6. Another full Inventory Import (Not Reconcile only)

See attached file as a demonstration.

@Kevin_Hou  your steps help me in Tracking...

My pleasure @nikmil 

 

Kev

Version history
Revision #:
1 of 1
Last update:
‎May 19, 2018 01:00 PM
Updated by: