Computer Details Report Issues

If the Computer Details report isn't functioning as expected, follow these instructions to confirm that the linked server exists and then change the Power BI Report Server (PBRS) or SQL Server Reporting Server (SSRS) that is linked by default.

Confirm the Linked Server Exists 

To confirm that the linked server exists:

1. Connect to the ConfigMgr SQL Server (MEMCM2, in this example) using SQL Server Management Studio (SSMS). 

2. Expand the Server Objects and Linked Servers folders. Any remote Power BI Report Server (PBRS) or SQL Server Reporting Server (SSRS) to your ConfigMgr Server will be listed. In this example, rms5.dev.recastsoftware is listed. 

A screenshot of a computer 
Description automatically generated

3. If it is missing, create the linked server and make note of the linked server name.  

Change the Linked Server 

This example uses Power BI Report Server, but the steps are the same for SSRS. 

To change the default linked server:

1. In a browser, open the homepage for Power BI Report Server. 

2. Select ConfigMgr_<sitecode>. In this example: ConfigMgr_DV2

A screenshot of a computer 
Description automatically generated3. Click Endpoint Insights. 

A screenshot of a computer 
Description automatically generated 

4. Click Endpoint. 

A screenshot of a computer 
Description automatically generated 5. Hover over the Computer Details report and click the ellipsis (…) for more info. 

A screenshot of a computer 
Description automatically generated

6. Under Computer Details, select Manage. 

A screenshot of a computer 
Description automatically generated 

7. Under RPS2, change the Default value from Reportserver to the Linked Server Name. 
     In this example: [rms5.dev.recastsoftware.com].Reportserver

8. Click Apply. A screenshot of a computer 
Description automatically generated 

8. Run the report to confirm that everything works correctly.   

Copyright © 2024 Recast Software Inc. All rights reserved.