cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Former Member
Not applicable
Report Inappropriate Content
Message 1 of 4

Epo report and query

Does anyone know that could i able to custom or use somecomand to create a new query for example i just wanna use sql command to create new query

3 Replies
Former Member
Not applicable
Report Inappropriate Content
Message 2 of 4

Re: Epo report and query

Not sure I fully understand the question, but you can create queries in the front end of ePO, then once it is created, put a check-mark next to it, hit Actions > View SQL, then run the query in the back end.

Once you have done that a couple times you can start learning the ePO tables and the joining, then start creating your own. That help?

Former Member
Not applicable
Report Inappropriate Content
Message 3 of 4

Re: Epo report and query

first of all, i want to say thank you for your reply. Yes, i have already seen the sql query command but it doesnt't seem that i can edit those command. Right now,i have some idea to create new query using sql command  but i need to use sql studio to query. Is there anyway on epo to create sql query

Former Member
Not applicable
Report Inappropriate Content
Message 4 of 4

Re: Epo report and query

You can't edit those SQL commands in the front end (ePO), they are only editable within SSMS (sql server management studio). There is no way within the front end of ePO to edit the actual SQL; this can only be done on the backend via an IDE like SSMS.

However, that does not stop you from going into an IDE and start querying the DB however you like. What I found useful was creating queries in the front end and then viewing the SQL behind them like in my original post. Then you can familiarize yourself with the tables, joining, sprocs, views, etc. and then be able to write queries when needed from the backend.

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community