This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
rclark0
Level 6
‎Mar 11, 2021 01:16 PM

Device Installation Details Report Source

There is a report called Device Installation Details under License Compliance/Applications. I wanted to be able to pull the information from the datatbase to get the info for a large subset of devices, does anyone know where this report is stored on the DB? We are using on-prem. 

0 Kudos

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.
1 Reply
erwinlindemann
Level 9 Champion
Level 9 Champion
‎Mar 11, 2021 03:11 PM

Hi Rob,

All native FNMS reports are stored in the [FNMSCompliance].[ComplianceSavedSearch] table.

The 'Device Installation Details' report that you are interested in is executing a stored procedure named 'ReportDeviceInstallationDetail'. This stored procedure has two parameters (@ComputerId, @RowLimit). The second @RowLimit parameter (maximum number of rows to be returned in the report) is optional.

To test this, for @ComputerId you need a valid 'ComplianceComputerID' value from the [ComplianceComputer] table. Let's assume that @ComputerId=5. To retrieve installation details for this computer, you only have to execute the following statement from Microsoft SQL Server Management Studio (SSMS):

 

EXEC ReportDeviceInstallationDetail 5

 

Performance of this stored procedure is lousy though. If you want to use the SQL of the stored procedure for running it on multiple computers, you should consider rewriting it and/or storing the output of the stored procedure in a caching table.