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

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

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

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

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

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

@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

@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

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