Not getting any results from Reporting Service - Compliance 5 - Specific Computer

Kody 256 Reputation points
2022-05-23T21:26:55.547+00:00

Running a report for Compliance 5 - Specific computer not getting any results for a specific device compared for a different device.

As an example 'Device1' would get the specific updates that are either 'Approved', 'Installed' and/or 'Is Required'.
204720-compliance-5-specific-computer-01.png

For 'Device2', It shows non.
204871-compliance-5-specific-computer-02.png

What logs and what ports (firewall) Should I be looking for probable cause for 'Device2'? I've tried looking at 'C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles' but haven't seen any specific for Device1 or Device2.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,799 questions
Microsoft Configuration Manager
0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amandayou-MSFT 11,046 Reputation points
    2022-05-24T03:12:32.337+00:00

    Hi @Kody ，

    Please login on the SQL server reporting services configuration manager, and click the tab of Web portal URL, use the URL to check if it is same as the console. Actually, the reports on the sccm console is from the SQL.

    204922-5241.png

    204931-5242.png

    If so, we should check if the Device 2 is normal on the SCCM console, the green iron shows it is normal. Overall, normal client can show the reports in the console and report the data to the SQL.

    204903-524.png

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Garth 5,801 Reputation points
    2022-05-24T10:55:39.54+00:00

    Here is the list of log file and what they are used for. https://learn.microsoft.com/en-us/mem/configmgr/core/plan-design/hierarchy/log-files
    From your screenshot it is clean that device2 is no returning results to cm. This could be a million things. Start by checking that the device is healthy.

    0 comments
  3. Kody 256 Reputation points
    2022-05-24T21:43:09.9+00:00

    Hi @Amandayou-MSFT ,

    Yes, I get the same results for 'Device2' using the web portal for the Reporting service.
    205281-web-portal-compliance-5.png

    I've also verified that 'Device2' has a green status and client
    205235-device2-status-green.png

    @Garth ,

    Thanks for the URL link to Log file reference. I've checked srsrp.log, srsrpsetup.log and srsrpMSI.log files using CMTrace and could not find any are flagged and any references to 'Device2'.

    Could this be firewall related...? I'm not sure that port would it need open. From the config mgr, I can a open a share to the Device2's C: drive. The reason I'm asking if firewall, another group has control of the subnet firewall that Device2 is in.

  4. Garth 5,801 Reputation points
    2022-05-25T10:31:10.787+00:00

    It will not be related to the reports or reporting point themselves, it will be the health of the client. You need to review the client's health to see why it is not returning results.

    0 comments
  5. Kody 256 Reputation points
    2022-06-01T19:56:34.727+00:00

    @Amandayou-MSFT ,

    Sorry it took a while to get back, had to wait to fix the network firewall and client over the 3 day weekend. It turns out that the firewall was changed recently and to be re-adjusted by IT group who manages the subnet. The report wasn't really getting all the information from Device2. I then reinstalled the client, per your suggestion, on Device2- the re-install did the trick.