About MurrayPeters

MurrayPeters · ‎May 05, 2020

Hi @SandeepKolhe , If you have a XenApp adapter configured writing to a staging database, the beacon connection should be the Citrix Xenapp type - not the Edgesight one. The error you are seeing happens because the schema is different between the Citrix Xenapp staging database and the Citrix Edgesight. regards, Murray

MurrayPeters · ‎Feb 17, 2020

Hi, This mechanism is very useful, but can you please clarify which agent preferences can be set using this process and how would we determine the actual KeyName for the preference? thanks Murray

MurrayPeters · ‎Feb 13, 2020

Hi Aamer, Very happy to see this being discussed and hopefully added to the product as it comes up with every project I do. It's critical that the customer be made aware of the compliance risk related to VM's that aren't reporting inventory as it represents a gap in coverage. FNMS has the data, but without having access to the DB to run queries it's impossible to report on those gaps. I'm not sure I follow where you are suggesting you might add the views of these VM's. Whilst it might be useful to see them when you look at a host record and see the VM's residing on it (highlighting which VM's do/don't have full inventory) it will be important that we can export the full list of hosts/vm's in one report so the customer can review/action as needed. thanks, Murray

MurrayPeters · ‎Feb 10, 2020

Hi Derek, For windows, it would be %temp% but in the context of the account running the process. So, if you run ndtrack.exe from the command line using your own account it will be in your own temp directory. If ndtrack.exe is initiated by the installed agent (which exists as a windows service) then the logs will be in the temp directory of the Local System account (which would resolve to the windows temp directory). So, check what account is running the process, then go to the %temp% folder for that user. Murray

MurrayPeters · ‎Jan 22, 2020

Hi - yes that is possible. Take a look at the following document which describes the process for extracting data from FNMS into Data Platform: https://helpnet.flexerasoftware.com/dataplatform55/dp_fnms_extract.pdf -Murray

MurrayPeters · ‎Dec 16, 2019

Hi, A http 401 error is essentially an unauthorized error suggesting the account the beacon is presenting itself is disallowed by the FNMS server. Is it possible that the credentials configured for your beacon to use for uploads/downloads has become invalid (password expired for example)? If you are using FNMS cloud too it might be that someone has inadvertently clicked on the button to download a configuration for the beacon without then importing it into the beacon ui. Every time you press that button it generates new settings making the old configuration invalid. regards, Murray

MurrayPeters · ‎Nov 19, 2019

Hi Jean, The "FlexNet Manager Platform Reports and Dashboard" data model does provide access to User data and also has links between Licenses and Users. However this data model is only available for On Prem FNMS instances, so if you are using FNMS Cloud then unfortunately you don't have access to that data. Here is a screenshot of what the objects look like in the on prem model: Murray

MurrayPeters · ‎Nov 05, 2019

Hi Jean, The link that you referred to is related specifically to the "FlexNet Manager for Engineering Applications" (or FNMEA) product. Both FNMEA and FNMS utilise Cognos for advanced reporting and dsahboards, but the "Chargeback" reports discussed in that article are only relevant for FNMEA. - Murray

MurrayPeters · ‎Oct 22, 2019

Do you have access to the Product and License Center (PLC)? That is the location to access/download any products and licenses that you have entitlements for: Within the PLC you can then go to FlexNet Manager Platform, choose the version and look for the appropriate product to download. Note the exact name of what you refer to may be different over the releases, for example the current name is " Flexera Analytics 2018 R2" -Murray

MurrayPeters · ‎Oct 20, 2019

Hi Dennis, One of the main reasons for having multiple sources in one process is because you want to de-dupe the records - for example if computer with serial number XYZ0001 exists in both FNMS and SCCM then Normalize will identify that accordingly. If however you only ever want to look at SCCM data in isolation, then you could use a separate process. -Murray

MurrayPeters · ‎Oct 18, 2019

Hi, Yes – the data modelling of those fields (#cores etc) (at best) is inconsistent, but in reality is just wrong. If you right click on one that has the hash/pound symbol and choose “Properties” you’ll see that “Usage=Attribute”, whereas the Properties of the one with the L shaped ruler shows “Usage=Measure”. You’ll also note that the Aggregate function in the properties is Count/Total respectively. What that means is when you are just displaying the values of the records at the lowest level (i.e. individual/unique machine) then the correct Core count will be shown, but if you are rendering a widget that is aggregating the records then you will get inconsistent behavior between the two. I’d suggest you submit a support case to Flexera to register the issue, but in the short term you may still be able to achieve what you need by using a Calculated field. For example, if you : right click the “No. of Cores” field under the VM Host object and select “Create calculation” select “Use calculation editor” change the expression to be (just remove the + 😞 [FNMPS-DW-DS][VM Host].[No of Cores] Change the Name of the calculated field to something like “VMHostCoreCount” Click OK. You should then have a new field at the bottom of all of the data objects which you can set the Properties to be: Usage: Measure Aggregate: Total Hopefully if you then use the VMHostCoreCount it will aggregate as you want. If I have misunderstood what you’re trying to achieve feel free to send me a private message with details and I’d be happy to see if I can produce the output you are looking for. -Murray

MurrayPeters · ‎Oct 17, 2019

Hi Suman, The AD queries that the beacon makes don't require privileged credentials to execute. Any domain user can normally run the same queries to "read" the same level of info the beacon collects. So, by default a standard install of the beacon will be primed to collect AD data from the domain it is connected to. If you don't want the beacon to collect AD data it would be best to remove the task, or make sure there is no active schedule for it. -Murray

MurrayPeters · ‎Oct 06, 2019

Hi Anne, For on prem FNMS environments the ability to utilise SQL as the source of queries has always been available - though since Cognos has evolved featurewise and (access rights/license levels) there has been some caveats: For Cognos 10.x environments: Using SQL queries in Report Studio required the user to be assigned at least a "Professional User" license. For Cognos 11.x environments: Licensing was simplified to just the two "Analytics User" and "Analytics Administrator" levels - both of these can use SQL queries. This release introduced the whol new UI and Dashboard environment which is widget driven & essentially requires data models to be DQM (Dynamic Query Model) Note: For FNMS, only the "Flexera Data Models" model is DQM the others are CQM (Compatible) and will not work in the Dashboard environment, but will work fine in the Reporting Studio/environment. So: to use SQL in the Reporting environment you can: Create a Report (I am using the "FlexNet Manager Platform Reports and Dashboard" data model) Drag a SQL Query from the toolbox into the Queries For the Properties of the "SQL" query choose: SQL Syntax : Pass-through Data Source : Choose the database you want to access (FNMP-Dashboard is the compliance DB, FNMP-DW-DS is the Data warehouse). SQL : Enter the SQL code here When you close the SQL window Cognos will validate the query and save the columns returned by the query for you to use in the report. You can then build your report using whichever visualisations you want. Note: if you have numeric fields that you want Cognos to automatically aggregate then you should explicitly set the appropriate aggregation formula (usually Sum/Total, but could be Max/Min/Average etc). If you want to build dashboards using SQL then the approach is different but can be done by starting with creating a Data Server, then build a Data Module (allowing you to specify joins between subjects/tables) and then possibly Data Sets. You can then choose the Data Module or Data Set as the source of data for your Dashboard. I presume you are really just asking for SQL in Reports though so I'll leave it there. Let us know how you get on. Murray

MurrayPeters · ‎Oct 06, 2019

Hi David, If you create a calculation (for eg right click a measure and choose Create Calculation - then select "Use calculation editor" you should be able to enter a formaula for your calculation - something like: if ([Flexera Relational Model].[License measures].[Consumption count] > 0) then ([Flexera Relational Model].[License measures].[Entitlement count] * [Flexera Relational Model].[License measures].[Unit price]) else (0) I haven't tested this example - so you should check that it gives the expected results when returning individual rows (eg in a list for each record), but also watch out for aggregated summaries - you might need to explicitly control the aggregation formula (Sum etc). Murray

MurrayPeters · ‎Sep 25, 2019

Hi John, Yes - the beacon initiated Oracle DB introspection will generate inventory for each of the nodes in the cluster at once - independent of which node it actually gets attached to when it makes the connection. You would still need to collect hardware inventory from each node though as that is still required to determine the consumption. Regarding OS authentication failing - if it's failing because the default (Local System) account for the agent windows service is not a DBA then you could look at the command line options the agent supports to control the account used to connect (OracleInventoryUser). However if OS authentication is disabled entirely then you are correct that the beacon approach needs to be used. -Murray

Online Status	Offline
Date Last Visited	‎Feb 25, 2021 02:57 AM

Re: Citrix XenApp Server Adapter issue while execute import

Re: Utilising the DB to roll out an agent preference to all devices within a Target, or all devices ...

Re: How important for your business to know virtual machines that are not inventoried

Re: What is the value of $(TempDirectory) for logs?

Re: FNMS to Data Platform

Re: HTTP 401 error from Beacon to App Server

Re: Reporting on User in Analytics

Re: Report Designer for FlexNet Manager Suite

Re: Report Designer for FlexNet Manager Suite

Re: How do you manage data sources for Normalization (all in one process or extra processes)

Re: Cognos Analytics - Inventory Module

Re: Inventory beacon collecting active directory data without any LDAP integration

Re: Reporting on COGNOS

Re: Flexera Analytics Widget (Under-Consumption Count)

Re: Oracle RAC database inventory

Re: Citrix XenApp Server Adapter issue while execute import

Re: Utilising the DB to roll out an agent preference to all devices within a Target, or all devices ...

Re: How important for your business to know virtual machines that are not inventoried

Re: What is the value of $(TempDirectory) for logs?

Re: FNMS to Data Platform

Re: HTTP 401 error from Beacon to App Server

Re: Reporting on User in Analytics

Re: Report Designer for FlexNet Manager Suite

Re: Report Designer for FlexNet Manager Suite

Re: How do you manage data sources for Normalization (all in one process or extra processes)