There is a similar discussion found here: https://community.flexera.com/t5/FlexNet-Manager-Forum/O365-token-generation-quot-interaction-required-quot-error/m-p/132054/highlight/true#M4702 where a link to the Microsoft site with the necessary information is included. https://docs.microsoft.com/en-us/office365/enterprise/urls-and-ip-address-ranges ... View more

The Compliance database is FNMP. ... View more

That was a very good catch! It does retrieve a ComplianceOperator based on the session context. This happens about 10 layers deep in a call to the table function 'TableGetSessionOperatorID' when the parameter for Operator login is set to NULL as you discovered. Thanks for finding this and for pointing it out as well. Good luck with custom report! ... View more

If you are talking about a SQL View then I think that you could use something like this to retrieve the data using the logged in operator: --------------- DECLARE @OperatorLogin NVARCHAR(256) -- Retrieve the OperatorLogin value based on the Operator who is logged in to FNMS currently SELECT @OperatorLogin = co.OperatorLogin FROM CurrentOperator op INNER JOIN ComplianceOperator co ON op.ComplianceOperatorID = co.ComplianceOperatorID SELECT * FROM ComputerByOperatorLogin(@OperatorLogin) -------------------- I am not certain if this is what you are looking for or not. If not, please add any detail you can for where you have seen ComputerByOperatorLogin used previously. Thanks, Bill     ... View more

What version of FNMS are you currently using? It appears that there was an enhancement added to get customers past this in FNMS 2021 R1 but it may have only been for ILMT SQL instances. There is also a KB article related to this here: https://community.flexera.com/t5/FlexNet-Manager-Knowledge-Base/ILMT-import-Failed-to-execute-Reader-SendInstallerEvidence-Error/ta-p/189119. I do see that the support team has had success with getting ILMT DB2 customers past this issue so it would probably be best to go with the route of opening a support case to help get you the assistance you need. HTH, Bill ... View more

Hello @joan_mckinley. I am not 100% certain why you're seeing an error but I can see why the SQL above is not adding a custom property as you would like to see. The value in the '@RelativePositionTo' is set to 'Used' which is the label for one of the columns in the grid for the tab you reference in the SQL. Custom properties cannot be added directly to a grid. They need to be positioned adjacent to controls like text boxes and drop down lists/combo boxes and things like that. Once the custom property is added it can be used in a grid or added to the grid from the 'choose the columns to display' option at the top right side above the grid if it is of the type of information displayed in the grid. The product documentation has a list of controls for each of the targets to which custom controls can be added. Licenses are found specifically here: https://docs.flexera.com/FlexNetManagerSuite2021R1/EN/SystemRef/index.html#SysRef/CustomProperties/topics/CP-DBI_Licenses.html. I hope that gives you the information you need. Bill ... View more

No, it is not simple that is for sure. I think the reason behind this is that it is used for different Target Types so ComplianceComputer, SoftwareLicense, Contract, Purchases, etc. and there needed to be a standard way to get at the data for the UI to work properly. Data normalization of some form may have been a different way to handle it but who knows if that might have ended up being even more complex. Glad to hear that you've got it figured out. ... View more

You are correct. It is in the banner at the top of the page with more info here as well: https://community.flexera.com/t5/Community-Notices/Flexera-Documentation-Unavailable-11-February-13-February-2022/ba-p/223824#M165 ... View more