Guys - I've no my sql experience so building reports is an issue for me (actually , any one know a good website or book to start learning)


Anyway, I am trying to pull back a report that shows what machines have the KB2982791 installed in my environment.


Any help or ideas would be great.

Answer Summary:
Cancel
2 Comments   [ + ] Show Comments

Comments

  • Here's a great place to start
    http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example

    Use MySQL Workbench
  • Some other resources are

    http://w3schools.com/
    http://learncodethehardway.com/
    https://www.bento.io/
    http://www.mysqltutorial.org/

    Flyspeed SQL Query is a free tool that works like access for more drag/click SQL building. It is free.
Please log in to comment

Answers

2
For this you don't need MySQL. In the Inventory perform an advanced search for Software Titles contains KB2982791. Once the page loads the results, click Choose Action, Create Report.

Answered 09/09/2014 by: chucksteel
Red Belt

Please log in to comment
2
Hi Chuckstell, thanks for that info. I need to pull this back in a report format as I need to present it to my Head of IT as it has caused numerous blue screens.
Answered 09/09/2014 by: TheFergie101
Blue Belt

  • When you create the report it will give you the SQL code it uses to generate it. Depending on your learning style this could be a good way to dive in and see some MySQL in action and start figuring out how things work.
Please log in to comment
Answer this question or Comment on this question for clarity
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share