cancel
Showing results for 
Search instead for 
Did you mean: 
joseph_kaufman
Flexera beginner

CASPER/JAMF Adapter to importing Last Used Date usage.xml

Does anyone have a working inventory adapter for importing usage metering (usage.xml) from JAMF (CASPER) that would work in on-premise FNMS 2016?
-Thnx Joseph
0 Kudos
4 Replies
Liz_Best
Pilgrim

Re: CASPER/JAMF Adapter to importing Last Used Date usage.xml

Hi Joseph,

Most likely any CASPER/JAMF adapters created and currently in use would be custom ones created by Flexera Global Services team and specific to that individual site. If you don't get a response here, and if you haven't already, I'd recommend opening a support case to connect with Services.

Regards,
Liz
0 Kudos
Flexera DAWN
Flexera

Re: CASPER/JAMF Adapter to importing Last Used Date usage.xml

That is not something that has been done by Flexera Services to date and to my knowledge we haven't looked at the data in JAMF to ensure everything is in place at this time to make the relationships required in FNMS to show usage.
0 Kudos
Community Manager ChrisG Community Manager
Community Manager

Re: CASPER/JAMF Adapter to importing Last Used Date usage.xml

The following query may work against your on-premises Casper/JAMF database (depending on your version) to extract data that could be used as the basis for importing data into the ImportedInstalledInstallerEvidenceUsage table in FlexNet. The usage data available from Casper/JAMF is limited and may not be particularly useful or useable by FlexNet, but hopefully is better than nothing.

SELECT
	LEFT(REPLACE(RTRIM(LTRIM(IFNULL(aul.application_details_id, ''))),'.app',''), 250) AS DisplayName,
	LEFT(RTRIM(LTRIM(IFNULL(aul.application_usage_log_id, ''))), 72) AS Version,
	'' AS Publisher, /* No publisher details available */
	aul.computer_id as MachineID,
	DATE_FORMAT(FROM_UNIXTIME(MAX(aul.usage_date_epoch)/1000), '%Y/%m/%d') AS LastUsedDate,
	/* 
	It's not possible to determine the usage period over which to count the number of sessions as 
	it's not possible to transfer data from the target FlexNet database to source Casper database for non-MSSQL data sources.
	Therefore, the number of sessions is hard coded to 1.
	*/
	1 AS NumberOfSessions
FROM application_usage_logs AS aul
WHERE RTRIM(aul.application_details_id) LIKE '%.app' 
GROUP BY DisplayName, Version, Publisher, MachineID 
(Anything expressed here is my own view and not necessarily that of my employer, Flexera. If my reply answers a question you have raised, please click "ACCEPT AS SOLUTION".)
Flexera DAWN
Flexera

Re: CASPER/JAMF Adapter to importing Last Used Date usage.xml

If I get a chance this week, I'll take a look at the API as well to see if the Usage is available in a usable format from the objects provided for the SaaS version of the adapter. As in the query Chris provided, we're likely to just be able to get Last Used Date without any knowledge of # of sessions, # of launches in a period, etc. which can be useful in determining if an end user is ACTIVELY utilizing an application or merely launched it once.
0 Kudos