1. Making Spiceworks SQueaL withreports! Grey Howe Western States SpiceTrainer gh@spiceu.com

2. Lots to cover: Reports: What are the kinds of reports? Where are reports viewable? Who can use reports? How can reports be viewed by non-SW users (reporting users andautomatically emailed)? Community Shared reports. SQL: Viewing the database to get our own SQL table and row names. Create our own SQL report. Show off our work to our COWorkers Create a new dashboard just to view a bunch of reports and/or get status on help desk at-a-glance. Insert an automatically generated report in to the User Portal. Q&A 3. Reports Show aggregate data from multiple sources At a glance statistics Help Desk Purchasing Inventory Dashboard Vendors Software 4. Reports Inventory Software Built-in reports and some Licensing embedded to the application How many installed Track unwanted software 5. Reports Purchasing Vendors Depreciation Meeting SLAs? Total Expenditures Spend more elsewhere? Status PO Number 6. Reports Inventory Help Desk Built-in reports and some Basic experience out of the box embedded to the application 7. Using Reports Three kinds of Spiceworks users Admin Helpdesk Reporting 8. Viewing Reports Reporting User Scripted Limited accessEmailed Somewhat confusingSaved for dissemination Public reports only 9. Community Reports & SQL Finding reports Appropriating them for your environment They shared it, lets modify it Be kind to the authors! Spice their reports up! 10. Q&A