I would like to build a report from a SQL query that I have written
rather than property tabs in the GUI. I don't see any option in the GUI
to "see query" or "modify query".

Using Analysis Center version 2.7.579.0

Specifics: I'm looking to create a "Top 10" kind of report. Like the
top ten domain controllers for # of replication events. Pseudocode
looks something like the following:

SELECT TOP 10 <MACHINE NAME>, <COUNT(*)> FROM <EVENT TABLE>
WHERE <KNOWLEDGE SCRIPT NAME> LIKE <AD_Repl... script>
GROUP BY <MACHINE NAME>
ORDER BY <MACHINE NAME> DESC

I can't figure out how to accomplish this in the GUI. Welcome any
suggestions for how I can create such a report. Thanks.

-Rs


--
singer777
------------------------------------------------------------------------
singer777's Profile: https://forums.netiq.com/member.php?userid=7055
View this thread: https://forums.netiq.com/showthread.php?t=50312