OK. I have had a look on this forum and found some useful information about debugging this particular problem, but its still not fixed.
Most queries I run I get the following:
'Query did not return any results'
I have the latest version of EPO installed and all the services are running as expected (I even rebooted them a good few times too see if that would do anything). One piece of advice was to copy the SQL queries and run them directly in the database, what a great idea. So I did this and the lots of results were returned - showing that the DB is collecting data as expected. So it seems like a problem between the Application collecting the data from the Database.
Any ideas on this?
Solved! Go to Solution.
I'm running the standard queries with no filters or modifications what-so-ever; the one I can think of is Malware Detection query. This worked before but I think ever since we upgrade to 4.5 and on a new server it hasn't.
are you logged in as the admin user on epo, if you are logged in as a user with rights to the queries but not to the underlying data then this would cause this issue.
also if you are collecting compliance data are you running the server tasks to collect data ( generate records for compliance history task)
also do you have the right reporting modules checked in for the point products to allow them to be reported onMessage was edited by: tonyb99 on 14/07/10 10:44:27 IST
OK logged is a admin and I can see the reports! So I need to grant access to the data for other users.... how do I do this? My account was recently given God rights on the EPO database as I needed to run the SQL queries but this obviously isn't enough...
Thank you very much Tony! Not sure why they were set but the permissions were actually holding the security rights BACK as all users are Global Admin, removed and now sorted. Thanks, Dan
Thanks for this - even though my users were Group Admins, they didn't have rights to bunch of different things. Not sure which one allowed the queries to run.