Calculated user value - data source

[KarolinaWilk1]

Hi,

I would like to ask what is the data source for Calculated User value in FNMS that refers to device's ownership?
Does it come from AD or from ndi. file?

Thank you for the response in the advance.
Karo

[jjensen · Accepted solution]

You are correct, the logged on user information comes in from the .NDI.

Specifically, the 'UserName' property in the Win32_ComputerSystem WMI class. Some other inventory sources are also capable of providing the 'last logged on' user information.

There is a table in the Compliance DB named ComplianceComputerUsage which records the 'tally' of last logged on users and the date they were recorded - the below query may be of some use to you, all you'd need to do is plug in the computer's hostname:

SELECT
ccu.ComplianceComputerUsageID,
ccu.ComplianceComputerID,
cc.ComputerName,
ccu.ComplianceUserID,
cu.FirstName,
cu.LastName,
cu.SAMAccountName,
ccu.DateRecorded
FROM ComplianceComputerUsage ccu
JOIN ComplianceComputer cc ON cc.ComplianceComputerID = ccu.ComplianceComputerID
JOIN ComplianceUser cu ON cu.ComplianceUserID = ccu.ComplianceUserID
WHERE ccu.ComplianceComputerID IN
(SELECT ComplianceComputerID FROM ComplianceComputer WHERE cc.ComputerName = 'ComputerNameGoesHere')
ORDER BY DateRecorded DESC

HTH,
Joseph

[jjensen]

Hello @KarolinaWilk1,

The below Online Help page goes into further detail on the Calculated User field:

https://docs.flexera.com/fnms/EN/WebHelp/index.html#topics/Dev-Ownership_tab.html

To summarise, it is the 'most frequent' logged on user over the previous 10 inventory collections. So you may also want to review the information for the field 'Last logged on', on the same page.

HTH,
Joseph

[KarolinaWilk1]

Hello Joseph,

Thank you for your reply but I reviewed the provided article before I posted my question and the frequence of logging into device is clear for me that it is the vital for the calcualation of calculated user. However, I would like to know from which data this 10 login frequence is taken. Does FlexNet inventory agent collects this information regarding that frequence either is it taken from AD or another invnetory source?

Best regards,

Karolina

[jjensen · Accepted solution]

You are correct, the logged on user information comes in from the .NDI.

Specifically, the 'UserName' property in the Win32_ComputerSystem WMI class. Some other inventory sources are also capable of providing the 'last logged on' user information.

There is a table in the Compliance DB named ComplianceComputerUsage which records the 'tally' of last logged on users and the date they were recorded - the below query may be of some use to you, all you'd need to do is plug in the computer's hostname:

SELECT
ccu.ComplianceComputerUsageID,
ccu.ComplianceComputerID,
cc.ComputerName,
ccu.ComplianceUserID,
cu.FirstName,
cu.LastName,
cu.SAMAccountName,
ccu.DateRecorded
FROM ComplianceComputerUsage ccu
JOIN ComplianceComputer cc ON cc.ComplianceComputerID = ccu.ComplianceComputerID
JOIN ComplianceUser cu ON cu.ComplianceUserID = ccu.ComplianceUserID
WHERE ccu.ComplianceComputerID IN
(SELECT ComplianceComputerID FROM ComplianceComputer WHERE cc.ComputerName = 'ComputerNameGoesHere')
ORDER BY DateRecorded DESC

HTH,
Joseph

[mfranz · Accepted solution]

Hi,

To really understand the source of the calculated user data, you can have a look at the various readers. The ManageSoft reader (FNMS Agent) does not have a step to import the calculated user:

I guess that's because the agents cannot provide data for calculating a user.

SCCM, on the other hand, does store a list of logins per machine. The reader simply groups them per machine and per user and then takes the person with the most logins:

There is only one step "GetLastLoggedOnUserData" inthe SCCM reader, but it does import both, LastLoggonOnUser and CalculatedUser.

Best regards,

Markward