Hello,
Can we run a report on 'History tab' for licenses or devices etc., ? I do not see this in existing "reports" and neither can really download each device's or license's history one by one, if I'm looking for 100+ devices history, to find out who and what has been updated to what .?
Regards
Rajesh Ponnala
Feb 20, 2020 06:43 AM
@ImIronMan - Due to the volume of data, the Audit Log of History is not exposed in the UI for reporting or queries. If you have FNMS On-Premises, then you could build a SQL Report against the "FNMS Compliance" database.
The underlying Table\View you're looking for is ComplianceHistory. This table has the details and links back to the various objects and lookup tables.
Feb 20, 2020 06:47 AM
Hi Rajesh,
To add some details to the information that "Captain Kirk" already provided: There is no simple OOTB report for history data.
Obviously, in the on-premises version of FNMS only, you can extract these data using SQL based on the [ComplianceHistory] table in the [FNMSCompliance] database.
For building and exposing a report in the FNMS Web UI, there is a number of "gotchas" though:
Filtering can be done based on a substring in a text fields (Computer Name, Purchase Order Name ...), a date range ([HistoryDate] field) the event type ([ComplianceHistoryTypeID] field) or a combination of these fields.
Building a report based on SQL is not complicated. It generally requires wrapping your SELECT statement into a simple stored procedure, and then calling the 'ComplianceCustomViewRegister' stored procedure for exposing your own stored procedure as a report in the FNMS Web UI.
As a reference, you can look at the SQL code used for creating the various standard reports available in FNMS. All of these reports are created in the 'ComplianceProcedures.sql' file that is used when creating an empty [FNMSCompliance] database.
Feb 20, 2020 09:06 AM
@ImIronMan - Due to the volume of data, the Audit Log of History is not exposed in the UI for reporting or queries. If you have FNMS On-Premises, then you could build a SQL Report against the "FNMS Compliance" database.
The underlying Table\View you're looking for is ComplianceHistory. This table has the details and links back to the various objects and lookup tables.
Feb 20, 2020 06:47 AM
@kclausen Thanks for your super quick response 🙂
Feb 20, 2020 06:54 AM
Hi Rajesh,
To add some details to the information that "Captain Kirk" already provided: There is no simple OOTB report for history data.
Obviously, in the on-premises version of FNMS only, you can extract these data using SQL based on the [ComplianceHistory] table in the [FNMSCompliance] database.
For building and exposing a report in the FNMS Web UI, there is a number of "gotchas" though:
Filtering can be done based on a substring in a text fields (Computer Name, Purchase Order Name ...), a date range ([HistoryDate] field) the event type ([ComplianceHistoryTypeID] field) or a combination of these fields.
Building a report based on SQL is not complicated. It generally requires wrapping your SELECT statement into a simple stored procedure, and then calling the 'ComplianceCustomViewRegister' stored procedure for exposing your own stored procedure as a report in the FNMS Web UI.
As a reference, you can look at the SQL code used for creating the various standard reports available in FNMS. All of these reports are created in the 'ComplianceProcedures.sql' file that is used when creating an empty [FNMSCompliance] database.
Feb 20, 2020 09:06 AM
For another thread asking a similar question (and with a sample query attached in a response), see: Report on History
Feb 20, 2020 11:32 PM