I am looking for the views that I have created in the "Management View Index" tab in Flexera Manager Suite. I wan't to automatically download the views in csv format from the database, periodically. Where is this information stored?
Apr 17, 2023 06:23 AM
Hi Bleepie, I hope you're having a good week so far?
Thanks for reaching out on the Community.
I'd initially start referring to ComplianceSavedSearch.
This should have details of all Custom and out of the Box Reports, along with Saved Views, on the Compliance database.
You might need to filter by the ComplianceSearchFolderID for specifically the Saved Views though, there doesn't seem to be a clear differentiator between Searches/Reports and Views:
Apr 17, 2023 06:44 AM
Hi Jack, I am doing fine! How about you?
I have found the table and one of the views that I have made. It seems the properties "SavedSearchLink" and "SavedSearchFilter" are used withing the GUI to tell FNMS what the View should show.
I was wondering, if I can use the data in ComplianceSavedSearch from the database to query the database to show me the data that the view itself shows?
What we need eventually is some kind of script that gets the data from the view, saves it to a .csv file and place it somewhere on the db server. The client can then retrieve the file. We do not want to give the Client access to FNMS GUI so this is some kind of workaround.
The first thing that I can think of is a (Powershell) script to fetch the data from ComplianceSavedSearch table using a SQL query, then filter the data from "SavedSearchFilter" and use that data to create a new SQL query to fetch the actual computer data from whatever table the data is in. But maybe there is another, easier, faster or already existing way of doing this?
Apr 17, 2023 07:34 AM
Apr 17, 2023 08:05 AM
The views displayed in the "Management View Index" tab in Flexera Manager Suite UI are stored in the [ComplianceSavedSearch_MT] table in the [FNMSCompliance] database.
The [ComplianceSavedSearch_MT] table will generally be accessed using the [ComplianceSavedSearch] view
This table stores both FNMS reports (visible in the 'Reports' area in FNMS) as well as 'Managed Views' that you create by using the 'Save as' link on a view in the FNMS UI.
For 'Managed Views', the [SavedSearchLink] column will contain the URL of the original view the 'Managed View' is based on, the [SavedSearchFilter] column contains information about the layout of the saved view, as well as any filters (if applicable).
Downlading from the database using these views is not an easy task. Most likely, it will be easier to use the underlying SQL views or stored procedures.
Apr 17, 2023 09:09 AM