Help with building a reports
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.
2 Comments
[ + ] Show comments
Answers (2)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
10 years ago
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.
Posted by:
TheFergie101
10 years ago
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.
Comments:
-
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. - chucksteel 10 years ago
http://www.itninja.com/blog/view/primer-for-writing-select-statement-queries-on-the-k1000-w-custom-sql-report-example
Use MySQL Workbench - rockhead44 10 years ago
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. - nshah 10 years ago