Huntland Services Ltd

Tel: +44 (0)1392-490518
Fax: +44 (0)1392-428003
Enquiries@huntland.co.uk

Digest of 'Understanding Querying and Reporting'

Based on Microsoft Webcast 20th Aug 2002

Back

Download The Article

 Querying is basically the same.  Reporting is a development of the previously available Web Reporting Tool.

Queries

1. Updated list of queries.
2. Removed all of the Y2K and PC Analyzer queries.
3. A new object type called Metered Software
4. MOF based facility to Export/Import queries. ( Same mechanism is available for Export/Import of Collections, Reports & Software metering Rules).  Standard MOF layout with security definition to be applied to imported object contained inside numerical value 'SecurityVerb'.

Reports

1. Crystal Reports is no longer used.
2. Setup through SMS Admin Console installation
3. Can run reports from SMS Viewed in Internet Explorer or Admin Console
4. Admin Console applies SMS object security to Report Objects
5. Report exporting/importing
6. Integrated backup/recovery because Report definitions held in Database
7. Can use Multiple Microsoft SQL statements per report (including prompts)
8. Report and dashboard cloning
9. Customizable categories
10. Scheduling reports
11. Supplemental reports (.asp files outside SMS made available through the Admin Console)
12. Internationalization of reports based on server localization
13. Support for integrated (Windows) SQL security
14. View schema documented and supported for the first time
15. Must add a Reporting Point New site system role for SMS 2003
16. Requires Windows 2000 Server with IIS 5.0
17. Requires direct access to the SMS site database in Microsoft SQL Server™
18. Internet Explorer 5.01 SP2 or later
19. Office 2000 or Office XP Web components
20. Creates an SMS Reporting Users group