Solved

SCCM 2012 - Reports contain no data (empty)

Posted on 2014-03-23
4
5,334 Views
Last Modified: 2014-03-30
Hi,

We are running a single instance of SCCM 2012 on Windows Server 2008 R2.

We are running SQL 2012 on the same virtual server.

Everything is working fine. Recently I decided to get reports working.

I installed SQL Report Services and used the configuration tool to setup report services. I am able to navigate via the URL. Page is displayed correctly.

I then proceeded to install report services for SCCM. This worked and populated the stock reports into the databases.

I now have a host of reports available for execution from within the SCCM console.

When executing the majority of reports however, they are returned with no data even though I have confirmed that data exists in the SCCM database.

For example, I execute the "Computers with specific software registered in Add Remove Programs". It returns no data. I have limited to certain smaller collections as well as tried various program title search's like "Adobe" .

Yet if I open resource explorer on a particular device under Hardware -> Installed Applications all the data is present.

Most reports exhibit the same issue. I have some hardware reports which actually return data.

I am lost as to where to begin with this. Are there specific logs I can review which may give me a better indication of what is or is not happening?

Site Status for Reporting services point shows a green tick.

Thanks
0
Comment
Question by:BrimbankCC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 14

Expert Comment

by:Abduljalil Abou Alzahab
ID: 39951719
My question is only reports related to software inventory showing empty data ? if yes, make sure that software inventory are enabled on all clients and communication between clients and SCCM are find.. check for example if clients are active or not.

additionally please let me know what reports showing empty data, because as I understand some hardware reports are fine.
0
 

Author Comment

by:BrimbankCC
ID: 39952194
Client communications with SCCM server are fine as everything else works including application deployment.

When you refer to Software Inventory do you mean applications showing up under Hardware -> Installed Applications when using Resource Viewer?

If so then yes that is working as I am able to browse installed apps on each client.

The report I really want working is the "Computers with specific software registered in Add Remove Programs" which is not returning data.
0
 
LVL 31

Accepted Solution

by:
merowinger earned 500 total points
ID: 39953380
have you tried %Adobe%?
0
 

Author Closing Comment

by:BrimbankCC
ID: 39965514
Yep this worked.

Helps if I know the syntax required.

Was trying *Adobe or LIKE %Adobe

Thanks.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question