Jan 27, 2023
10:28 AM
Looked around the KB and community didn't find what I'm looking for so asking here. Is there a connector or has someone found a way to inject data from Workspace one to help manage Apple products? Thank you. /James
... View more
Aug 04, 2022
01:33 PM
We've been told in order to have Cognos work properly in the Flexnet Manager dashboard, we need to implement HTTPS. I cant rip and replace my whole env just for cognos. The Plan, Can I have two Application servers access the same Database? I would bring up a https enabled Batch server and an HTTPS Application Server point them to my normal database which is not HTTPS all for the sake of being able to use Cognos on the dashboard? Is there anything that would really break? Can a Batch and application server be on the same physical device?
... View more
Jul 19, 2022
09:11 AM
1 Kudo
The ask, I want to use the date filter for a custom report based on hardware assets. Report that has the feature I want to use is an inventory asset report “out of date inventory”. How can I recreate this function? I’m trying to update / reuse / fix / reproduce the canned report “out of date inventory”. Its kind of a nice report if your hardware device has ever actually reported inventory. However since its built on the Inventory asset and not the Hardware assets data set you cant add location or other fields from “assets”. Trying to add an advanced filter (fig 1) doesn’t even get me the filters on the fields I need. IT only displays two fields I can use. In fig 2 you can see I tried to add a filter to a report but it only showed two fields. what gives? Trying to define fields for advanced filters during custom reports writing (fig 3) produces the same result. They are not available for adding filters. Oh, but wait. You must define an advanced filter (fig 4). Yes, but for dates you actually are limited to setting dates. You can’t define number of days. Or at least it’s not obvious Dates must be set dates which means people viewing the report have to edit the dates. Not fitting the need of the user. Fig 1 Fig 2 Fig3 Fig 4
... View more
Jun 23, 2022
12:37 PM
I need to create a custom inventory looking for particular reg key on windows boxes. I tried creating custom evidence but coudn't find a corresponding "reg key". type of evidence. What am I missing? thank you, /James
... View more
Jun 13, 2022
07:42 AM
1 Kudo
I'm not sure how that helps. I'm running an sql query against the FNMSCompliance DB and if I have 100,000 assets I can only sql query 5000? The question remains. where do I adjust the Governor?
... View more
Jun 09, 2022
08:05 AM
1 Kudo
On prem solution: executing a sql query in Cognos for a report. Got an error: The number of rows retrieved for the user who has the identity '{, , Everyone, All Authenticated Users}' exceeds the limit of 5000. I reviewed my cognos configuration on the server and cant find that setting. My research shows I have to set the governor and of course the instructions say "go into catalog under user settings". what catalog are they talking about?
... View more
Jun 09, 2022
08:00 AM
Most insightful and thank you for your reply. where you post my custom fields should be don't seem to be where you indicated. But this does not surprise me. I inherited this system so custom fields may not have been set up correctly.
... View more
Jun 08, 2022
11:40 AM
We are on prem. simply put the difficulty is finding all the elements in the Flexnet datasets that support our reports. Maybe they are there maybe they are not. For example we have custom fields. are they in the dataset? I couldn't find them. and good luck coding sql against custom fields, i.e. forget it unless you are an sql god. and if I could create new datasets and uploads and exports then why the hell would I even bother using cognos? My point is, I have reports already crafted. The Flexnet tool is not too bad for that. even with custom fields, not the greatest but not too bad. there are other reports that are nice and use canned data. it just seems logical that I should be able to consume them as widgets and not have to figure out how they are crafted and what fields are the correct data elements.
... View more
Jun 06, 2022
10:53 AM
1 Kudo
I have reports we have created in flexnet, I also have the Cognos analytics working. Cognos looks to be a drag and drop from fields from a data model. This is confusing for the team. Is there a way to point cognos to the flexnet reports and say use that report? Why you ask? 1. We can't find the data fields and make the joins needed in cognos, flexnet manager does all that for you when you craft a report. 2. we want to visualize some of these reports and make them widgets.
... View more
Apr 08, 2022
12:00 PM
Reporting in flexnet is limited and is not meeting my needs for some reports. as such I'm having to write SQL reports for Power BI or Tableau. So one report I'm working on is having to show the link between the Asset name and its discovered device name. Anyone have any idea where that link/relationship is shown. I'm assuming it uses assid and device id and a relationship type somewhere.
... View more
Labels
- Labels:
-
Reporting
Mar 22, 2022
09:31 AM
I have a report of devices. Some fields on this report are completed some are not. I'd like to. transform this report into a metrics report showing a list fields, such as location, owner, is serial number complete? as total numbers such as something like this for my printer data: But this all requires calculated fields. It be great if I can turn this into a drill down report. Too complicated for Flexnet? Hmm? Field Not Null/Yes Null/No Total % Complete % Incomplete Measured Corporate structure 20,012 1,054 21,066 95.00% 5.00% Specific Location 20,344 722 21,066 96.57% 3.43% Floor 19,892 1,174 21,066 94.43% 5.57% IP Address 19,997 1,069 21,066 94.93% 5.07% Printer Mac Address 19,425 1,641 21,066 92.21% 7.79% Service ID 19,613 1,453 21,066 93.10% 6.90% Existing # of Trays 18,167 2,899 21,066 86.24% 13.76% Data Jack 10,395 10,671 21,066 49.34% 50.66%
... View more
Feb 18, 2022
01:10 PM
Thank you. yes. I just posted that I just found that. they just don't make it easy.
... View more
Feb 18, 2022
12:35 PM
I was going to follow up with a question but I eventually found it. Where do I match Asset Property valueID to its name from the UIItem table. because the name is not in the assetpropertyvalue table. and the ID's don't match. You have to take the name you are looking for and join it to the AssetTypeProperty table. ugh. why did they make it so complicated.
... View more
Feb 18, 2022
10:02 AM
I've inherited a flexnet manager studio instance that has custom attributes added to a custom tab for assets. I've reviewed the stored procedure : AddTabToWebUIPropertiesPage and I can see where the UI is updated to create the fields for the UI page. what I cant find is the data when an asset gets updated. I've reviewe Assets table, not there, I've reviewed the Itemresource table, not there. any suggestions?
... View more
Feb 04, 2022
03:47 PM
1 Kudo
We need to add a custom report to the flexnet manager console reports tree that is more complex than the built in report writer can handle. We are able to write the sql which can be turned into a viewtable. But I cant find a way to add it to the grid_view list of reports to be run in the console.
... View more
Latest posts by seabrig29
Subject | Views | Posted |
---|---|---|
32 | Jan 27, 2023 10:28 AM | |
175 | Aug 04, 2022 01:33 PM | |
138 | Jul 19, 2022 09:11 AM | |
380 | Jun 23, 2022 12:37 PM | |
295 | Jun 13, 2022 07:42 AM | |
370 | Jun 09, 2022 08:05 AM | |
615 | Jun 09, 2022 08:00 AM | |
731 | Jun 08, 2022 11:40 AM | |
854 | Jun 06, 2022 10:53 AM | |
265 | Apr 08, 2022 12:00 PM |
Activity Feed
- Posted Plugin or data integration from Workspace One Intelligent Hub to manage Mac Inventory? on FlexNet Manager Forum. Jan 27, 2023 10:28 AM
- Posted Another Cognos Question on FlexNet Manager Forum. Aug 04, 2022 01:33 PM
- Got a Kudo for Used report feature from canned report "out of date inventory". Jul 20, 2022 06:51 AM
- Posted Used report feature from canned report "out of date inventory" on FlexNet Manager Forum. Jul 19, 2022 09:11 AM
- Posted Reg key inventory? on FlexNet Manager Forum. Jun 23, 2022 12:37 PM
- Got a Kudo for Re: Cognos Row limit in flexnet Manager. Jun 16, 2022 03:50 AM
- Got a Kudo for Cognos Row limit in flexnet Manager. Jun 16, 2022 03:42 AM
- Posted Re: Cognos Row limit in flexnet Manager on FlexNet Manager Forum. Jun 13, 2022 07:42 AM
- Posted Cognos Row limit in flexnet Manager on FlexNet Manager Forum. Jun 09, 2022 08:05 AM
- Posted Re: Flexnet reported converted to a widget? on FlexNet Manager Forum. Jun 09, 2022 08:00 AM
- Posted Re: Flexnet reported converted to a widget? on FlexNet Manager Forum. Jun 08, 2022 11:40 AM
- Got a Kudo for Flexnet reported converted to a widget?. Jun 07, 2022 04:20 AM
- Posted Flexnet reported converted to a widget? on FlexNet Manager Forum. Jun 06, 2022 10:53 AM
- Posted Linked asset to discovered device on Flexera One Forum. Apr 08, 2022 12:00 PM
- Posted Calculations in reports on FlexNet Manager Forum. Mar 22, 2022 09:31 AM
- Posted Re: Custom attributes and where do they live? on FlexNet Manager Forum. Feb 18, 2022 01:10 PM
- Kudoed Re: Custom attributes and where do they live? for bheadley. Feb 18, 2022 01:09 PM
- Posted Re: Custom attributes and where do they live? on FlexNet Manager Forum. Feb 18, 2022 12:35 PM
- Kudoed Re: Custom attributes and where do they live? for bheadley. Feb 18, 2022 11:23 AM
- Posted Custom attributes and where do they live? on FlexNet Manager Forum. Feb 18, 2022 10:02 AM