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.