Jan 15, 2023
06:01 PM
Hi all,
A workaround that works for me is to insert the following line as the first instruction in the Step "Snapshot Optimization_Snapshot_FACT data" (order = 155).
SELECT TOP 1 @LatestSnapshotDate=SnapshotDate from Snapshot_DIM order by SnapshotDate DESC
The variable "@LatestSnapshotDate" is intended to be set via the previous step called "GetLatest Snapshot Date" (Order=150), but the variable is being reflected back in the subsequent step as a full datetime string instead of a yyyy-mm-dd (hence the SQL error that is being seen).
Here is what the file extract looks like (highlighted in yellow is the line added):
Of course, please defer to Flexera formal advice on the issue, but just thought I'd share this as a workaround.
regards, Murray
... View more
Nov 23, 2022
04:22 PM
2 Kudos
Hi Andi,
I have implemented this for ITAM API's (not Data Platform/IT Visibility). The data platform API's are different but the concepts would be the same.
This is achievable, but not trivial as you need to leverage multiple Power Queries to API calls that submit your refresh token to get an access (bearer) token, then use that for subsequent API calls (which may return one page of data at a time) until you have all data returned, then make that data available through the data model (in PowerBI, or even Excel directly).
Here's a snippet I use to get the access token initially (RT is a parameter which stores my personal refresh token & F1Env is either "eu" or "com" depending on whether your org is hosted in Europe or the US):
() =>
let body = "grant_type=refresh_token&refresh_token=" & Text.From(RT), Data = Json.Document(Web.Contents("https://login.flexera." & F1env & "/oidc/token", [Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])), access_token = Data[access_token] in access_token
You can then use the results from the query above in the header of actual API calls - the tricky part (for me) was getting the paging working correctly).
regards, Murray
... View more
Sep 08, 2022
10:37 PM
I think there is an error in steps 2d, 8b and 10b as you cannot specify both commands together: -genkeypair and -exportcert.
I suspect you just need to remove -genkeypair as this step is intended to simply export the cert.
... View more
Jun 16, 2022
08:18 AM
Thanks Cap!
I have lots of customers with existing AD adapters that update both the Email and Alternate Email fields in ITAM with LDAP business adapters running on beacons. Are you saying that this new enhancement will now start populating the "Email" address in ITAM ? And if so is it using the Email address from AD, or the userPrincipalName, or a rule that relates to both?
It's critical we understand the change as whilst I'm sure it's a great step forward for OOTB/new customers we need to make sure the integrity of existing customers is guaranteed/managed.
Other qns of interest from me on this topic 🙂
* You can probably tell I'm uncertain if this change affects the HR roster import into SaaS users, or the sync between SaaS and ITAM. Please add any clarification you can as to the order/sequencing/dependencies.
* Is the AD integration for Azure AD or on prem AD, or both? Or is there *any* dependencies on having AD sync enabled?
... View more
Jun 16, 2022
08:03 AM
Hi Team,
Does the "Support for certificate authentication" imply that that on-prem Data Platform can now authenticate and apply access rights for users across domains? I ask this based on previous limitations of how LDAP(S) configuration required all Data Platform users to be within the same LDAP scope - both for initial authentication and then applying access rights.
So - can you please clarify how the certificate authentication intersects with any domain boundary issues related to access rights of users who end up being authenticated with the client certs?
thanks, Murray
... View more
Jun 16, 2022
07:54 AM
1 Kudo
Can you please clarify exactly how this works (AD email address sync) as we have previously needed to build business adapters that import both email and userprincipal attributes from AD (into the email and alternateemail attributes for users in FNMS) to ensure that SaaS Manager Imports and even FlexNet Manager imports from Microsoft 365 inventory connectors do not cause user duplication.
So does this new capability now populate either of the default Email/Alternate Email fields in User records? If so, is it optional (i.e. needs to be enabled) so that it doesn't clobber previously necessary customisations in place?
I understand the enhancement/step forward which is great but am cautious/concerned about the potential impact on existing customisations that were absolutely required for data integrity in the past.
thanks, Murray
... View more
Jun 16, 2022
02:52 AM
1 Kudo
@ChrisG - when sorting the "Inventory Device Matching" view by "Inventory Source" we see an Inventory source called TDS - even though there is no such inventory source connection defined (at least by us), or visible in the "Inventory Data Imports" view.
I'm guessing this relates to Flexera One/Technopedia integration (maybe TDS stands for Technopedia Data Services)?
... View more
Jun 08, 2022
09:47 PM
1 Kudo
OK - so the answer to your core question is no, i.e. there is no inbuilt mechanism to consume FlexNet reports as a data source for Cognos reports or dashboards.
For reference though, Custom Properties are available in the "FlexNet Manager Platform Reports and Dasboards" data model.
However this data model can only be used reliably within Cognos Reports and not within the Dashboard environment - because this data model is a legacy model that was built using CQM (compatible query mode) and not DQM (dynamic query mode) which the new models use specifically for Dashboard development.
To be able to use custom properties within Dashboard widgets it would be possible, but you would need to invest some time into defining the fields you need and then create a DataSet based on a SQL query and possibly a simple Data Module (which defines the interpretation of the fields and joins to any other data modules you might want to relate the data to). Data Modules are DQM based so work perfectly within the Dashboard environment.
I get that your point is asking about the convenience of using already built the FlexNet reports as a data source, but that's just not possible (good idea though).
... View more
Jun 08, 2022
10:06 AM
1 Kudo
@bmaudlin - I'm a supporter of Cognos as an Enterprise scale BI product (alongside all those mentioned above which are also very capable) so would be interested to hear a distilled version of your use case. The issue isn't going to be a tool/capability issue - moreso whether the data is available and how performant the queries generated from your report are (which is very dependent on the Flexera data models).
Can you explain more the Flexera objects you want to report on and the primary fields you need in the report but are struggling to access through the data model? It would also help to know if your Flexera landscape is on-prem or cloud based (Flexera One)?
For on-prem (FNMS) there are no technical limits (**) as you can leverage either Flexera published data models or use your own SQL Queries, Data Sets or build your own data modules (including uploading files to join to Flexera data in reports). But for Flexera One customers there are boundaries as it's not possible to access any database directly and Flexera have disabled the other 'self service' capabilities such as building your own data sets/modules (which is exactly what you do in Tableau/Microsoft BI).
If you can share a description of a data set you want to report on and maybe even the format (grids/charts) I'd be happy to respond with an example of what (I believe) can be done.
regards, Murray.
(**) I should be careful here as my understanding is that Flexera's use of Cognos is an OEM agreement which restricts the use of what data you can use within Cognos. So you shouldn't/couldn't use it for footy tipping, planning parties or storing wordle strategies for example, but anything related to Flexera/FNMS is acceptable.
... View more
May 05, 2020
07:24 PM
2 Kudos
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
... View more
Feb 17, 2020
05:40 PM
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
... View more
Feb 13, 2020
06:52 PM
3 Kudos
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
... View more
Feb 10, 2020
11:09 PM
6 Kudos
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
... View more
Jan 22, 2020
06:08 PM
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
... View more
Dec 16, 2019
03:50 PM
2 Kudos
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
... View more
Latest posts by MurrayPeters
Subject | Views | Posted |
---|---|---|
822 | Jan 15, 2023 06:01 PM | |
378 | Nov 23, 2022 04:22 PM | |
653 | Sep 08, 2022 10:37 PM | |
912 | Jun 16, 2022 08:18 AM | |
624 | Jun 16, 2022 08:03 AM | |
930 | Jun 16, 2022 07:54 AM | |
824 | Jun 16, 2022 02:52 AM | |
1142 | Jun 08, 2022 09:47 PM | |
1176 | Jun 08, 2022 10:06 AM | |
1143 | May 05, 2020 07:24 PM |
Activity Feed
- Posted Re: Known Issue: Data warehouse export step "Snapshot Optimization_Snapshot_FACT data" may fail with error: "Conversion failed when converting date and/or time from character string." (IOK-1005577) on FlexNet Manager Suite Known Issues. Jan 15, 2023 06:01 PM
- Got a Kudo for Re: For Dummies instructions on how to connect PowerBI to FlexeraOne APIs as a data source. Nov 23, 2022 06:37 PM
- Got a Kudo for Re: For Dummies instructions on how to connect PowerBI to FlexeraOne APIs as a data source. Nov 23, 2022 04:27 PM
- Posted Re: For Dummies instructions on how to connect PowerBI to FlexeraOne APIs as a data source on Flexera One Forum. Nov 23, 2022 04:22 PM
- Posted Re: Configure a CA Certificate for FlexNet Manager for Engineering Applications Admin and Reporting services on FlexNet Manager Knowledge Base. Sep 08, 2022 10:37 PM
- Got a Kudo for Re: Flexera One ITAM update for June 2022. Jun 16, 2022 05:59 PM
- Posted Re: Flexera One ITAM update for June 2022 on Flexera One Blog. Jun 16, 2022 08:18 AM
- Posted Re: Data Platform 2022 is Now Available! on Data Platform Release Blog. Jun 16, 2022 08:03 AM
- Posted Re: Flexera One ITAM update for June 2022 on Flexera One Blog. Jun 16, 2022 07:54 AM
- Got a Kudo for Re: SCCM record and FlexNet agent record not merging. Jun 16, 2022 03:36 AM
- Posted Re: SCCM record and FlexNet agent record not merging on FlexNet Manager Forum. Jun 16, 2022 02:52 AM
- Got a Kudo for Re: Flexnet reported converted to a widget?. Jun 08, 2022 11:16 PM
- Posted Re: Flexnet reported converted to a widget? on FlexNet Manager Forum. Jun 08, 2022 09:47 PM
- Got a Kudo for Re: Flexnet reported converted to a widget?. Jun 08, 2022 04:55 PM
- Posted Re: Flexnet reported converted to a widget? on FlexNet Manager Forum. Jun 08, 2022 10:06 AM
- Kudoed Deduplication Rules in Data Platform Normalize for dsood. May 17, 2022 01:40 AM
- Kudoed Known Issue: Calculated user in All Assets grid may be blank while a non-blank value appears on the asset property page (IOJ-1926911) for FlexeraBot. Mar 08, 2022 10:46 PM
- Got a Kudo for Re: Reporting on COGNOS. Jun 18, 2021 02:03 PM
- Got a Kudo for Re: How to visualize Office 365 usage in FNMS. Feb 18, 2021 06:48 PM
- Kudoed More about Linux Docker container support in FlexNet Manager Suite 2020 R1 for tferguson. Aug 14, 2020 12:19 AM