Thanks  @Darshana  No I didn't but did now and it works. Only I now have an new issue:  We can’t retrieve the data from data set Flexera Data Models.  I have checked the connection details and Native client works but jdbc is failing. Now I wonder how should the connection look like? ;LOCAL;OL;DBInfo_Type=MS;Provider=SQLNCLI11;Data Source=fnmsdbserver.ont.customer.nl;Integrated Security=SSPI;Provider_String=Initial Catalog=FNMS_FM;@COLSEQ=IBM_JD_CNX_STR:;LOCAL;JD-SS;URL=jdbc:sqlserver://fnmsdbserver.ont.customer.nl:1433;DATABASE=FNMS_FM;LOGINTIMEOUT=600;integratedSecurity=true;DRIVER_NAME=com.microsoft.sqlserver.jdbc.SQLServerDriver     ... View more

@davidle and @WheresThePizza  Thanks for your help.  Yes the test connection works fine. I have created an case and received the sql command to update the rights. Unfortunate the result is the same. Also I wonder if I can share the command here? As it is hacking FNMS a bit.. ... View more

This is exacltly what I also see. Couldn't find settings tab. ... View more

I am currently implementing FNMS2020R2. This has a newer Cognos version 11.0.13. and running in to the issue that reports are not being loaded because of db connection. (testing connection works fine) This issue is being caused by TLS 1.2 and SQL server 2017.  I have performed all steps and now need to : click the Set Properties button: OK Go to the Settings tab Add the following the Additional JVM Arguments for the QueryService setting. The settingst tab is not availlable in this cognos version. Regards Ronald ... View more

HI Diggesh, Thanks This looks nice. Altough it helps. I wonder if it is complete and 100% correct? For example it mentioned: rfc/sns+rfc connectiions to beacon. But you must mean from Admin module to Beacon? Cheers Ronald ... View more

Hi Joan,   I agree where you are coming from and have also created an Idea so that this is changed https://flexerasfdc.ideas.aha.io/ideas/FNMS-I-41   Regards Ronald ... View more

Both files match with eachother so perhaps 1 can be removed? ... View more

Thanks John, I agree but should that mean al data should be kept? Why not let users deside? Now it is causing other issues. Thanks ... View more

Thanks John, That is not what support is stating: The way it works, is that the beacon pulls users and computers from AD, during the AD import process. (you can see what it brings over by disabling the upload tasks on the beacon, then running the AD import rule, and check the actdir.gz) This is then imported into the inventory db under tables starting with AD (i.e. ADcomputers, ADusers) During the reconcile process it reads the data from the AD tables and puts them into the Imported tables (i.e. importedusers). Then after that during the writer process of the reconcile, it merges data from other data sources (i.e. SCCM) into a single user record within the compliance tables Now what is supposed to happen, when you remove the user from a data source it is supposed to remove from FNMS, however if the user has multiple data sources it will not be removed from FNMS. easist way to check is to check the importedUser table and see what connections are creating that record   That is the reason I like to know the exact details. Once a user is imported from AD and also removed from AD it should be removed. But if this user is also listed in SCCM or other data source. The user is not removed? So how do we remove these users then? And why doesnt fnms remove these users?   ... View more